Custom Enrichments: Run Any Data Enrichment API without Code

A Data Product is a high-quality, trustworthy, and accessible data set that an organization can use to solve business challenges. To create a useful Data Product, you are likely going to need to enrich your primary data with information from other sources. 

Oftentimes, this involves combining data from multiple systems within your organization. For instance, you want to combine your sales CRM data with backend product usage data to see which customers are approaching usage limits. A simple data dump from both systems, a spreadsheet, and the trusty V-Lookup function can be used to combine data based on column values.

However, what if you need to do something more advanced than just combining files? Let’s say you want to bring in data from outside your organization and run 3rd party software on your data values? Luckily, in the modern Software as a Solution ecosystem, there are plenty of APIs that allow you access to a variety of functions. Some are free, and some are paid. The possibilities are endless.

Sounds easy, but how do you actually run an API? If you are a developer, a simple python script can accomplish this task. But what about the rest of us business users who know spreadsheets, but not necessarily coding?

No Code API Execution

In our mission to democratize big data, Gigasheet is introducing the ability to execute no-code APIs through our Custom Enrichment feature. If you can find an API on the internet, then you can run it! 

Gigasheet already offers free email validation and bulk IP address lookup functions. As we were looking to expand our offerings, we realized that we will never be able to guess what our customers will need to enrich next. People use Gigasheet for so many different purposes across different industries. Instead, we decided to focus on creating a flexible tool that anyone can use to execute enrichment APIs. And it’s super easy:

How it works:

  1. Load data into Gigasheet containing the columns for enrichment.
  2. Copy and paste the API request from the data enrichment API provider.
  3. Customize the API and merge cell values from your sheet.
  4. Map the API results to new columns to be added to your sheet.
  5. Run the Data Enrichment API on your sheet.
  6. Profit!

Below, we walk you through executing a sample API so you can see for yourself how powerful this tool really can be!

30 Days of Enrichments

You may be feeling a little overwhelmed right now because the internet is so full of wonderful data enrichment APIs, and you don’t know where to start. Well, we can help you with that too! 

Gigasheet is doing 30 days of data enrichment api in May

During the month of May, we will be publishing 30 examples of enrichments using the Custom Enrichment tool. We are going to cover everything from AI, to Geolocation, to people lookups.

Stay tuned to gigasheet.com and to our blog as we walk through 30 Days of Enrichments.

 

Running a Data Enrichment API

We are going to demonstrate how easy running a data enrichment can be using Gigasheet. Stay tuned for 30 more examples, but we are going to start with Clearbit’s Autocomplete API, that lets you autocomplete a company name and retrieve logo and domain information. 

Jason walks through no code api execution using Gigasheet

Step 1. Load a list of company names in Gigasheet and Open the Enrichments Function

Choose Functions -> Enrichments

no code api enichments


Then choose Custom Enrichment from the Enrichments modal.

Custom Enrichment offers no code api builder

Step 2. Copy and Paste the API Request from the API provider

In this case, it is very short and sweet:

GET https://autocomplete.clearbit.com/v1/companies/suggest?query=:segment

Where :segment is the partial name of the company.

Copy and paste that value into the Custom Enrichment box and hit Next.

Execute a data enrichment api

Step 3. Customize the API and Merge Cell Values from your Sheet

Some APIs require a token to execute, but that is not the case with the AutoComplete API. Looking at the url, the only input required is the “query=:segment”. We are going to Gigasheet’s Custom Enrichment to merge in a value for the name for each row in our sheet.

Highlight that text and then use the dropdown to Select Column Reference that contains company info. Hitting Insert Column Reference will overwrite the “:segment” text with a placeholder for the Gigasheet column value. 

customize the no code api

Step 4. Map the API Results to New Columns to be Added to Your Sheet

You will be presented with the results of the API call for the first 3 rows of data, giving a sample of what will be populated in your sheet.

The Clearbit documentation says that the following data will be available:

And you can see these available in Gigasheet. Use the checkboxes to select as many, or all, of the data returned from the API.

Results of the data enrichment api

Step 5. Run the Data Enrichment API on Your Sheet

Hit Apply and then confirm execution of the Custom Enrichment. Enrichments only run on the current result set, so you can control the number of rows processed by filtering your data.

Executing a no code api

Once complete, your data will look something like this. As you can see, columns now exist for domain and name of the company.

company data enrichment api results

Wrapping Up

With Custom Enrichments, Gigasheet has built a flexible tool that allows anyone the ability to execute data enrichment APIs on huge quantities of data. No coding experience is required to create a data product full of high-quality, verified data. We will be providing you with samples all month long, so be sure to check back often. And if you want to tell your boss that you learned how to write code to run APIs, then your secret is safe with us!

Try it out for free today!

The ease of a spreadsheet with the power of a data warehouse.

No Code
No Training
No Installation
Sign Up, Free

Similar posts

By using this website, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts. View our Privacy Policy for more information.