Sync Google Calendar events to Google Sheets with Slack notifications

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.