<aside> 📌

Workflow ID: pStGJY9nBWvTz-cVsJXha · instance: n8n.prhomelab.com · trigger: every 30 minutes · tag: DEV

</aside>

What it does

Every 30 minutes, reads all workflows from the n8n instance via REST API, extracts scheduleTrigger and cron nodes, compares the live state against a Google Sheets state store, and syncs Google Calendar with recurring events representing each workflow's schedule.

• A new scheduled workflow → creates a recurring event on Google Calendar
• A workflow with a changed schedule → deletes the old event and creates a new one
• A workflow with an unchanged schedule → no action (skip)

State (Calendar EventID, schedule string, On Calendar flag) is persisted in a Google Sheets tab.

Data flow

flowchart LR
	A["Schedule Trigger\nevery 30 min"] --> B["Get many workflows\nn8n REST API"]
	B --> C["Code: parsing\nextracts scheduleTrigger/cron"]
	C --> D["Code: save current values\nsnapshots live fields"]
	D --> E["Sheets: Lookup\nreads saved state"]
	E --> F["Code: manual merge\njoins live + Sheets"]
	F --> G["Code: detect changes\ncreate / update / skip"]
	G -->|create| H["Remove Duplicates"]
	G -->|update| H
	G -->|update| I["Code: split eventIds\nfor old event deletion"]
	H --> J["Code: RRULE\nbuild GCal payload"]
	J --> K["Create an event\nGoogle Calendar"]
	K --> L["Code: post-create\naggregates event IDs"]
	L --> M["Sheets: OnCalendar=YES\nupdates state store"]
	I --> N["Delete old event\nGoogle Calendar"]

Prerequisites

Setup

1 · n8n API Key

1. In n8n: Settings → API → Generate API Key
2. Copy the key
3. In n8n Credentials → create n8n API → paste the key and the instance URL