Import Coda Data to Google Sheets

Last Updated OnMarch 19, 2024

byAna

In this guide, we’ll walk through how to pull data from the Coda API directly into Google Sheets, using the API Connector add-on for Sheets.

We'll first get an API key from Coda, and then set up a request to pull in data to your spreadsheet.

Before You Begin

Click here to install the API Connector add-on from the Google Marketplace.

Sign in to Coda and navigate to the Account Settings by clicking on the Profile icon at the top right corner, then click on the three dots that appear in the drop down and select Account settings (or click here: https://coda.io/account)
Scroll down to the API SETTINGS section and click Generate API token.
A modal to set token name and set restrictions will be open. Give your token name and if you want to set special restrictions configure that in the Add a restriction section.
Click on Generate API Token a new token will be generated and it will appear in your list of token, click on Copy token and copy the token to your clipboard.
Once you have your API token, you're all set! You can now connect to Coda's API.

For this example, we'll get a list of Coda docs

Open up Google Sheets and click Extensions > API Connector > Open > Create request.
In the request form enter the following:
- Application: Custom
- Method: GET
- Request URL: https://coda.io/apis/v1/docs
- Headers:
  - Authorization: Bearer your_api_token
Create a new tab and click Set current to use that tab as your data destination.
Name your request and click Run. A moment later you’ll see Coda data populate your sheet.

Coda limits the number of records returned on a response. By default, not all records will be returned unless you page through data as shown in their documentation.
With API Connector you can loop through these URLs automatically with cursor pagination handling, like this:
- Pagination type: next page URL
- Next token parameter: nextPageLink
- Run until: choose when to stop fetching data