How To
May 12, 2023

30 Days of Data Enrichments: Week 2 No Code Examples

May is well under way, and that means we are celebrating the Custom Enrichment feature, which allows for no code execution of data enrichment APIs. If you can copy and paste an API request and follow a simple step-by-step guide, then you can enrich your sheet with third party data.

If you missed our week 1 Week 1 Recap that covered everything from geolocation to Artificial Intelligence (AI), to Star Wars, you can find it here. And you can always find the full list of enrichments on our No Code APIs page.

Week 2 continues to illustrate the breadth of data enrichment APIs. We highlight topics ranging from fake data generation to capturing Google Search results, to food and nutrition data. We also offer additional Geolocation and email validation options. Plus, we celebrate the launch of The Legend of Zelda: Tears of the Kingdom. Read on to learn more!

Week 2's No Code Examples of Data Enrichment API's

fake company data api

Faker's Fake Company Data API

Faker's Fake Company Data API is a set of completely free APIs that helps generate fake company data that is useful to anyone in need of fake data. Who might that be? Well, developers, designers, and marketers often use fake data for testing or content creation. It's a useful tool and sure beats making it yourself.

Faker fake company data api in Gigasheet
Experian Phone Validation API


Experian Phone Validation API


Need to validate a list of phone numbers before having your team call? Experian has you covered with their Phone Validation API. Send it a number and it will return a validation along with supplementary information such as whether the number is a landline or cell phone.

Experian Phone Validation API in Gigasheet
Geocode.xyz forward geocoding API


Geocode.XYZ Forward Geocoding API

Geocode.xyz APIs can help with Geocoding, Reverse Geocoding, and Geoparsing. What's that mean? Basically, translating latitude and longitude coordinates into addresses and vice versa. The forward geocoding API accepts an address as an input and returns a set of latitude and longitude coordinates.

Geocode.xyz forward geocoding API in Gigasheet
Open Food Facts API


Open Food Facts Get a Product Nutri-score API

Ever wonder what ingredients or how many calories are in your snack? Open Facts maintains a food product database that happens to have a nifty API. Use the Open Food Facts API to enrich a list of barcodes with nutrition and ingredient information.

Open Food Facts API in Gigasheet
API Layer Exchange Rates API


API Layer Exchange Rates Data API

Exchange rate information is always changing. Keep your spreadsheet up to date with real time exchange rates data using the API Layer Exchange Rates API. Simply provide a currency code, and the API will return the latest exchange rates.

API Layer Exchange Rates API in Gigasheet
Google Custom Search API


Google Custom Search API

Ever have the desire to run a list of google searches in a spreadsheet and save the responses? Well, it's possible using the Google Custom Search API. This could be especially useful for SEO optimization or market research, documenting how the search results change over time.

Google Custom Search API in Gigasheet
Hunter io Email Verifier


Hunter Email Verifier API

Hunter is the leader in the email verification space, offering many ways to look up and validate professional email addresses. Before you launch your next email campaign, make sure you have the right contact information for success. The Email Verifier API confirms the validity of an address as well as returning a confidence score. We also profiled other APIs from Hunter:

Email Finder API

Domain Search API

Hunter io Email Verifier in Gigasheet
Hyrule Compendium API


Aarav Borthakur's Hyrule Compendium API

The Legend of Zelda: Tears of the Kingdom is finally here! In honor of such a momentous occasion, we are featuring The Hyrule Compendium API that returns details about items and creatures in the Legend of Zelda: Breath of the Wild universe. Have fun gaming this weekend!

Hyrule Compendium API in Gigasheet

Custom Enrichments in Action

Keep checking back this month of May to see more examples of data enrichment APIs. If you haven't watched Jason demonstrate no code APIs, then head to our YouTube channel. Sign up for free to try it today!

The ease of a spreadsheet with the power of a database, at cloud scale.

No Code
No Database
No Training
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.