Daily Email & Calendar Summaries to Slack using Gemini AI & Google Workspace

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!