Skip to main content

Sync Toggl Track time entries with Google Sheets detail and summary tabs

Workflow preview

Sync Toggl Track time entries with Google Sheets detail and summary tabs preview
Open on n8n.io

Overview

How it works

This workflow syncs Toggl Track time entries to Google Sheets and creates monthly tabs automatically.

It fetches:

  • time entries from Toggl
  • project metadata from Toggl

Then it:

  • filters entries by your selected project name
  • writes detailed rows to a Detail Sheet
  • writes daily aggregated rows to a Summary Sheet
  • creates/removes monthly tabs to keep both sheets clean and aligned

Set up steps

Estimated setup time: 10–15 minutes.

  1. Configure HTTP Basic Auth for Toggl:
  • Username: your Toggl API token
  • Password: api_token
  1. Configure Google Sheets OAuth2 credentials.
  2. In Set Date Range, set start_date.
  3. In Process Data, set:
  • PROJECT_NAME
  • TIMEZONE
  1. Replace placeholders in workflow nodes:
  • YOUR_DETAIL_SPREADSHEET_ID
  • YOUR_SUMMARY_SPREADSHEET_ID

Detailed node-by-node guidance is included in sticky notes inside the workflow.