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

Workflow overview

Why this workflow matters

Improves internal consulting operations and productivity. Relevant for managed services and support workflows.

📧📅 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 AlekSystem 🤖 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!

Best fit

Need another direction?