What this automation does and who it is for
This automation gives your business a contact form that files itself. Someone fills in a short form (name, email, company and message), n8n tidies the answers, adds them as a new row in a Google Sheet and sends you an email alert. When you press Reply on that alert, your answer goes straight to the person who wrote to you, because the email's reply-to address is set to theirs.
It suits anyone who takes enquiries and keeps losing track of them: a freelancer with a portfolio site, a café that takes catering requests, a coach booking discovery calls, or a small agency collecting briefs. The usual pattern is a form tool that emails you, a pile of unread notifications, and enquiries that never reach a list you can sort or follow up. Here every reply lands in one sheet you can filter by date or company, and you still hear about each one within seconds.
Time saved, as an estimate: if you get ten enquiries a week and spend two to three minutes copying each one into a spreadsheet and replying, this removes 20 to 30 minutes of admin a week. The build takes about 20 to 30 minutes the first time.
What you need
n8n, the workflow automation tool this tutorial is built in. You can self-host the free Community Edition or use n8n Cloud; as of 19 November 2026 the n8n pricing page lists the Cloud Starter plan from €20 a month billed annually, with a free trial, and a free self-hosted Community Edition.
A Google account for Google Sheets and Gmail. Google Sheets is free for personal use, and a personal Gmail account is enough to send the alert.
One Google Sheet with a header row that reads exactly: Submitted at, Name, Email, Company, Message.
Credentials in n8n: a Google Sheets account credential and a Gmail account credential. A credential is the saved sign-in n8n uses to act on your behalf; you create it once under Credentials and pick it inside each node.
The form itself costs nothing extra. n8n's built-in Form Trigger hosts the form page for you, so you do not need Typeform, Tally or a website plugin.
The flow at a glance
There is one trigger and three steps. The trigger fires when someone submits the form. A clean-up step trims stray spaces, lower-cases the email address, fills in a blank company and converts the timestamp to your local time. After that, two steps run side by side from the same cleaned data: one appends a row to Google Sheets and one sends you the alert email.

Flow diagram: Contact Form, then Tidy Up Form Reply, then Save Reply to Google Sheets and Email Me About the New Reply side by side.

Illustration of the built workflow on the n8n canvas (node names and connections as built).
The two actions are wired in parallel on purpose. If Google Sheets is down or your sheet has been renamed, you still get the email, and the email does not wait for the sheet.
Build it step by step
Create a new workflow in n8n and name it something you will recognise later, for example Save contact form replies to Google Sheets and email me. Then add the four nodes below in order. A node is one box on the n8n canvas that does one job.
1. Contact Form (n8n Form Trigger)
Add the n8n Form Trigger node and rename it Contact Form. This node builds a web form and starts the workflow every time someone submits it.

Illustration of the n8n Contact Form settings.
Authentication: None, so anyone with the link can fill it in.
Form Title: Get in touch. Form Description: Tell us what you need and we will reply within one working day.
Form Elements: add four fields. Name (Text, required), Email (Email, required), Company (Text, optional) and Message (Textarea, required). Set each field's Field Name to the same word as its label (Name, Email, Company, Message). The field name is the key the next node reads, so the expressions later in this tutorial depend on it.
Respond When: Form Is Submitted.
Options: Form Path
contact-form(the last part of the form's web address), Button Label Send message, and a Form Response text of Thanks, we have your message and will reply soon.
Each submission arrives as one item with the four fields plus a submittedAt timestamp and a formMode value that says whether it came from the test form or the live one.
2. Tidy Up Form Reply (Edit Fields)
Add an Edit Fields (Set) node after the form and rename it Tidy Up Form Reply. It builds a clean, predictable record from the raw answers, so the sheet and the email both get the same tidy values. Set Mode to Manual Mapping, leave Include Other Input Fields off, and add five string fields.

Illustration of the n8n Tidy Up Form Reply settings.
submitted_at = {{ DateTime.fromISO($json.submittedAt).setZone("Australia/Sydney").toFormat("yyyy-MM-dd HH:mm") }}
name = {{ $json.Name.trim() }}
email = {{ $json.Email.trim().toLowerCase() }}
company = {{ $json.Company ? $json.Company.trim() : "Not given" }}
message = {{ $json.Message.trim() }}What each line does:
submitted_atreads the form's timestamp, converts it to Sydney time and formats it as year-month-day hour:minute, for example 2026-11-19 10:15. ChangeAustralia/Sydneyto your own time zone name, such asEurope/LondonorAmerica/New_York.DateTimeis the date library built into n8n expressions.nameremoves spaces from the start and end, so “ Alex Taylor ” becomes “Alex Taylor”.emailremoves spaces and lower-cases the address, so the same person typing their email in two ways still shows up as one address in your sheet.companyuses the company if one was given and writes “Not given” otherwise, so the column never has gaps.messageremoves trailing spaces and line breaks at the edges of the message.
Anything inside {{ }} is an expression, a small piece of JavaScript n8n runs for each item. $json means the data coming in from the previous node.
3. Save Reply to Google Sheets
Add a Google Sheets node, connect it to the output of Tidy Up Form Reply and rename it Save Reply to Google Sheets. It appends one row per form reply.

Illustration of the n8n Save Reply to Google Sheets settings. Pick your own spreadsheet and tab.
Credential to connect with: your Google Sheets account.
Resource: Sheet Within Document. Operation: Append Row.
Document and Sheet: choose your spreadsheet and tab from the list.
Mapping Column Mode: Map Each Column Manually. n8n reads your header row and shows one box per column.
Values to Send: Submitted at
{{ $json.submitted_at }}, Name{{ $json.name }}, Email{{ $json.email }}, Company{{ $json.company }}, Message{{ $json.message }}.Options: Cell Format set to let Google Sheets format the values (USER_ENTERED), so the date is stored as a date you can sort.
Settings tab: On Error set to Continue, so a problem with the sheet does not stop the email.
4. Email Me About the New Reply (Gmail)
Add a Gmail node, also connected to the output of Tidy Up Form Reply (not to the Sheets node), and rename it Email Me About the New Reply. Drag a second connection from Tidy Up Form Reply's output dot to this node to get the side-by-side layout.

Illustration of the n8n Email Me About the New Reply settings. Replace [email protected] with your address.
Credential to connect with: your Gmail account. Resource: Message. Operation: Send.
To: your own address.
Subject:
New contact form reply from {{ $json.name }}Email Type: Text.
Message: the template below.
Options: Append n8n attribution off, and Send Replies To set to
{{ $json.email }}. This is the step that makes the Reply button answer the sender.Settings tab: On Error set to Continue.
You have a new contact form reply.
Name: {{ $json.name }}
Email: {{ $json.email }}
Company: {{ $json.company }}
Sent: {{ $json.submitted_at }}
Message:
{{ $json.message }}
Hit reply to answer them directly.Test it
Leave the workflow inactive while you test. Open the Contact Form node and copy its Test URL, then click Execute workflow on the canvas so n8n starts listening, open the test URL in a new tab and submit the form with made-up details. The run appears in the editor straight away and each node shows a green tick with an item count.
We tested this build with two sample replies. The first had messy input: “ Alex Taylor ”, “[email protected] ” with a trailing space, no company, and a message with a trailing space, submitted at 10:15 Sydney time (stored by n8n as 23:15 UTC the previous day). The second was Sam Lee from Acme Bakery at 11:02. The Tidy Up Form Reply node produced the clean values shown below, and those are what the Sheets step writes.

Result: one new row per form reply, built from the test run's output (sample data).
The alert email for the first sample reply reads like this, with the reply-to address set to [email protected]:
Subject: New contact form reply from Alex Taylor
You have a new contact form reply.
Name: Alex Taylor
Email: [email protected]
Company: Not given
Sent: 2026-11-19 10:15
Message:
Hi, do you cater for office lunches of about 20 people on Fridays?
Hit reply to answer them directly.Success looks like this: a new row in the sheet with your local date and time, a clean lower-case email address and “Not given” in place of a blank company, plus an email in your inbox whose Reply button addresses the person who filled in the form. When you are happy, switch the workflow to Active and share the Contact Form node's Production URL instead of the test one.
Common problems and fixes
The time in the sheet is several hours out. This happened in our first test: the form stores its timestamp in UTC by default, and formatting it without a time zone gave 18:15 the previous day for a 10:15 Sydney submission. The n8n Form Trigger documentation confirms submittedAt uses UTC unless you turn on Use Workflow Timezone. The
setZone(...)call in Tidy Up Form Reply fixes it either way.“The provided authorization grant … is invalid, expired, revoked”. We hit this when running the finished workflow against a real sheet: the Google sign-in saved in the credential had expired. Open Credentials in n8n, open the Google Sheets and Gmail credentials and sign in again, then re-run.
The run shows green but no row appeared. Because both actions are set to On Error: Continue, a failed step passes its error along as data and the run still finishes. Click the Sheets or Gmail node in the execution and look for an
errorfield in its output. Switch On Error back to Stop Workflow while you are setting up if you prefer loud failures.Google Sheets says a column cannot be found. The node maps by header name. If you rename a column after building the node, the Google Sheets common issues page says to re-select Mapping Column Mode so n8n fetches the current headers, then map the fields again.
Live submissions do nothing. The test URL only works while you have clicked Execute workflow in the editor. Real visitors need the production URL, and that only works once the workflow is saved and active. Production runs do not show in the editor; look under Executions.
Make it yours
Send an instant thank-you. Add a third Gmail node from Tidy Up Form Reply that sends a short acknowledgement to
{{ $json.email }}. Test it with your own address first.Route by enquiry type. Add a Dropdown field (for example Catering, Quote, Other) and put a Switch node before the Gmail step, so catering requests go to one inbox and quotes to another.
Use your existing form tool. Swap the Form Trigger for a Webhook node or a Typeform or Tally trigger, keep the Tidy Up Form Reply step and map the incoming field names in its expressions.
Download the workflow
Copy the JSON below, then in n8n open a new workflow and paste it onto the canvas (or use Import from File). After importing, choose your own Google Sheets and Gmail credentials, pick your spreadsheet and tab, and replace [email protected] with your address. Credentials, IDs and personal details have been removed.
{
"name": "Save contact form replies to Google Sheets and email me",
"nodes": [
{
"name": "Contact Form",
"type": "n8n-nodes-base.formTrigger",
"typeVersion": 2.5,
"position": [240, 300],
"parameters": {
"authentication": "none",
"formTitle": "Get in touch",
"formDescription": "Tell us what you need and we will reply within one working day.",
"formFields": {
"values": [
{ "fieldLabel": "Name", "fieldName": "Name", "fieldType": "text", "placeholder": "Your full name", "requiredField": true },
{ "fieldLabel": "Email", "fieldName": "Email", "fieldType": "email", "placeholder": "[email protected]", "requiredField": true },
{ "fieldLabel": "Company", "fieldName": "Company", "fieldType": "text", "placeholder": "Optional", "requiredField": false },
{ "fieldLabel": "Message", "fieldName": "Message", "fieldType": "textarea", "placeholder": "How can we help?", "requiredField": true }
]
},
"responseMode": "onReceived",
"options": {
"path": "contact-form",
"buttonLabel": "Send message",
"respondWithOptions": { "values": { "respondWith": "text", "formSubmittedText": "Thanks, we have your message and will reply soon." } }
}
}
},
{
"name": "Tidy Up Form Reply",
"type": "n8n-nodes-base.set",
"typeVersion": 3.4,
"position": [520, 300],
"parameters": {
"mode": "manual",
"includeOtherFields": false,
"assignments": {
"assignments": [
{ "id": "f1", "name": "submitted_at", "value": "={{ DateTime.fromISO($json.submittedAt).setZone(\"Australia/Sydney\").toFormat(\"yyyy-MM-dd HH:mm\") }}", "type": "string" },
{ "id": "f2", "name": "name", "value": "={{ $json.Name.trim() }}", "type": "string" },
{ "id": "f3", "name": "email", "value": "={{ $json.Email.trim().toLowerCase() }}", "type": "string" },
{ "id": "f4", "name": "company", "value": "={{ $json.Company ? $json.Company.trim() : \"Not given\" }}", "type": "string" },
{ "id": "f5", "name": "message", "value": "={{ $json.Message.trim() }}", "type": "string" }
]
},
"options": {}
}
},
{
"name": "Save Reply to Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.7,
"position": [800, 200],
"onError": "continueRegularOutput",
"parameters": {
"resource": "sheet",
"operation": "append",
"authentication": "oAuth2",
"documentId": { "__rl": true, "mode": "list", "value": "" },
"sheetName": { "__rl": true, "mode": "list", "value": "" },
"columns": {
"mappingMode": "defineBelow",
"value": {
"Submitted at": "={{ $json.submitted_at }}",
"Name": "={{ $json.name }}",
"Email": "={{ $json.email }}",
"Company": "={{ $json.company }}",
"Message": "={{ $json.message }}"
},
"matchingColumns": [],
"schema": [
{ "id": "Submitted at", "displayName": "Submitted at", "required": false, "defaultMatch": false, "display": true, "type": "string", "canBeUsedToMatch": true },
{ "id": "Name", "displayName": "Name", "required": false, "defaultMatch": false, "display": true, "type": "string", "canBeUsedToMatch": true },
{ "id": "Email", "displayName": "Email", "required": false, "defaultMatch": false, "display": true, "type": "string", "canBeUsedToMatch": true },
{ "id": "Company", "displayName": "Company", "required": false, "defaultMatch": false, "display": true, "type": "string", "canBeUsedToMatch": true },
{ "id": "Message", "displayName": "Message", "required": false, "defaultMatch": false, "display": true, "type": "string", "canBeUsedToMatch": true }
]
},
"options": { "cellFormat": "USER_ENTERED" }
}
},
{
"name": "Email Me About the New Reply",
"type": "n8n-nodes-base.gmail",
"typeVersion": 2.2,
"position": [800, 400],
"onError": "continueRegularOutput",
"parameters": {
"resource": "message",
"operation": "send",
"authentication": "oAuth2",
"sendTo": "[email protected]",
"subject": "=New contact form reply from {{ $json.name }}",
"emailType": "text",
"message": "=You have a new contact form reply.\n\nName: {{ $json.name }}\nEmail: {{ $json.email }}\nCompany: {{ $json.company }}\nSent: {{ $json.submitted_at }}\n\nMessage:\n{{ $json.message }}\n\nHit reply to answer them directly.",
"options": { "appendAttribution": false, "replyTo": "={{ $json.email }}" }
}
}
],
"connections": {
"Contact Form": { "main": [[ { "node": "Tidy Up Form Reply", "type": "main", "index": 0 } ]] },
"Tidy Up Form Reply": { "main": [[ { "node": "Save Reply to Google Sheets", "type": "main", "index": 0 }, { "node": "Email Me About the New Reply", "type": "main", "index": 0 } ]] }
},
"settings": { "executionOrder": "v1" }
}
