Skip to content

Find A Customer Industry Using An Email From The Company On Google Sheets

Bringing together as much customer data as possible is one of the first steps to having a successful business. That way you can generate products that adapt to each of your needs. There are some APIs that bring all that information immediately, but sometimes it’s hard to crack.

One of the biggest difficulties is finding the perfect tool to gather all that information. But once you find it there may be other problems such as the format in which it is delivered. Even the way in which it is searched, because the first result may not have all the necessary information.

Luckily there is an easy formula to pass all the information you need from your API to Google Sheets, so you can have the information at your fingertips and in a way you know.

The first thing to do is to open one of the Customer Research APIs, GetZyla in this case would be the fastest since it only requires a business email to generate information. Once the information is searched in GetZyla what you have to do is write the following formula in Tools.

Within tools you have to enter Tools you have to enter Scrip Editor and copy the following code.

function FETCH(url) {

var response = UrlFetchApp.fetch(url);


var out = JSON.parse(response.getContentText());

return out[0][“domain”];}

You see and example of this in this link.

Now you can have all the information you want just by putting the business email of whoever you want, all thanks to the Fetch function installed in your Google Sheets.

The best option was always GetZyla since it uses Machine Learning to generate the information you are asking for. That’s why you only need an email and you can receive everything in JSON format.

Zyla Use Cases

  • Content Classification

Zyla Text analyzes a document and creates a list of content categories that apply to the text contained inside it.

  • Document Processing

Zyla Text makes data capturing at scale easier and reduces document processing costs.

  • Customer Profiling

With Zyla Text, you can turn each customer’s email or domain into an enriched company profile and industry.

  • Fraud Detection & Web Filtering

Zyla Text uses powerful machine learning to classify billions of domains. Our API analyzes a company’s website and categorizes it into 385+ topic areas (IAB V2 standard).

  • Classify products into categories

Zyla Image predicts the class of a specific object in an image. The main goal of this technique is to precisely identify the qualities in an image.

  • Video Moderation

You can use Zyla Video to find stuff that is inappropriate, unwanted, or objectionable. Businesses can use Zyla Video API in social media and e-commerce contexts to give a safer user experience.

Main Features

  • Form shortening:

Hide or autofill fields to keep forms short while collecting the information you need.

  • Advanced email personalization:

Increase engagement by sending emails that are more relevant to the job role, company size, or any of our 100+ data points.

  • Keep your entire lead database fresh:

This automatically refreshes all of your records so you always have the most up-to-date information.

Also published on Medium.

Published inAppsSaaSStartupsTechnology

Be First to Comment

Leave a Reply

%d bloggers like this: