{"product_id":"capture-leads-with-n8n-form-trigger-google-sheets-gmail","title":"Capture Leads with n8n Form Trigger + Google Sheets + Gmail","description":"\u003ch3\u003eCapture n8n Form leads instantly—log them to Google Sheets and auto-reply via Gmail\u003c\/h3\u003e\n\u003cp\u003eThis n8n automation workflow connects an \u003cstrong\u003en8n Form trigger\u003c\/strong\u003e to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e and sends an \u003cstrong\u003einstant Gmail reply\u003c\/strong\u003e to every new submission. Your “Thanks” confirmation shows immediately, while lead details are validated, saved, and emailed back to the visitor.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives new submissions\u003c\/strong\u003e from an n8n Form trigger and immediately displays a “Thanks” confirmation message.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates and normalizes lead details\u003c\/strong\u003e (name, email, phone, company, message).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAdds a submission timestamp\u003c\/strong\u003e and drafts a \u003cstrong\u003eplain-text reply message\u003c\/strong\u003e using code that you can edit to match your brand.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends the lead to Google Sheets\u003c\/strong\u003e by adding a new row in the \u003ccode\u003eLeads\u003c\/code\u003e tab with headers: \u003ccode\u003esubmitted_at\u003c\/code\u003e, \u003ccode\u003ename\u003c\/code\u003e, \u003ccode\u003eemail\u003c\/code\u003e, \u003ccode\u003ephone\u003c\/code\u003e, \u003ccode\u003ecompany\u003c\/code\u003e, \u003ccode\u003emessage\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends an instant reply email\u003c\/strong\u003e to the submitter using \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eCollecting leads from an embedded n8n form for a SaaS landing page or demo request.\u003c\/li\u003e\n  \u003cli\u003eBuilding a lightweight lead capture pipeline for teams that want spreadsheet tracking plus immediate email confirmation.\u003c\/li\u003e\n  \u003cli\u003eCapturing contact submissions and responding right away when you don’t need SMS, a CRM, lead scoring, or a follow-up sequence.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes \/ modules:\u003c\/strong\u003e code, form trigger, google sheets, gmail, sticky note.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets:\u003c\/strong\u003e append to the \u003ccode\u003eLeads\u003c\/code\u003e tab (you provide your own OAuth connection and spreadsheet ID).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGmail:\u003c\/strong\u003e send plain-text reply emails from your connected Gmail account (you provide your own OAuth connection).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFree lite edition limitations:\u003c\/strong\u003e one web form, one Google Sheets tab, and one plain-text reply. No SMS, CRM, lead scoring, or follow-up sequence.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePublishing:\u003c\/strong\u003e use the generated form URL path \u003ccode\u003eauragrid-lead\u003c\/code\u003e to collect leads.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46203573698739,"sku":"N8N-20763","price":12.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/zjK-Phq4NFKttu5moMd0Z_GciATwf0.png?v=1791709377","url":"https:\/\/buyflowscripts.com\/products\/capture-leads-with-n8n-form-trigger-google-sheets-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}