{"product_id":"capture-website-form-leads-to-google-sheets-gmail-auto-reply","title":"Capture Website Form Leads to Google Sheets + Gmail Auto-Reply","description":"\u003ch3\u003eCapture every website form lead instantly—save to Google Sheets and auto-reply by Gmail\u003c\/h3\u003e\n\u003cp\u003eThis n8n automation workflow receives your website form submissions, validates the data, stores each lead in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and sends the submitter a fast \u003cstrong\u003eGmail auto-reply\u003c\/strong\u003e confirmation—so you never miss an inquiry.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives\u003c\/strong\u003e a form \u003cem\u003ePOST\u003c\/em\u003e request via a webhook.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes\u003c\/strong\u003e incoming fields: \u003cstrong\u003ename, email, phone, message, source\u003c\/strong\u003e, and adds a \u003cstrong\u003etimestamp\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates\u003c\/strong\u003e \u003cstrong\u003ename, email, message\u003c\/strong\u003e. If validation fails, the workflow returns \u003cstrong\u003eHTTP 400\u003c\/strong\u003e with reasons.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends the lead\u003c\/strong\u003e to your configured \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e sheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends an instant confirmation email\u003c\/strong\u003e to the lead (auto-reply) within seconds using \u003cstrong\u003eGmail\u003c\/strong\u003e (or SMTP, as supported in setup).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReturns HTTP 200\u003c\/strong\u003e to the form so the user submission flow completes successfully.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eFreelancers capturing inquiries from a contact form and wanting immediate confirmation + spreadsheet tracking.\u003c\/li\u003e\n  \u003cli\u003eSmall businesses that need a lightweight lead intake system without a full CRM setup.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators routing “contact us” submissions into Google Sheets while sending branded Gmail confirmations.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWebhook\u003c\/strong\u003e endpoint for \u003ccode\u003e\/lead-intake\u003c\/code\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes used:\u003c\/strong\u003e if, code, gmail, webhook, sticky note, google sheets\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSpreadsheet header row:\u003c\/strong\u003e \u003ccode\u003ereceived_at, name, email, phone, message, source, valid, errors\u003c\/code\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTested on:\u003c\/strong\u003e n8n 1.97\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eSetup \u0026amp; customization\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eConnect \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e + \u003cstrong\u003eGmail\u003c\/strong\u003e (or SMTP).\u003c\/li\u003e\n  \u003cli\u003ePaste the webhook URL into your form.\u003c\/li\u003e\n  \u003cli\u003eCustomize the Gmail auto-reply subject and message (for example, replace \u003ccode\u003eYOUR BUSINESS NAME\u003c\/code\u003e).\u003c\/li\u003e\n  \u003cli\u003eActivate the workflow and configure your form to POST to the production webhook URL for \u003ccode\u003e\/lead-intake\u003c\/code\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46236462940339,"sku":"N8N-21013","price":20.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/ndUERXX9U2GPSWZvid6m9_u7BaJoK3.png?v=1792227813","url":"https:\/\/buyflowscripts.com\/products\/capture-website-form-leads-to-google-sheets-gmail-auto-reply","provider":"N8N Commerce","version":"1.0","type":"link"}