See llms.txt for all machine-readable content.

Back to Templates

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.