Search API Connector Documentation


Import KoBoToolbox Data to Google Sheets

In this guide, we’ll walk through how to pull Kobo API data directly into Google Sheets, using the API Connector add-on for Sheets. We’ll first get an API key from Kobo, 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 Kobo API Key

  1. While logged in to your Kobo account, check the domain in the address bar. For most people, this will be either or (this article describes the difference).
  2. Now navigate to https://YOUR_DOMAIN/token, i.e. or Copy the token that you see there. That’s it, you can now access Kobo’s API.

Part 2: Create your Kobo API Request URL

We’ll first get a list of your assets.

  • API root: https://YOUR_DOMAIN/api/v2/ ( or
  • Endpoint: /assets.json

Putting it all together, we get the full API Request URL:

Part 3: Pull Kobo API Data into Sheets

We can now enter our values into API Connector.

  1. Open up Google Sheets and click Extensions > API Connector > Open.
  2. In the Create screen, enter the Request URL we just created
  3. Under Headers, enter two sets of key-value pair like this:
    AuthorizationToken YOUR_API_TOKEN

    Replace YOUR_API_TOKEN with the token you got in the first part.

  4. We don’t need OAuth2 authentication so just leave that set to None.
  5. Create a new tab and click Set current to use that tab as your data destination.
  6. Name your request and click Run. A moment later you’ll see a list of your Kobo assets (forms/projects, questions, blocks, templates, collections) populate your sheet.

Part 4: More Example API URLs

You can try the following URLs:

  • View all public collections
  • View private collections
  • View user metadata
  • View permissions
  • View details of a specific survey
    https://YOUR_DOMAIN/api/v2/assets/{asset uid} (get the uid from the /assets endpoint)
  • View submitted data
  • Create or view data exports

Part 5: API Documentation & Information

Kobo hasn’t provided much documentation, but here are a few links for more information:

Previous Import Klaviyo Data to Google Sheets
Next Import Kraken Data to Google Sheets

9 thoughts on “Import KoBoToolbox Data to Google Sheets”

Leave a Comment

Table of Contents