Back to Templates

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

Created by

Created by: banan || banan

banan

Last update

Last update 3 days ago

Categories

Share


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
  2. Configure Google Sheets OAuth2 credentials.
  3. In Set Date Range, set start_date.
  4. In Process Data, set:
    • PROJECT_NAME
    • TIMEZONE
  5. 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.