n8n Google Calendar Meeting Prep: Gmail Drafts + Telegram Alerts

Auto-build meeting agendas from your Google Calendar—then draft emails and alert teams in Telegram

This n8n workflow automatically checks your Google Calendar every 15 minutes, pulls attendee context from Gmail, uses OpenAI (gpt-4o-mini) to generate a concise agenda, creates a Gmail draft, and sends a formatted Telegram alert—while logging processed meetings in Google Sheets to prevent duplicates.

What this workflow does

• Runs on a schedule every 15 minutes using a schedule trigger.
• Fetches upcoming Google Calendar events and reads previously processed event IDs from the Google Sheets tab “Meeting Prep Log”.
• Skips duplicates by checking whether the meeting’s Event ID is already logged.
• Searches Gmail threads for recent emails from meeting attendees (within the last 30 days) and compiles snippets into a single context prompt.
• Generates a prep brief using OpenAI (GPT-4o-mini), producing a Markdown agenda and concise meeting notes.
• Creates and emails via Gmail draft addressed to the meeting attendees.
• Sends a Telegram message containing the formatted agenda, and appends the Event ID + title to Google Sheets.
• Error handling: if the workflow errors, it sends alerts to Slack and Telegram via the error trigger.

Use cases

• Improve meeting readiness for founders, sales leads, or support teams by auto-generating an agenda before every upcoming call.
• Reduce manual admin work: draft attendee-ready emails and notify stakeholders instantly in Telegram.
• Keep a reliable audit trail of processed meetings in Google Sheets to avoid repeating prep for the same event.

Technical details

• Integrations / nodes: Google Calendar, Gmail, OpenAI (gpt-4o-mini), Google Sheets, Slack, Telegram, plus code/no-op logic and a Sticky Note node.
• Required setup: OAuth2 credentials for Google Calendar, Gmail, OpenAI API, Google Sheets, Slack, and Telegram Bot API.
• Configuration: set REPLACE_WITH_YOUR_MEETING_PREP_SHEET_ID and ensure the “Meeting Prep Log” sheet contains an Event ID column; set REPLACE_WITH_YOUR_TELEGRAM_CHAT_ID.