Sync events from Excel to Google Calendar with GPT-4o-Mini smart summaries
Needs changesNeeds changes. This template uses 1 thing(s) that n8n 3.0 removes: AI Agent v1 (old agent modes). 1 breaking item(s) found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 17 nodes and runs on a schedule (every 6 hours). Along the way it connects Google Drive, Google Calendar and OpenAI Chat Model.
How it runs
Trigger: On a schedule (every 6 hours).
- Set Excel File ID (Edit Fields (Set)): sets 1 field: fileId
- Google Drive: download
- Read Excel File (Spreadsheet File): reads or writes a spreadsheet file (legacy node)
- Filter: keeps only the items that match a condition
- Google Calendar: uses Google Calendar
- AI - Analyze Event Context (AI Agent): runs an AI agent, with model: OpenAI Chat Model; output parser: Structured Output Parser
- Merge: merges the data from its input branches
- Update Calendar Event (Google Calendar): update
- Enrich Event Data (Edit Fields (Set)): sets 7 fields: title, category, tags…
- Prepare AI Summary Data (Edit Fields (Set)): sets 3 fields: totalEvents, aggregatedEvents, syncTimestamp
…plus 3 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- AI Agent v1 (old agent modes) in AI - Analyze Event Context (v1.6), AI - Generate Smart Summary (v1.6): replace with Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.
- Also check Spreadsheet File: Convert to File / Extract from File.
| Removed in 3.0 | Replace with |
|---|---|
| AI Agent v1 (old agent modes) AI - Analyze Event Context (v1.6), AI - Generate Smart Summary (v1.6) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (11)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Spreadsheet File
n8n-nodes-base.spreadsheetFile - Google Drive
n8n-nodes-base.googleDrive - Edit Fields (Set)
n8n-nodes-base.set - Filter
n8n-nodes-base.filter - Google Calendar
n8n-nodes-base.googleCalendar - Send Email
n8n-nodes-base.emailSend - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Merge
n8n-nodes-base.merge
From the author
Introduction Automatically imports Excel schedules from Google Drive, validates data with AI, syncs to Google Calendar, and emails smart summaries. Ideal for educators, managers, and administrators handling recurring academic or project schedules. How It…