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
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.
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.
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.
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.
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.
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.
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:
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!
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 data warehouse.
