Galanthis

フリーミアム
よって guy | 更新済み vor 2 Monaten | Data
Health Check

N/A

フォロワー:2
API作成者:
Rapid account: Guy
guy
Quantel
評価APIにログイン
評価:5-投票:1

README

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