{"product_id":"n8n-lead-capture-google-sheets-business-hours-gmail-replies","title":"n8n Lead Capture: Google Sheets + Business Hours Gmail Replies","description":"\u003ch3\u003eCapture every website enquiry, log it in Google Sheets, and auto-reply in business hours—then alert the owner (with spam-safe handling)\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow turns new form submissions into a complete lead pipeline: it validates and prioritizes each enquiry, records it in Google Sheets, sends a business-hours-aware Gmail auto-reply (only for non-spam leads), and emails the business owner with full details.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives a new lead submission\u003c\/strong\u003e from an \u003cem\u003en8n Form\u003c\/em\u003e trigger.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes \u0026amp; validates\u003c\/strong\u003e lead details, calculates \u003cstrong\u003epriority from keywords\u003c\/strong\u003e, determines whether the enquiry is \u003cstrong\u003eoutside business hours\u003c\/strong\u003e, and flags \u003cstrong\u003elikely spam\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSpam handling:\u003c\/strong\u003e if the submission looks like spam, it \u003cstrong\u003eappends the lead to Google Sheets\u003c\/strong\u003e (including spam status) and \u003cstrong\u003estops\u003c\/strong\u003e—no auto-reply or owner alert is sent.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReturning contact detection:\u003c\/strong\u003e for non-spam leads, it searches prior rows in Google Sheets by email to identify \u003cstrong\u003ereturning contacts\u003c\/strong\u003e and counts how many times they have reached out.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs the lead:\u003c\/strong\u003e appends an entry to the Google Sheets \u003cstrong\u003e“Leads”\u003c\/strong\u003e tab with fields like Lead ID, Received At, Name, Email, Phone, Service, Message, Source, Priority, After Hours, Status, Times Contacted, and Notes.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAuto-replies via Gmail:\u003c\/strong\u003e sends a tailored \u003cstrong\u003eHTML email\u003c\/strong\u003e to the lead based on \u003cstrong\u003ebusiness hours\u003c\/strong\u003e and whether they are returning.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOwner alert via Gmail:\u003c\/strong\u003e sends an \u003cstrong\u003eHTML alert\u003c\/strong\u003e email to the business owner including lead details plus quick mailto\/tel links.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eService businesses that want instant follow-up from website inquiries while respecting business hours.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators who need a reliable lead log for returning customers and priority scoring.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers building an n8n lead capture system with \u003cstrong\u003espam detection\u003c\/strong\u003e and owner visibility.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\u003cstrong\u003en8n Form trigger\u003c\/strong\u003e\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e (OAuth2) with a configured spreadsheet URL and a required \u003cstrong\u003e“Leads”\u003c\/strong\u003e tab\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail\u003c\/strong\u003e (OAuth2) to send HTML auto-replies and owner alerts\u003c\/li\u003e\n  \u003cli\u003eLogic nodes: \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, plus supporting nodes (e.g., sticky note)\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eSetup required:\u003c\/strong\u003e create the Google Sheet with the specified headers, provide Google Sheets OAuth2 credentials, set the Config sheet URL, and connect Gmail OAuth2 credentials along with owner email, business name, and timezone.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46275631939763,"sku":"N8N-21481","price":31.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/9jui8CohZS74gu9kjh_fl_GiodD9OU.png?v=1792832859","url":"https:\/\/buyflowscripts.com\/products\/n8n-lead-capture-google-sheets-business-hours-gmail-replies","provider":"N8N Commerce","version":"1.0","type":"link"}