The story behind Galanthis’ development is a simple one, and if you’ve ever tried to incorporate API’s into Google Sheets, you’re probably familiar with it. Before Galanthis, you had three options, convert the data manually, run poorly performing Google App scripts, or subscribe to expensive third-party automation add-ons.
Galanthis operates with native Google Sheets functions like IMPORTDATA
, you don’t need to install anything.
Zero hassle, it’s simple.
> In this example, we’ll pull the public holidays for Argentina during 2021.
> Data provided by https://date.nager.at/
We will use the following function in Google Sheets to achieve this.
=IMPORTDATA("https://galanthis.p.rapidapi.com/v1/transform?url=https://date.nager.at/Api/v2/PublicHolidays/2021/AR&rapidapi-key=")
Let’s break this down.
Google Sheets’ IMPORTDATA
function allows us to pull CSV files directly into a Sheet via a URL ^1
https://galanthis.p.rapidapi.com
is our API host, v1
the API version and transform
the API endpoint that will convert JSON to CSV. From here, we pass the URL we want to convert (https://date.nager.at/Api/v2/PublicHolidays/2021/AR) to the url
parameter, and finally your Galanthis RapidAPI Key ^2 via rapidapi-key
The Raw JSON from https://date.nager.at/Api/v2/PublicHolidays/2021/AR
After Importing to Google Sheets via Galanthis
There we have it, a super simple demonstration of Galanthis’ integration with Google Sheets. You can get started for free at https://rapidapi.com/Quantel/api/galanthis
1: Learn more about Google Sheets’ IMPORTDATA
function
https://support.google.com/docs/answer/3093335?hl=en
2: Use RapidAPI Keys in URL
https://docs.rapidapi.com/docs/keys#passing-an-api-key-via-query-parameter