Track your Google Tasks to-do list in Google Sheets with Integration


With a few simple steps, build a robust workflow that automatically adds new Google Tasks as rows in your chosen Google Sheet using Integration.


Set up a trigger action

Login to your Integration tenant, create a new project or choose an existing one. Go ahead and get started by creating a blank workflow. If you need a refresher on how to get to this point, this guide can be a great introduction.

Click on the small setting icon on the Start step and choose the Google Tasks polling trigger.

Select Task created as a trigger and complete the authorization – connect Integration with your Google Tasks account and select a task list. Here, you can also set a polling interval from the dropdown menu - this time interval determines how often you want this trigger to check for new tasks.

Click Save. You should see the test trigger window.

To test your trigger, you need to perform the trigger action. Open your Google Task Manager and create a new task providing a Title, Description and Date/Time:

New Google task

Go back to the Integration workflow and click Test. You should see the output data from the trigger which Integration will use to configure and test the rest of the workflow. Click Done.

Configure the spreadsheet connectors

Add the Google Sheet connector to the canvas with the drag and drop feature. This automatically connects with the trigger action.

Add Google Sheets connector

Click on the small settings icon on the Google Sheets connector, select Add row as action and complete the authorization – connect Integration with your Google account (check the following Tutorial - Using Google services with Integration).

Click Next.

Before you can proceed with the action configuration, you need to make sure you have already created a sheet containing several columns where you will store information about your tasks:

Now go back to the Integration action configuration and choose the spreadsheet ID and the sheet name. Use the Incoming data panel and the drag and drop feature to fill out the task information for each table column:

Click Next, Test and then Done.

Connect the Google Sheets connector to the Stop step. Don’t forget to save your workflow.

Test the workflow

You can now run the workflow using the play button in the right upper corner and review the result. If you have configured the workflow correctly, you should see the newly created row added to Google Sheets:

Now every time a new task is added to your Google Tasks list, a new row will be added to your Google Sheets. Please note that this may take some time.

Monitor the workflow execution

At the bottom-left corner of the screen you can find the Execution history of the workflow:

From here you can monitor the execution status and view error details if needed:

Please note that workflow execution logs must be enabled from the workflow execution settings:

Workflow settings button

Related articles

For more Integration workflow examples involving Google applications, refer to the following articles:

1 Like