Sync Events from Excel to Google Calendar with GPT-4o-Mini Smart Summaries

Description

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 Works Trigger → Download Excel → Filter events → Dual AI analysis (OpenAI + Parser) → Merge insights → Enrich data → Create/Update Google Calendar events → Generate and email AI summary. Workflow Template Trigger → Download Excel → Filter Events → AI Analysis → Merge Insights → Enrich Data → Create/Update Calendar → AI Summary → Email Report Workflow Steps Trigger: Runs on schedule to detect new files. Read Excel: Converts spreadsheet data to JSON. Filter Events: Removes invalid entries. AI Context Analysis: Understands event links and conflicts. Structured Parser: Formats AI output for consistency. Merge Insights: Combines multi-AI results. Enrich Data: Prepares Google Calendar-ready events. Calendar Actions: Creates or updates events. AI Summary: Generates executive overview. Email Delivery: Sends formatted summary report. Setup Google Drive: Connect OAuth2 → get file ID. Calendar: Enable API → authorize in n8n. OpenAI: Add API key → select GPT model. Email (Gmail/SMTP): Configure sender and recipients. Trigger: Set timezone and frequency. Excel Format: Include Name, Date, Time, Location, Staff, etc. An n8n automation workflow template by Cheng Siong Chin.

Categories

Tags

Capabilities

• 6 nodes
• 1 views