{"product_id":"n8n-lead-response-automation-openai-gmail-google-sheets","title":"n8n Lead Response Automation: OpenAI, Gmail \u0026 Google Sheets","description":"\u003ch3\u003eAutomate every lead reply: OpenAI spam screening + Gmail (send or draft) + Google Sheets logging\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow captures new enquiries from an n8n Form or a website webhook, uses \u003cstrong\u003eOpenAI\u003c\/strong\u003e to detect spam and generate a short, safe reply, then sends (or drafts) it via \u003cstrong\u003eGmail\u003c\/strong\u003e. It also alerts you and logs every lead and outcome to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e—so nothing slips through.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives new enquiries\u003c\/strong\u003e from an n8n Form submission or a POST request to a webhook endpoint.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes lead data\u003c\/strong\u003e (name, email, phone, service, message) into a single lead record and timestamps when it was received.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUses OpenAI for spam screening\u003c\/strong\u003e by labeling the message as real or spam.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRoutes outcomes safely\u003c\/strong\u003e: auto-reply for real enquiries, “log-only” for non-reply scenarios, or “needs a person” when the check fails or the email is invalid.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePrevents duplicate responses\u003c\/strong\u003e by checking your Google Sheets log to see if the same email already received a reply within a configured time window.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates a short reply\u003c\/strong\u003e for new real enquiries, including your booking link, and applies safety checks (risky content is replaced with a fixed fallback reply).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends or drafts via Gmail\u003c\/strong\u003e based on the \u003cstrong\u003eDRAFT_ONLY\u003c\/strong\u003e setting.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNotifies the owner\u003c\/strong\u003e by email (optionally via \u003cstrong\u003eTwilio SMS\u003c\/strong\u003e and \u003cstrong\u003eTelegram\u003c\/strong\u003e if enabled), and \u003cstrong\u003eappends the lead + outcome\u003c\/strong\u003e to Google Sheets including seconds-to-reply.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eYour website generates inquiries and you want instant responses without manual copy\/paste.\u003c\/li\u003e\n  \u003cli\u003eYou receive high volumes of spam and need OpenAI-based filtering before contacting leads.\u003c\/li\u003e\n  \u003cli\u003eYou want measurable lead handling—every enquiry logged with outcome and response time in Google Sheets.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOpenAI\u003c\/strong\u003e via HTTP Request using an Authorization header (Bearer API key) for spam labeling and reply drafting.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail\u003c\/strong\u003e to create drafts or send emails depending on \u003cstrong\u003eDRAFT_ONLY\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e to detect repeat emails and record lead\/outcome\/seconds-to-reply.\u003c\/li\u003e\n  \u003cli\u003eWorkflow logic uses \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003eswitch\u003c\/strong\u003e (and includes \u003cstrong\u003etwilio\u003c\/strong\u003e for SMS alerting).\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46196310900915,"sku":"N8N-20715","price":22.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/g758n-qBtZUmLnbzF5aaL_HQRBE4Hk.png?v=1791623345","url":"https:\/\/buyflowscripts.com\/products\/n8n-lead-response-automation-openai-gmail-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}