Sync Google Calendar events to Google Sheets with Slack notifications

Description

Sync your Google Calendar events with Google Sheets and get daily Slack summaries with meeting statistics. FEATURES: Real-time sync of new and updated events Auto-categorization (Meeting, 1:1, Interview, Demo, Focus Time) Platform detection (Google Meet, Zoom, Teams) Daily statistics dashboard Cancellation tracking Optional email notifications to attendees FLOWS: New Event: Log to Sheets + Slack notification + Optional email Updated Event: Update Sheets + Slack notification Canceled Event: Log cancellation + Slack alert Daily Summary (8AM): Meeting time stats + Schedule to Slack SETUP: Connect Google account with Calendar access Create Google Sheet with 3 tabs: Events: ID, Synced At, Title, Category, Date, Day, Start Time, End Time, Duration, Platform, Attendees, Status, Meeting Link Cancellations: ID, Canceled At, Title, Original Date, Original Time, Affected Attendees Statistics: Date, Total Events, Meeting Time, Minutes, Busy %, Status, Virtual, In-Person Replace YOUR_DOCUMENT_ID in all Sheets nodes Connect Slack (#calendar, #errors channels) Optional: Connect Gmail for attendee notifications DAILY STATISTICS: Total events count Time spent in meetings Busy percentage of work day Virtual vs in-person breakdown Full day schedule IDEAL FOR: Anyone wanting to track their calendar, analyze meeting patterns, or get daily schedule summaries on Slack. An n8n automation workflow template by Manu.

Categories

Tags

Capabilities

• 5 nodes
• 1 views