How To
May 19, 2023

30 Days of Data Enrichments: Week 3 No Code Examples

Have you ever wanted to run an API, but have no idea how? Gigasheet has you covered with our Custom Enrichments that allow for no code execution of data enrichment APIs. If you can follow a simple step-by-step guide and handle copying and pasting data, then you can enrich your sheet!

This is the Week 3 recap of our 30 Days of Enrichments. If you missed previous editions, go here:

  • Week 1 recap includes geolocation, Artificial Intelligence (AI), and Star Wars APIs
  • Week 2 recap includes fake data generation, Google Search results, food and nutrition, and Legend of Zelda APIs

And you can always find the full list of enrichments on our No Code APIs page.

Week 3 brings a variety of data enrichment APIs, covering topics ranging from pollution to stocks, to cybersecurity data. We also cover fun APIs providing information on Makeup, Artwork, and Breweries. You can see where our mind is on a Friday afternoon. Read on to learn more!

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

openweather api

OpenWeather's Air Pollution API

OpenWeather's Air Pollution API returns current, forecast and historical air pollution metrics for any coordinates (latitude and longitude) that you supply. OpenWeather offers several weather APIs that provide both historical and forecast data. Try them using the Custom Enrichment feature!

paste in the Air Pollution API from openweather api
crowdsec cti ai

CrowdSec's Cyber Threat Intelligence (CTI) API

The CrowdSec CTI API provides frictionless access to accurate cyber threat intelligence, enabling you perform threat research on your log files in Gigasheet. Simply pass in an IP address and retrieve the latest data on intrusion attempts, origins, and trends.

the crowdsec cti api request
Open Brewery DB API

Open Brewery DB's List Breweries API

The Open Brewery DB API provides access to the Open Brewery Database, containing information on breweries, cideries, brewpubs, and bottle shops. Thirsty yet? You simply pass in latitude and longitude coordinates and retrieve a list of nearby breweries. It's 5 o'clock somewhere!

cURL request for the Open Brewery DB API
polygon stock API

Polygon Stock API

The Polygon Stock API provides endpoints that let you query the latest stock market data and ticker information from US stock exchanges. Simply pass in a stock ticker and retrieve accurate historical and real-time data from Polygon API, allowing you to bring market awareness to your data in Gigasheet!

cURL request to polygon stock API

National Plan and Provider Enumeration System (NPPES) API

The National Plan and Provider Enumeration System (NPPES) NPPES API allows systems to is a free directory of all active National Provider Identifier (NPI) records. What's an NPI number? It's a unique id for doctors, dentists, and other healthcare providers. And you can look them up using an API. Give it a try!

paste in nppes api request from the documentation
The Met API call

The Met API

The Metropolitan Museum of Art, also known as "The Met", has created The Met Open Access API that provides access to a dataset of information on more than 470,000 artworks in its collection. Use Gigasheet to enrich your own artwork dataset with metadata on select artwork, including artist, country of origin, and materials used.

The Met API call

Makeup API

Makeup API

The Makeup API is a public API that provides information about makeup products from various brands. Use the Makeup API to retrieve a list of all makeup products, filter products by brand or type, search for products by name or ingredient, and add the data to your sheet.

curl request for the Makeup API

Custom Enrichments in Action

That wraps up week 3 of our 30 Days of Enrichments. Come back next week to discover more data enrichment APIs. And if you haven't seen Custom Enrichments in action, watch this video now!

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.