{"product_id":"n8n-google-calendar-meeting-prep-gmail-drafts-telegram-alerts","title":"n8n Google Calendar Meeting Prep: Gmail Drafts + Telegram Alerts","description":"\u003ch3\u003eAuto-build meeting agendas from your Google Calendar—then draft emails and alert teams in Telegram\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically checks your \u003cstrong\u003eGoogle Calendar\u003c\/strong\u003e every 15 minutes, pulls attendee context from \u003cstrong\u003eGmail\u003c\/strong\u003e, uses \u003cstrong\u003eOpenAI (gpt-4o-mini)\u003c\/strong\u003e to generate a concise agenda, creates a \u003cstrong\u003eGmail draft\u003c\/strong\u003e, and sends a formatted \u003cstrong\u003eTelegram\u003c\/strong\u003e alert—while logging processed meetings in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e to prevent duplicates.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on a schedule\u003c\/strong\u003e every 15 minutes using a schedule trigger.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches upcoming Google Calendar events\u003c\/strong\u003e and reads previously processed event IDs from the Google Sheets tab \u003cstrong\u003e“Meeting Prep Log”\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSkips duplicates\u003c\/strong\u003e by checking whether the meeting’s Event ID is already logged.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSearches Gmail threads\u003c\/strong\u003e for recent emails from meeting attendees (within the last 30 days) and compiles snippets into a single context prompt.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates a prep brief\u003c\/strong\u003e using OpenAI (GPT-4o-mini), producing a Markdown agenda and concise meeting notes.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates and emails via Gmail draft\u003c\/strong\u003e addressed to the meeting attendees.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends a Telegram message\u003c\/strong\u003e containing the formatted agenda, and \u003cstrong\u003eappends the Event ID + title\u003c\/strong\u003e to Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eError handling:\u003c\/strong\u003e if the workflow errors, it sends alerts to \u003cstrong\u003eSlack\u003c\/strong\u003e and \u003cstrong\u003eTelegram\u003c\/strong\u003e via the error trigger.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eImprove meeting readiness for founders, sales leads, or support teams by auto-generating an agenda before every upcoming call.\u003c\/li\u003e\n  \u003cli\u003eReduce manual admin work: draft attendee-ready emails and notify stakeholders instantly in Telegram.\u003c\/li\u003e\n  \u003cli\u003eKeep a reliable audit trail of processed meetings in Google Sheets to avoid repeating prep for the same event.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations \/ nodes:\u003c\/strong\u003e Google Calendar, Gmail, OpenAI (gpt-4o-mini), Google Sheets, Slack, Telegram, plus code\/no-op logic and a Sticky Note node.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRequired setup:\u003c\/strong\u003e OAuth2 credentials for Google Calendar, Gmail, OpenAI API, Google Sheets, Slack, and Telegram Bot API.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eConfiguration:\u003c\/strong\u003e set \u003ccode\u003eREPLACE_WITH_YOUR_MEETING_PREP_SHEET_ID\u003c\/code\u003e and ensure the “Meeting Prep Log” sheet contains an \u003cstrong\u003eEvent ID\u003c\/strong\u003e column; set \u003ccode\u003eREPLACE_WITH_YOUR_TELEGRAM_CHAT_ID\u003c\/code\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46029292863667,"sku":"N8N-19618","price":13.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/m86vNJ2yXN07E1KRRYH71_gOjYrJTo.png?v=1789462957","url":"https:\/\/buyflowscripts.com\/products\/n8n-google-calendar-meeting-prep-gmail-drafts-telegram-alerts","provider":"N8N Commerce","version":"1.0","type":"link"}