{"product_id":"capture-customer-inquiries-n8n-form-to-google-sheets","title":"Capture Customer Inquiries: n8n Form to Google Sheets","description":"\u003ch3\u003eCapture Customer Inquiries and Save Them to Google Sheets Automatically\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003en8n workflow\u003c\/strong\u003e receives customer inquiry submissions from an \u003cstrong\u003en8n Form\u003c\/strong\u003e and \u003cstrong\u003eappends each inquiry as a new row in Google Sheets\u003c\/strong\u003e—cleaning key fields along the way and sending a confirmation message to the submitter.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives inquiries via an n8n Form trigger\u003c\/strong\u003e whenever a user submits the form.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes the submitted data\u003c\/strong\u003e by adding a \u003cstrong\u003eEurope\/Berlin timestamp\u003c\/strong\u003e, trimming text fields, converting the \u003cstrong\u003eemail to lowercase\u003c\/strong\u003e, and setting \u003cstrong\u003eStatus\u003c\/strong\u003e to \u003cstrong\u003e“NEU”\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends a new row\u003c\/strong\u003e to a specified \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e tab with the normalized fields.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReturns a confirmation message\u003c\/strong\u003e indicating the request was saved.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eTurn website or product inquiry forms into a structured \u003cstrong\u003ecustomer inbox\u003c\/strong\u003e inside \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eCollect lead details (Name, E-Mail, Telefon, Ort, Anliegen) and track incoming requests using \u003cstrong\u003eStatus = NEU\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eGive SaaS operators a lightweight CRM-like intake process without building a full database.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes \/ tools used:\u003c\/strong\u003e \u003cem\u003eset\u003c\/em\u003e, \u003cem\u003esticky note\u003c\/em\u003e, \u003cem\u003eform trigger\u003c\/em\u003e, \u003cem\u003egoogle sheets\u003c\/em\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets column expectations:\u003c\/strong\u003e \u003cem\u003eDatum, Name, E-Mail, Telefon, Ort, Anliegen, Status\u003c\/em\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eConfiguration:\u003c\/strong\u003e Add a Google Sheets credential in n8n, then set \u003cstrong\u003eYOUR_GOOGLE_SHEET_ID\u003c\/strong\u003e and \u003cstrong\u003eYOUR_SHEET_TAB_GID\u003c\/strong\u003e in the Google Sheets node.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidation:\u003c\/strong\u003e Use the Form trigger \u003cem\u003eTest URL\u003c\/em\u003e to submit a sample inquiry and confirm the row appears in your sheet.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003e\u003cstrong\u003eGet cleaner inquiry data and automatic Google Sheets logging\u003c\/strong\u003e with an n8n automation built specifically for capturing customer inquiries.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46086666911923,"sku":"N8N-19898","price":15.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/C-gnsobj7oGssbaaxGYsB_UZ1MnLX3.png?v=1790327610","url":"https:\/\/buyflowscripts.com\/products\/capture-customer-inquiries-n8n-form-to-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}