Skip to main content

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

Workflow preview

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

1. Workflow 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 e...

Best for

  • File Management automation workflows
  • advanced n8n builders looking for reusable templates

Tools used

n8n-nodes-base.manualtrigger, n8n-nodes-base.set, n8n-nodes-base.httprequest, n8n-nodes-base.merge, n8n-nodes-base.code, n8n-nodes-base.splitinbatches, n8n-nodes-base.googlesheets, n8n-nodes-base.stickynote

Source and attribution

This workflow is cataloged by N8N Workflows and links back to its original n8n.io source page by banan.

Original n8n.io source

1.1 Workflow description

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

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.

1.2 Logical Blocks

This catalog entry is organized from the workflow JSON. The node-level section below shows the executable blocks available for review before importing the template.

2. Block-by-Block Analysis

Block 1 - Start

Type / Role
n8n-nodes-base.manualTrigger - manualTrigger
Config choices
Version 1

Block 2 - Set Date Range

Type / Role
n8n-nodes-base.set - set
Config choices
Version 3.4

Block 3 - Fetch Time Entries

Type / Role
n8n-nodes-base.httpRequest - httpRequest
Config choices
Version 4.3

Block 4 - Fetch Projects

Type / Role
n8n-nodes-base.httpRequest - httpRequest
Config choices
Version 4.3

Block 5 - Merge With Projects

Type / Role
n8n-nodes-base.merge - merge
Config choices
Version 3.2

Block 6 - Process Data

Type / Role
n8n-nodes-base.code - code
Config choices
Version 2

Block 7 - Get Sheet Info 1

Type / Role
n8n-nodes-base.httpRequest - httpRequest
Config choices
Version 4.3

Block 8 - Build Sheet Ops 1

Type / Role
n8n-nodes-base.code - code
Config choices
Version 2

Block 9 - Apply Sheet Ops 1

Type / Role
n8n-nodes-base.httpRequest - httpRequest
Config choices
Version 4.3

Block 10 - Get Sheet Info 2

Type / Role
n8n-nodes-base.httpRequest - httpRequest
Config choices
Version 4.3

Block 11 - Build Sheet Ops 2

Type / Role
n8n-nodes-base.code - code
Config choices
Version 2

Block 12 - Apply Sheet Ops 2

Type / Role
n8n-nodes-base.httpRequest - httpRequest
Config choices
Version 4.3

Block 13 - Read Detail Data

Type / Role
n8n-nodes-base.code - code
Config choices
Version 2

Block 14 - Detail Write Loop

Type / Role
n8n-nodes-base.splitInBatches - splitInBatches
Config choices
Version 3

Block 15 - Expand Entries

Type / Role
n8n-nodes-base.code - code
Config choices
Version 2

Block 16 - Write Details

Type / Role
n8n-nodes-base.googleSheets - googleSheets
Config choices
Version 4.7

Block 17 - Read Summary Data

Type / Role
n8n-nodes-base.code - code
Config choices
Version 2

Block 18 - Summary Write Loop

Type / Role
n8n-nodes-base.splitInBatches - splitInBatches
Config choices
Version 3

Block 19 - Expand Summaries

Type / Role
n8n-nodes-base.code - code
Config choices
Version 2

Block 20 - Write Summaries

Type / Role
n8n-nodes-base.googleSheets - googleSheets
Config choices
Version 4.7

Block 21 - Instructions

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 22 - Section: Trigger Date

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 23 - Section: Toggl Fetch

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 24 - Section: Merge Transform

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Showing the first 24 of 28 workflow blocks. Download the JSON for the full node graph.

3. Summary Table

Workflow Sync Toggl Track time entries with Google Sheets detail and summary tabs
Complexity advanced
Nodes 28
Categories File Management
Author banan
Published 18 Feb 2026

4. Reproducing the Workflow from Scratch

  1. 1. Download the workflow JSON

    Use the JSON export at /data/workflows/13497/13497.json as the source template for this automation.

  2. 2. Import the template into n8n

    Open n8n, import the downloaded JSON, and review each node before activating the workflow.

  3. 3. Configure credentials and variables

    Replace placeholder credentials, API keys, webhook URLs, account IDs, and environment-specific values with your own settings.

  4. 4. Test with sample data

    Run the workflow manually or in a staging workspace, inspect node output, and confirm downstream systems receive the expected data.

  5. 5. Activate and monitor

    Enable the workflow only after testing, then monitor executions, errors, and rate limits during the first production runs.

5. General Notes & Resources

Review imported nodes carefully before activation. This catalog entry is intended to help you inspect the workflow structure, understand required services, and find related templates faster.

Node names, credentials, schedules, webhook paths, and external service limits may need adjustment for your workspace.

Frequently asked questions

What does Sync Toggl Track time entries with Google Sheets detail and summary tabs do?

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 e...

What do I need before importing this workflow?

Review the workflow JSON, configure any required credentials in n8n, and test the automation in a safe workspace before using it in production.

Can I customize this workflow?

Yes. Use the block-by-block analysis and the downloadable JSON to inspect each node, then adjust credentials, prompts, schedules, filters, or destinations for your File Management use case.