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

Google Sheets + Google Tasks

Create spreadsheet row at top in Google Sheets for each new completed task in Google Tasks

When you wrap up a task in Google Tasks, it's the perfect opportunity to log that information in a Google Sheets file for tracking or reporting purposes. With this workflow solution, as soon as you tick off a task in Google Tasks, a new row is immediately added at the top of your selected Google Sheets. It's a brilliant way to keep a record of your task completion, make your work process seamless, and save time.

When you wrap up a task in Google Tasks, it's the perfect opportunity to log that information in a Google Sheets file for tracking or reporting purposes. With this workflow solution, as soon as you tick off a task in Google Tasks, a new row is immediately added at the top of your selected Google Sheets. It's a brilliant way to keep a record of your task completion, make your work process seamless, and save time.

  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
    Create Spreadsheet Row at Top

    Creates a new spreadsheet row at the top of a spreadsheet (after the header row).

    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