workflows.fit
Back to n8n workflows
n8n templateFreeBy Manu

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...

Data & StorageProductivityCommunicationHITLDevelopmentCore NodesGoogle Calendar TriggerSchedule Trigger
Loading interactive preview...

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