Google Calendar Automated Notifications with Email, SMS & Analytics Dashboard

Automatically turn your Google Calendar into a fully-automated notification system with email alerts, SMS reminders, and a live performance dashboard - all powered by n8n.

This automation helps you never miss an event, while giving you clear visibility into what notifications were sent, when, and how reliably they ran.

What This Automation Does

This solution is built as 4 connected workflows that run on a schedule and work together:

1. Daily Email Summary (Morning)

Every morning, the workflow:

• Reads today’s events from Google Calendar

• Formats them into a clean email

• Sends a daily schedule summary via Mailchimp or SendGrid

2. Daily SMS Summary

Shortly after, it:

Sends a concise SMS overview of today’s meetings using Twilio

3. 15-Minute Event Reminders

Before each event:

• Sends an individual SMS reminder

• Skips all-day events automatically

4. Weekly Schedule Preview

Every Sunday:

• Sends a week-ahead summary so you can plan in advance

Live Reporting & Dashboard

All workflow activity is logged automatically into Google Sheets, which powers a real-time analytics dashboard showing:

• Number of notifications sent

• Success vs failure rates

• Daily and weekly execution stats

• Visual charts powered by Chart.js

• No manual tracking needed, everything updates automatically.

How the Workflow Is Structured

The automation is grouped into 3 clear sections:

Section 1: Calendar Data Collection

• Pulls events from Google Calendar

• Filters relevant meetings

• Prepares clean event data

Section 2: Notifications & Messaging

• Formats emails and SMS messages

• Sends reminders and summaries

• Handles scheduling logic

Section 3: Logging & Reporting

• Saves every execution to Google Sheets

• Updates daily stats automatically

• Feeds the live dashboard

SUPPORT & FEEDBACK
Questions or issues? Connect with me on LinkedIn
Want to see it in action? Try the live report demo: Click here