The RapidAPI add-on for Google Sheets allows you to make API requests to any API on RapidAPI from within a Google Sheet, and embed the data you get back into the sheet.
This tutorial will walk you through the basics of using the add-on.
Request Automatically Being Run
Whenever a Google Sheet is reloaded or reopened, the API request will be run. You need to take this into account when selecting your pricing plan and monitoring usage. If you have any questions about this, please contact [email protected] before utilizing the add on.
To install the plugin, simply head to this link and install the add-on. This will prompt you for permissions - which are required as this add-on makes requests to external APIs.
By default, the add-on will be disabled in your sheets. Before using it in a certain sheet, you must enable it for that sheet. To do so:
- Open the sheet you want to use the add-on in.
- Open the “Add-ons” menu in the top of the window.
- Click “Manage Add-ons”
- You should see the RapidAPI Add-on there - click the green “Manage” button next to it and select “Use in this document”. Once selected it should have a check next to it.
The simplest way to use the add-on is using the GET function. The GET function gets information from an API, and puts it in the spreadsheet. It also allows you to pass information to the API which can be dynamically pulled from another cell like in a regular formula.
Before connecting to the API, head to RapidAPI.com to find the API and endpoint within that API that you want to consume. In this example, we’ll use the Book endpoint from the IEX trading API to get information about a stock. In the API page in RapidAPI you can find all the information required to use the API, as you can see in the screenshots below.
To make a request to the API, use the
GET function with the following parameters:
URL- this is the URL of the endpoint you’re using, as seen on the first screenshot. In this case it’ll be:
SelectPath- this will highlight what part of the response data you want to pull into the spreadsheet. You can see the full response data on the second screenshot. If you want to pull in the company name for instance, use
You can also pull multiple parameters by separating them with commas. They will be presented in adjacent cells along the same row as where the formula is. For instance, use:
ApiKey- this is your API key to use APIs through RapidAPI, seen on the first screenshot.
For each parameter (which can be seen on the second screenshot), you should pass two arguments to the function - the
In this example, the only parameter is symbol, to which we can pass AAPL as an example.
Note that the parameter value can also reference another cell, to pull the value dynamically.
The full formula will thus be:
You can also watch the full process in the video bellow:
Updated about 1 year ago