{"product_id":"n8n-webhook-lead-qualification-openai-gmail-reply-sheets","title":"n8n Webhook Lead Qualification: OpenAI, Gmail Reply \u0026 Sheets","description":"\u003ch3\u003eAutomatically qualify website leads with n8n—OpenAI scoring, multilingual Gmail replies, and Google Sheets tracking\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow receives leads from your website form via a webhook, validates and scores them using OpenAI, stores updates in Google Sheets, replies through Gmail in the lead’s language, and sends Telegram hot-lead alerts plus a daily digest and automated follow-ups.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eCaptures leads instantly:\u003c\/b\u003e Receives a \u003cb\u003ePOST webhook\u003c\/b\u003e from your website form and immediately returns a response indicating \u003cb\u003esuccess\u003c\/b\u003e, \u003cb\u003espam-ignored\u003c\/b\u003e, or \u003cb\u003evalidation-error\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eNormalizes and validates submissions:\u003c\/b\u003e Cleans the fields, checks spam using a \u003cb\u003ehoneypot\u003c\/b\u003e and \u003cb\u003elink limits\u003c\/b\u003e, and verifies required \u003cb\u003econsent\u003c\/b\u003e. Produces a clean lead profile.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eDetects returning leads:\u003c\/b\u003e Looks up the lead by \u003cb\u003eemail\u003c\/b\u003e in the Google Sheets \u003cb\u003e“Leads”\u003c\/b\u003e tab to pull status\/history.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eUses OpenAI for qualification:\u003c\/b\u003e Sends lead details + prior history to \u003cb\u003eOpenAI\u003c\/b\u003e to classify the request, \u003cb\u003escore fit\u003c\/b\u003e, extract key details, and draft a \u003cb\u003eplain-text reply\u003c\/b\u003e in the lead’s language.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eReplies via Gmail (optional):\u003c\/b\u003e If enabled, sends the drafted reply using \u003cb\u003eGmail\u003c\/b\u003e and upserts the updated lead row in Google Sheets with AI results and timestamps.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eAlerts you on Telegram:\u003c\/b\u003e Sends a \u003cb\u003eTelegram hot-lead alert\u003c\/b\u003e or notifies when the AI step fails for \u003cb\u003emanual review\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eDaily digest + follow-ups:\u003c\/b\u003e Every morning, reads the full Google Sheet to send a Telegram digest. When follow-up is due, generates and sends a follow-up with OpenAI, replies in the same Gmail thread, and records the outcome back to Google Sheets.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eQualify inbound website form leads for a SaaS and prioritize outreach using AI scoring.\u003c\/li\u003e\n  \u003cli\u003eAuto-reply in the visitor’s language with an OpenAI-generated plain-text message.\u003c\/li\u003e\n  \u003cli\u003eMaintain a single source of truth in Google Sheets with timestamps, categories, and prior status.\u003c\/li\u003e\n  \u003cli\u003eEnsure fast response for high-fit prospects using Telegram hot-lead alerts and daily digests.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eIntegrations:\u003c\/b\u003e \u003cb\u003eGoogle Sheets\u003c\/b\u003e, \u003cb\u003eGmail\u003c\/b\u003e, \u003cb\u003eTelegram\u003c\/b\u003e, \u003cb\u003eOpenAI\u003c\/b\u003e, \u003cb\u003eWebhook\u003c\/b\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eWorkflow nodes:\u003c\/b\u003e \u003cb\u003eif\u003c\/b\u003e, \u003cb\u003eset\u003c\/b\u003e, \u003cb\u003ecode\u003c\/b\u003e, \u003cb\u003egmail\u003c\/b\u003e, \u003cb\u003eswitch\u003c\/b\u003e, \u003cb\u003ewebhook\u003c\/b\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cb\u003eSetup note:\u003c\/b\u003e Create a Google Sheets spreadsheet with a “Leads” sheet and the required header columns (including \u003cb\u003eEmail\u003c\/b\u003e, \u003cb\u003eName\u003c\/b\u003e, \u003cb\u003ePhone\u003c\/b\u003e, \u003cb\u003eCompany\u003c\/b\u003e, \u003cb\u003eLanguage\u003c\/b\u003e, \u003cb\u003eCategory\u003c\/b\u003e, \u003cb\u003eScore\u003c\/b\u003e, and a “Priori…” column).\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46326525591731,"sku":"N8N-21807","price":9.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/O_WanJcUx_uF1cJ-xe1Kz_S4y8bRYb.png?v=1793351648","url":"https:\/\/buyflowscripts.com\/products\/n8n-webhook-lead-qualification-openai-gmail-reply-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}