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