Galanthis

FREEMIUM
By guy | Updated לפני שנתיים | Data
Followers: 2
API Creator:
Rapid account: Guy
guy
Quantel
Log In to Rate API

README

Easily use API endpoints in Google Sheets by converting JSON to CSV.

Intro

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.


Video demo


Basic Example

> 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
Alt text

After Importing to Google Sheets via Galanthis
Alt text

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

Rating: 5 - Votes: 1