Capture Customer Inquiries: n8n Form to Google Sheets

Capture Customer Inquiries and Save Them to Google Sheets Automatically

This n8n workflow receives customer inquiry submissions from an n8n Form and appends each inquiry as a new row in Google Sheets—cleaning key fields along the way and sending a confirmation message to the submitter.

What this workflow does

• Receives inquiries via an n8n Form trigger whenever a user submits the form.
• Normalizes the submitted data by adding a Europe/Berlin timestamp, trimming text fields, converting the email to lowercase, and setting Status to “NEU”.
• Appends a new row to a specified Google Sheets tab with the normalized fields.
• Returns a confirmation message indicating the request was saved.

Use cases

• Turn website or product inquiry forms into a structured customer inbox inside Google Sheets.
• Collect lead details (Name, E-Mail, Telefon, Ort, Anliegen) and track incoming requests using Status = NEU.
• Give SaaS operators a lightweight CRM-like intake process without building a full database.

Technical details

• Nodes / tools used: set, sticky note, form trigger, google sheets
• Google Sheets column expectations: Datum, Name, E-Mail, Telefon, Ort, Anliegen, Status
• Configuration: Add a Google Sheets credential in n8n, then set YOUR_GOOGLE_SHEET_ID and YOUR_SHEET_TAB_GID in the Google Sheets node.
• Validation: Use the Form trigger Test URL to submit a sample inquiry and confirm the row appears in your sheet.

Get cleaner inquiry data and automatic Google Sheets logging with an n8n automation built specifically for capturing customer inquiries.