Google Tasks

Google Sheets + Google Tasks Integration

Query from Google Task into Google Sheets  or Post data from Google Sheets into Google Task

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 etc. 


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

What is Google Tasks?

Google Task is a free online service for managing your to-do lists. 

Google Task app enables you to create tasks and task lists from the form data .

Google Calendar to Google Sheets: Use Case(s)

> Get Tasks: Pull the all my tasks from Google Tasks into Google Sheets

> Post Tasks: Post all data from Google Sheets into Google Tasks.

Google Tasks

Sheet Director

Google Sheets

Demo Video: How to Integrate Google Sheets & Google Tasks?

Setting up Google Tasks into Sheet Director

Choose App and Service:


Google Task Configuration:


Destination Settings:

Scheduler Settings:

Notification Settings:

Sample Output

The below image shows the data that is obtained from Google Tasks.

Google Sheet to Google Tasks - Post

Entity

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.