Track your Google Tasks to-do list in Google Sheets with webMethods.io Integration
Tags: integration, google, googlesheets, tasks
Published: 2024-04-16 11:12:15

---
title: Track your Google Tasks to-do list in Google Sheets with webMethods.io Integration
published: true
date: 2024-03-14 10:12:50 UTC
tags: integration, Google, GoogleSheets, Tasks
canonical_url: https://tech.forums.softwareag.com/t/track-your-google-tasks-to-do-list-in-google-sheets-with-webmethods-io-integration/293194
---

 

## Overview

With a few simple steps, build a robust workflow that automatically adds new Google Tasks as rows in your chosen Google Sheet using [webMethods.io](http://webMethods.io) Integration.

### Prerequisite:

- [webMethods.io](http://webmethods.io/) Integration tenant – [sign up here](https://signup.softwareag.cloud/#/basic?product=webmethodsioint) for a free trial if you’re new (use the [advanced form](https://signup.softwareag.cloud/#/advanced?product=webmethodsioint) for more options).
- Google account

## Set up a trigger action

Login to your [webMethods.io Integration](https://www.softwareag.cloud/site/product/webmethods-io-integration.html) 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](https://docs.webmethods.io/integration/workflow_building_blocks/creating_first_workflow/#gsc.tab=0) can be a great introduction.

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

[![Google Tasks polling trigger](https://global.discourse-cdn.com/techcommunity/optimized/3X/e/e/ee6d4b5d85116876992f3ba2b6f1825f3647bc51_2_310x215.png)](https://global.discourse-cdn.com/techcommunity/original/3X/e/e/ee6d4b5d85116876992f3ba2b6f1825f3647bc51.png "Google Tasks polling trigger")

[![Google Tasks polling trigger configuration](https://global.discourse-cdn.com/techcommunity/optimized/3X/0/3/0317b26fc260cc87aab670598b645e20ad568089_2_310x221.png)](https://global.discourse-cdn.com/techcommunity/original/3X/0/3/0317b26fc260cc87aab670598b645e20ad568089.png "Google Tasks polling trigger configuration")

Select **Task created** as a trigger and complete the authorization – connect [webMethods.io](http://webMethods.io) 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](https://global.discourse-cdn.com/techcommunity/original/3X/d/e/de09aa5cdc008cac3c4830c51812943f4a9ca8da.png)

Go back to the [webMethods.io](http://webMethods.io) Integration workflow and click **Test**. You should see the output data from the trigger which [webMethods.io](http://webMethods.io) 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](https://global.discourse-cdn.com/techcommunity/original/3X/8/8/8803e7c58cb51e573fb833c5f9f3de7847ef03e2.png)

Click on the small settings icon on the Google Sheets connector, select **Add row** as action and complete the authorization – connect [webMethods.io](http://webMethods.io) Integration with your Google account (check the following [Tutorial - Using Google services with webMethods.io Integration](https://tech.forums.softwareag.com/t/tutorial-using-google-services-with-webmethods-io-integration/237307)).

[![Google Sheets action](https://global.discourse-cdn.com/techcommunity/optimized/3X/4/b/4b2482a1146be491bc87cb631a03dc6e375bc208_2_352x400.png)](https://global.discourse-cdn.com/techcommunity/original/3X/4/b/4b2482a1146be491bc87cb631a03dc6e375bc208.png "Google Sheets action")

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:

[![Google Sheets](https://global.discourse-cdn.com/techcommunity/optimized/3X/2/6/26c77e3b4e9444f5b217ead2bb227679d398f3d3_2_521x400.png)](https://global.discourse-cdn.com/techcommunity/original/3X/2/6/26c77e3b4e9444f5b217ead2bb227679d398f3d3.png "Google Sheets")

Now go back to the [webMethods.io](http://webMethods.io) 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:

[![Google Sheets configuration](https://global.discourse-cdn.com/techcommunity/optimized/3X/b/a/bab2973befa4b3702c1707eac9a42ad6ef894f65_2_690x340.png)](https://global.discourse-cdn.com/techcommunity/original/3X/b/a/bab2973befa4b3702c1707eac9a42ad6ef894f65.png "Google Sheets configuration")

Click **Next** , **Test** and then **Done**.

Connect the Google Sheets connector to the _Stop step_. Don’t forget to save your workflow.

[![Final workflow](https://global.discourse-cdn.com/techcommunity/optimized/3X/b/4/b4651cd1bc96abef47058b8e687b09e9da5d3eda_2_690x313.png)](https://global.discourse-cdn.com/techcommunity/original/3X/b/4/b4651cd1bc96abef47058b8e687b09e9da5d3eda.png "Final 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:

[![New task added to Google Sheets](https://global.discourse-cdn.com/techcommunity/original/3X/9/9/99e7d5af34cc0a6a4172c489a16a1639e0bc8420.png)](https://global.discourse-cdn.com/techcommunity/original/3X/9/9/99e7d5af34cc0a6a4172c489a16a1639e0bc8420.png "New task 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:

[![Execution history](https://global.discourse-cdn.com/techcommunity/optimized/3X/6/b/6b4b73fa7c2f0fb0950f2943e0c456e2448b4cb1_2_690x98.png)](https://global.discourse-cdn.com/techcommunity/original/3X/6/b/6b4b73fa7c2f0fb0950f2943e0c456e2448b4cb1.png "Execution history")

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

[![Workflow execution history](https://global.discourse-cdn.com/techcommunity/optimized/3X/2/c/2c7f5ba79973ae3342c432cb442462cf3985959b_2_690x134.png)](https://global.discourse-cdn.com/techcommunity/original/3X/2/c/2c7f5ba79973ae3342c432cb442462cf3985959b.png "Workflow execution history")

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

![Workflow settings button](https://global.discourse-cdn.com/techcommunity/original/3X/9/f/9f8f81d1142fbbceb32ac1dd20490f46eba93ef8.png)

[![Workflow settings](https://global.discourse-cdn.com/techcommunity/optimized/3X/1/b/1bf6f40e40cfc0a03e629cde936ecc96f8e7cbca_2_690x373.png)](https://global.discourse-cdn.com/techcommunity/original/3X/1/b/1bf6f40e40cfc0a03e629cde936ecc96f8e7cbca.png "Workflow settings")

## Related articles

For more [webMethods.io](http://webmethods.io/) Integration workflow examples involving Google applications, refer to the following articles:

- [Sync Asana, Google Tasks and Toodledo tasks using webMethods.io Integration](https://tech.forums.softwareag.com/t/sync-asana-google-tasks-and-toodledo-tasks-using-webmethods-io-integration/292333)
- [Connect Mailchimp with Google Sheets/Excel Online or Smartsheet using webMethods.io Integration](https://tech.forums.softwareag.com/t/connect-mailchimp-with-google-sheets-excel-online-or-smartsheet-using-webmethods-io-integration/291939)
- [Create Google Calendar events from Google Sheets with webMethods.io Integration](https://tech.forums.softwareag.com/t/create-google-calendar-events-from-google-sheets-with-webmethods-io-integration/291548)
- [Integrate Evernote Reminders in Google Tasks with webMethods.io Integration](https://tech.forums.softwareag.com/t/integrate-evernote-reminders-in-google-tasks-with-webmethods-io-integration/287543)
- [Integrate Outlook Calendar with Google Calendar through webMethods.io Integration](https://tech.forums.softwareag.com/t/integrate-outlook-calendar-with-google-calendar-through-webmethods-io-integration/288200)
- [webMethods.io Integration workflow: Store Typeform entry data in Google Sheets or Excel Online](https://tech.forums.softwareag.com/t/webmethods-io-integration-workflow-store-typeform-entry-data-in-google-sheets-or-excel-online/289772)

[Read full topic](https://tech.forums.softwareag.com/t/track-your-google-tasks-to-do-list-in-google-sheets-with-webmethods-io-integration/293194)