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 T...
Template notes
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 YOURDOCUMENTID in all Sheets nodes Connect Slack (calendar, errors channels) Optional: Connect Gmail for attendee notifications