Todoist

Google Sheets + Todoist Integration

Query from Todoist into Google Sheets  or Post and Sync data from Google Sheets into Todoist

What is Sheet Director?

Sheet Director is a Google Workspace add-on that helps to manage and control bi-directional data flow between Google Sheets and several other applications like Google Calendar, Tasks, Contacts, Sheets, QuickBooks, FreshBooks, Zoho, PayPal, etc. 


It is available in the Google Workspace Marketplace. Please check the Installation instructions to install the add-on. 

What is Todoist?

Todoist is a popular task management and to-do list application used by millions for organizing work and life, allowing users to manage tasks, set reminders, and collaborate on projects. 

Todoist to Google Sheets: Use Case(s)

> Pull data from Todoist objects and store it into a spreadsheet - Query

> Post data from Google Sheets into Todoist - Post

> Synchronize data from Google Sheets into Todoist - Synchronize

Todoist

Sheet Director

Google Sheets

Setting up Todoist in Sheet Director

Choose App and Service:


Todoist Configuration




Destination Settings:

Scheduler Settings:

Notification Settings:

Sample Output

Google Sheet to Todoist - Post

Source Sheet

(the default value is A1, if you change the value you need to refresh the header by clicking on refresh icon on side)


Mapping

Sample Output

It will show the count of number of records posted successfully and failed to post.

Synchronize - Todoist and Google Sheet

Synchronize settings:

Synchronization Keys:

The keys will be used for matching rows in Google Sheets with data in Todoist.

Conflict Resolution: 

Todoist  Wins: The Latest data from Todoist will be updated in Google Sheets.

Google Sheet Wins: Latest data from Google Sheets will be updated in Todoist.

Note: The major requirement in synchronization is the synchronize keys. If any of the keys is not having a value in the Google Sheet then Sheet Director will create it first and then the service will be executed.

Todoist Wins

Select Todoist wins under Synchronize Settings

Here the Todoist data is edited, and on execution, this data will be updated in Google Sheets.

Synchronize with Sheet Settings

Sample Output

Google Sheet Wins

Click Execute to execute the data.

Sample Output