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 Even

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 1. Trigger: Runs on schedule to detect new files. 2. Read Excel: Converts spreadsheet data to JSON. 3. Filter Events: Removes invalid entries. 4. AI Context Analysis: Understands event links and conflicts. 5. Structured Parser: Formats AI output for consistency. 6. Merge Insights: Combines multi-AI results. 7. Enrich Data: Prepares Google Calendar-ready events. 8. Calendar Actions: Creates or updates events. 9. AI Summary: Generates executive overview. 10. Email Delivery: Sends formatted summary report. Setup 1. Google Drive: Connect OAuth2 → get file ID. 2. Calendar: Enable API → authorize in n8n. 3. OpenAI: Add API key → select GPT model. 4. Email (Gmail/SMTP): Configure sender and recipients. 5. Trigger: Set timezone and frequency. 6. Excel Format: Include Name, Date, Time, Location, Staff, etc.
Download the workflow JSON file after purchase.
Open n8n → click the menu → Import from File.
Select the downloaded JSON and import.
Set up credentials for each node that requires them.
Click Execute Workflow to test, then activate.
Setup guide included
Purchase to unlock the full step-by-step guide
No reviews yet
Be the first to buy and share your experience.
Leave a review
Sign in to share your experience with this workflow.
Create a free account to purchase workflows.
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.