Sync Google Calendar events to Google Sheets with Slack notifications
Ready for 3.0What this workflow does
This workflow has 22 nodes and runs on Google Calendar events (event created) (plus 3 other triggers). Along the way it connects Google Calendar, Google Sheets, Slack and Gmail.
How it runs
Trigger: On Google Calendar events (event created) (plus 3 other triggers).
- Process Event (Code): runs custom JavaScript code
- Get Today Events (Google Calendar): get many
- Format Error (Code): runs custom JavaScript code
- Is Canceled? (If): checks a condition and branches into true / false
- Calculate Statistics (Code): runs custom JavaScript code
- Slack: uses Slack
- Log Cancellation (Google Sheets): append
- Log Event (Google Sheets): append
- Slack: uses Slack
- Slack: uses Slack
…plus 5 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (10)
- Google Calendar Trigger
n8n-nodes-base.googleCalendarTrigger - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Google Sheets
n8n-nodes-base.googleSheets - Slack
n8n-nodes-base.slack - Gmail
n8n-nodes-base.gmail - Google Calendar
n8n-nodes-base.googleCalendar - Error Trigger
n8n-nodes-base.errorTrigger - No Operation, do nothing
n8n-nodes-base.noOp
From the author
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,…