Import Coda Data to Google Sheets

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.

Part 1: Get Your Coda API Key

  1. 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:
  2. Scroll down to the API SETTINGS section and click Generate API token.
  3. 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. Generate token UI
  4. 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.
    copy token
  5. Once you have your API token, you're all set! You can now connect to Coda's API.

Part 2: Pull Coda API Data into Sheets

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

  1. Open up Google Sheets and click Extensions > API Connector > Open > Create request.
  2. In the request form enter the following:
    • Application: Custom
    • Method: GET
    • Request URL:
    • Headers:
      • Authorization: Bearer your_api_token
        API request settings
  3. Create a new tab and click Set current to use that tab as your data destination.
  4. Name your request and click Run. A moment later you’ll see Coda data populate your sheet.

Part 3: More Example API URLS

  •<doc ID>/pages
  •<doc ID>/tables
  •<doc ID>/tables/<table ID>/columns
  •<doc ID>/tables/<table ID>/rows
Click here to find your doc ID:

Part 5: API Documentation

Official API documentation

Leave a Comment

Jump To