Skip to content
  • Google Sheets logoGoogle Sheets logo
  • Google Tasks logoGoogle Tasks logo

Google Sheets + Google Tasks

Update spreadsheet rows in Google Sheets with new completed tasks from Google Tasks

Take the hassle out of project management with this handy workflow. When you finish a task in Google Tasks, it updates that specific row in a selected Google Sheets spreadsheet. This ensures your spreadsheets accurately reflect the state of your tasks, providing a straightforward overview of your progress and making project tracking a breeze. Say goodbye to manual updates, and let this automation keep everything up-to-date.

Take the hassle out of project management with this handy workflow. When you finish a task in Google Tasks, it updates that specific row in a selected Google Sheets spreadsheet. This ensures your spreadsheets accurately reflect the state of your tasks, providing a straightforward overview of your progress and making project tracking a breeze. Say goodbye to manual updates, and let this automation keep everything up-to-date.

  1. When this happens...
    Google TasksGoogle Tasks
    New Completed Task

    Triggers when a task is completed in a specific task list.

    TriggerPolling
  2. automatically do this!
    Google SheetsGoogle Sheets
    Update Spreadsheet Row

    Update a row in a specific spreadsheet.

    ActionWrite
  • Free forever for core features
  • 14 day trial for premium features & apps

Supported triggers and actions

    • Task ListRequired

    • Include Assigned Tasks?

    Trigger
    Polling
    Try It
    • Task ListRequired

    • TitleRequired

    • Notes

    • Due On

    Action
    Write
    • Api Docs Info

    • Stop on errorRequired

    • HTTP MethodRequired

    • URLRequired

    • Query string parameters

    • Additional request headers

    • Body

    Action
    Write
    • Task ListRequired

    • Include Assigned Tasks?

    Trigger
    Polling
    Try It
    • List TitleRequired

    Action
    Write
    • ListRequired

    • TaskRequired

    • Title

    • Status

    • Notes

    • Due Date

    Action
    Write
    • ListRequired

    • TitleRequired

    Action
    Search
google-sheets logo
google-sheets logo

About Google Sheets

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.

Related categories

google-tasks logo
google-tasks logo

About Google Tasks

Google Tasks is a very simple task list. Works inside Gmail, Android, and Calendar seamlessly.

Related categories