Sync Toggl Track time entries with Google Sheets detail and summary tabs — рабочий процесс n8n

Высокая сложность Триггер20 узлов🏷️ File Managementот banan

Обзор

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.

Configure HTTP Basic Auth for Toggl: Username: your T

Использованные узлы

Google SheetsHTTP RequestCode

Предпросмотр рабочего процесса

Sync Toggl Track time entries with Google She
This workflow fetches Toggl time entries, filters by pr
- Detail Sheet: individual entries
- Summary Sheet:
Trigger & Date Range
Starts the workflow and builds dynamic `start_date` / `
Toggl Data Fetch
Requests time entries and projects from Toggl Track API
Merge & Transform
Merges entries with project metadata, filters by projec
Detail Sheet Preparation
Ensures monthly tabs exist in the detail spreadsheet an
Detail Sheet Write Loop
Splits detail data by month, expands entries, and appen
Summary Sheet Preparation
Ensures monthly tabs exist in the summary spreadsheet a
Summary Sheet Write Loop
Splits summary data by month, expands entries, and appe
S
Start
S
Set Date Range
Fetch Time Entries
Fetch Projects
M
Merge With Projects
Process Data
Get Sheet Info 1
Build Sheet Ops 1
Apply Sheet Ops 1
Get Sheet Info 2
Build Sheet Ops 2
Apply Sheet Ops 2
Read Detail Data
D
Detail Write Loop
Expand Entries
Write Details
Read Summary Data
S
Summary Write Loop
Expand Summaries
Write Summaries
20 nodes22 edges

Как это работает

  1. 1

    Триггер

    Рабочий процесс запускается триггером триггер.

  2. 2

    Обработка

    Данные проходят через 20 узлов, connecting code, googlesheets, httprequest.

  3. 3

    Вывод

    Рабочий процесс завершает автоматизацию и доставляет результат в настроенное место назначения.

Детали узлов (20)

GO

Google Sheets

googleSheets

#1
HT

HTTP Request

httpRequest

#2
CO

Code

code

#3

Как импортировать этот рабочий процесс

  1. 1Нажмите кнопку Скачать JSON справа, чтобы сохранить файл рабочего процесса.
  2. 2Откройте ваш экземпляр n8n. Перейдите в Рабочие процессы → Новый → Импорт из файла.
  3. 3Выберите скачанный файл sync-toggl-track-time-entries-with-google-sheets-detail-and-summary-tabs и нажмите Импортировать.
  4. 4Настройте учётные данные для каждого узла сервиса (ключи API, OAuth и т.д.).
  5. 5Нажмите Протестировать рабочий процесс, чтобы убедиться в правильной работе, затем активируйте его.

Или вставьте напрямую в n8n → Импорт из JSON:

{ "name": "Sync Toggl Track time entries with Google Sheets detail and summary tabs", "nodes": [...], ...}

Интеграции

codegooglesheetshttprequestmanualtriggermergesetsplitinbatches

Получить этот рабочий процесс

Скачайте и импортируйте одним кликом

Скачать JSONПросмотреть на n8n.io
Узлы20
Сложностьhigh
Триггерtrigger
КатегорияFile Management

Создан

banan

banan

@banan

Теги

codegooglesheetshttprequestmanualtriggermergesetsplitinbatches

Новичок в n8n?

n8n — бесплатный инструмент автоматизации рабочих процессов с открытым исходным кодом. Разверните самостоятельно или используйте облачную версию.

Получить n8n бесплатно →

Related File Management Workflows

COCOGOHT+5
medium

Sync SharePoint to Google Drive via Supabase (n8n Workflow)

Eliminate manual file transfers and data silos with this enterprise-grade synchronization pipeline. This n8n workflow automates the heavy lifting of mirroring your Microsoft SharePoint document libraries to Google Drive while maintaining a robust audit trail in Supabase or Postgres. Designed for high-reliability environments, the automation utilizes a sophisticated delta-check logic: it fetches SharePoint metadata, compares it against your existing database records using the 'Compare Datasets' node, and identifies only new or modified files for processing. By leveraging the 'Split in Batches' node, the system handles large volumes of data without hitting memory limits, ensuring every document is securely downloaded via HTTP and re-uploaded to its destination. Once the transfer is verified, the workflow updates your database status in real-time, providing a transparent log of your synchronization history. This is an essential solution for organizations transitioning between cloud ecosystems or those requiring a redundant, cross-platform backup strategy. It effectively bridges the gap between Microsoft and Google ecosystems using Supabase as a high-performance state-management layer. **Common Use Cases:** - Automated Multi-Cloud Disaster Recovery: Maintain a real-time mirror of critical SharePoint corporate assets in Google Drive to ensure business continuity during service outages. - Cross-Departmental Collaboration: Automatically sync project documentation from an executive SharePoint site to a creative team's Google Drive folder for seamless cross-platform access. - Centralized Document Auditing: Use Supabase to track every file movement between ecosystems, creating a searchable metadata index for compliance and regulatory reporting.

Scheduled·15 nodes
FOGOGOHT+2
medium

Automate Threads Video Backups to Google Drive & Sheets

Streamline your social media asset management with this robust n8n automation designed for digital marketers and content creators. This workflow eliminates the manual effort of downloading Threads content by providing a seamless bridge between Instagram's text-based platform and your cloud storage. Once triggered via a simple form input, the automation utilizes a RapidAPI connection to fetch high-quality video assets, processes the binary data, and securely uploads the file to a designated Google Drive folder. Simultaneously, the workflow maintains a centralized audit log in Google Sheets, capturing essential metadata such as timestamps and file IDs. Built-in logic gates and wait nodes ensure API rate limits are respected and file transfers are verified before logging. This is an essential tool for agencies managing high volumes of social content who need a reliable, automated pipeline for content repurposing, archival compliance, or collaborative review processes. By centralizing your Threads media assets, you ensure your creative team has instant access to raw footage without the friction of manual downloads. **Common Use Cases:** - Automated Social Media Content Archiving for Compliance - Centralized Asset Library Syncing for Creative Agencies - Competitor Research and Video Content Benchmarking

Trigger·9 nodes