🎯 Daily email & calendar summaries to Slack using Gemini AI & Google Workspace
⚡ 290 views · 🎯 AI Summarization & Classification
Description
📧📅 Turn Daily Emails and Calendar Summaries into Slack Notifications
Here’s a workflow that automates daily Slack notifications with a concise summary of unread emails (from the last 7 days) and Google Calendar events (for the current day).
It integrates Gmail, Google Sheets, Google Calendar, Gemini AI, and Slack to provide a clear snapshot of your workday.
💡 How It Helps You
- 📥 Fetches unread emails from Gmail for the past 7 days
- 🗂️ Filters emails based on Name, Email, and Subject defined in Google Sheets
- 📅 Fetches Google Calendar events for the current day
- 🤖 Summarizes emails and calendar events using Gemini AI
- 🔗 Merges both summaries and sends them as a formatted Slack notification
- ⏰ Runs automatically on a scheduled cron trigger
🛠️ What’s Needed to Start
- 📧 Gmail account (with unread emails access)
- 📑 Google Sheets (with Name, Email, Subject filter list)
- 📅 Google Calendar
- 🤝 Gemini AI with credentials
- 💬 Slack workspace & dedicated channel for notifications
⚡ Set Up in Minutes
- 📑 Create a Google Sheet with columns: Name, Email, Subject
- 🔑 Configure Gmail, Google Sheets, Google Calendar, and Slack credentials in n8n
- 🤖 Add Gemini AI credentials for summarization
- 📝 Update the Google Sheet name and file name in the Sheet node
- 💬 Update Slack channel ID in the workflow
- ✅ Activate the workflow to receive daily notifications
✨ Stay on top of important emails and upcoming meetings without manual checking!
🔗 Nodes Used
Cron, Google Sheets, Slack, Gmail, AI Agent, Google Gemini Chat Model
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File