Search API Connector Documentation

Print

Import Todoist Data to Google Sheets

In this tutorial we will show you how to use the Todoist API with Google sheets, using the API Connector add-on for Sheets.

We will first register to the website to get a personal token and then set up some requests to pull and push data to and from the API.

Contents

Before You Begin

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

Part 1: Get Your Todoist API Token

  1. Navigate to https://todoist.com/prefs/integrations
  2. You will see your personal API token, as depicted in the picture below. That's it, click to save it.

Part 2: Pull Todoist API Data into Google Sheets

For this example, we'll get a list of projects.

  1. Open up Google Sheets and click Extensions > API Connector > Open > Create request.
  2. In the request form enter the following:
    • ApplicationCustom
    • MethodGET
    • Request URLhttps://api.todoist.com/rest/v1/projects
    • Headers:
      • AuthorizationBearer your_token
  3. Create a new tab and click Set current to use that tab as your data destination.
  4. Give a name to your request and click Run. You should be able to see the pulled data.

Part 3: Post Data to ToDoist

To create a project in Todoist use the following settings. Substitute in your own token and project name.

  • ApplicationCustom
  • MethodPOST
  • Request URLhttps://api.todoist.com/rest/v1/projects
  • Headers:
    • AuthorizationBearer your_token
    • Content-Type: application/json
  • Request body: {"name":"Shopping List"}

After you send this request, you should immediately be able to see your created project.
todoist-post

Part 4: API Documentation

Official API documentation: https://developer.todoist.com/rest/v1/#overview

Leave a Comment