In this tutorial, I’m going to show you how to connect a REST API to Google Sheets, without writing any code.
Calling a REST API in Google Sheets is as easy as installing the Apipheny app, then opening the app in your Google Sheet, entering your API request, and clicking “Run”.
Keep reading for instructions on how to import REST API data into Google Sheets.
First let’s start with what is an API? API is an acronym that stands for application programming interface. Developers create APIs for their applications/softwares so that other developers can communicate and retrieve data from their software. You can think of an API as a data pipeline between two apps.
REST is acronym that stands for Representational State Transfer. A REST API is an API that follows a specific set of rules.
Creating a REST API allows other developers to quickly understand how to use the API, because REST is sort of a universal set of rules that the development community has agreed on using. It makes life easier for everyone.
To import REST API data into Google Sheets, we’re going to install a Google Sheets add-on, enter our REST API request, and then run the request and the data will automatically populate the Google Sheet.
Let’s get started.
To call a REST API in your Google Sheet without writing any code, first install the Apipheny Google Sheets add-on.
Apipheny is a REST API integrator for Google Sheets. With Apipheny, you can make unlimited REST API calls to almost any REST API from your Google Sheet.
You can also save your REST API requests and schedule your API request so that the data refreshes in your Google Sheet every hour, day, week, or month.
After you install Apipheny, you’ll need to open it in your Google Sheet.
To open the Apipheny add-on, go to any Google Sheet, then click Add-ons or Extensions in the menu at the top.
In the dropdown menu, you should see Apipheny. Just click Apipheny > Import API to open the sidebar.
After you’ve installed and opened Apipheny, your next step is to enter your API request into the add-on.
Every REST API has an API URL. Just enter your API URL into the add-on, where it says “API URL” field.
For this example, we’re going to use the coinmarketcap API, which is a RESTful JSON cryptocurrency API.
Here’s what our coinmarketcap API URL looks like when entered into Apipheny:
If your REST API has any parameters, add them to the end of the API URL in the API URL field.
If your REST API requires headers, you can enter them into the “Headers” fields of the add-on, like this:
After you’ve entered your REST API request (URL and headers) into Apipheny, all you have to do is click “Run” and your REST API data will be automatically imported into your Google Sheet.
Here’s what our cryptocurrency REST API data looks like when imported into our Google Sheet:
After clicking “Run”, Apipheny will automatically retrieve the REST API data and convert it into your Google spreadsheet for you, without needing to write any code.
Once you import your REST API data, you can use the Apipheny add-on to query a different endpoint or a different REST API.
With Apipheny, you can also:
Make a GET request
Make a POST request
PUT, PATCH, & DELETE Requests
Save requests for later
Schedule requests for automatic updates
Reference cell values in requests
=APIPHENY custom function
Stack multiple URLs in a single request
Run all saved requests at once
Modify your request settings
Import & export saved API settings
Alpha Vantage API
Constant Contact API
Facebook Graph API
Facebook Ads API
Google SERP API
Linkedin Ads API
Product Hunt API
Reddit Ads API
Riot Games API