{"product_id":"gmail-lead-capture-to-google-sheets-w-openai-telegram-alerts","title":"Gmail Lead Capture to Google Sheets w\/ OpenAI \u0026 Telegram Alerts","description":"\u003ch3\u003eTurn new Gmail inquiries into Google Sheets leads—and alert your team on Telegram using OpenAI\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow automatically polls your Gmail inbox every 5 minutes, extracts structured lead details with \u003cstrong\u003eOpenAI\u003c\/strong\u003e, upserts one lead per sender into \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and sends \u003cstrong\u003eTelegram\u003c\/strong\u003e alerts for “hot” inquiries based on budget or urgency.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePolls Gmail\u003c\/strong\u003e on a 5-minute interval using your configured search query for new inquiry emails.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilters non-leads\u003c\/strong\u003e by excluding newsletters, auto-replies, bounces, and ignored senders.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePre-cleans the email body\u003c\/strong\u003e (trims\/cleans content) before any AI processing.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUses OpenAI for information extraction\u003c\/strong\u003e to confirm the email is a real inquiry and extract fields such as service, budget, deadline, and a short summary.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates and normalizes results\u003c\/strong\u003e by sanitizing spreadsheet-formula text, parsing budget into a number, normalizing phone, and scoring priority as hot or normal.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpserts into Google Sheets\u003c\/strong\u003e (sheet name: \u003cem\u003eLeads\u003c\/em\u003e) using the sender’s email as the unique \u003cstrong\u003ekey\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends Telegram alerts for hot leads\u003c\/strong\u003e, including an HTML-safe message and a link back to the original Gmail message.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS and service businesses capturing inbound requests without manual copy\/paste.\u003c\/li\u003e\n  \u003cli\u003eSales teams routing only high-priority Gmail inquiries to Telegram for immediate follow-up.\u003c\/li\u003e\n  \u003cli\u003eOperators maintaining a clean CRM-like pipeline in Google Sheets with one row per sender.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail\u003c\/strong\u003e: polled workflow (every 5 minutes) to detect matching inquiry emails.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOpenAI\u003c\/strong\u003e: prompt-driven extraction of lead fields and inquiry classification.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e: appends or updates a lead row in sheet \u003cstrong\u003e“Leads”\u003c\/strong\u003e with columns including \u003cem\u003ekey, received_at, name, email, company, phone, service, budget, currency, deadline, summary, subject, priority, gmail_link\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTelegram\u003c\/strong\u003e: sends hot-lead alerts with a Gmail link.\u003c\/li\u003e\n  \u003cli\u003en8n nodes\/logic referenced: \u003cstrong\u003eGmail Trigger\u003c\/strong\u003e, \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003etelegram\u003c\/strong\u003e, and supporting workflow steps (including a sticky note for guidance).\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46154063184051,"sku":"N8N-20064","price":13.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/xLuysaeEzLQzCJdxapUGg_YN0sV8T0.png?v=1790933237","url":"https:\/\/buyflowscripts.com\/products\/gmail-lead-capture-to-google-sheets-w-openai-telegram-alerts","provider":"N8N Commerce","version":"1.0","type":"link"}