Log cleaning enquiries to Google Sheets and auto-reply with Gmail
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 16 nodes and runs when an HTTP POST request hits its webhook URL. Along the way it connects Google Sheets and Gmail.
How it runs
Trigger: When an HTTP POST request hits its webhook URL.
- config (Code): runs custom JavaScript code
- read the form fields (Code): runs custom JavaScript code
- a real enquiry? (If): checks a condition and branches into true / false
- assign an owner (Code): runs custom JavaScript code
- STOP: spam or incomplete (Code): runs custom JavaScript code
- write the first reply (Code): runs custom JavaScript code
- Reply to the website (Respond to Webhook): sends the response back to the webhook caller
- row for the sheet (Code): runs custom JavaScript code
- [cred] Sheets - log the enquiry (Google Sheets): append
- sending? (If): checks a condition and branches into true / false
…plus 4 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (7)
- Webhook
n8n-nodes-base.webhook - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Google Sheets
n8n-nodes-base.googleSheets - Gmail
n8n-nodes-base.gmail - No Operation, do nothing
n8n-nodes-base.noOp - Respond to Webhook
n8n-nodes-base.respondToWebhook
From the author
Quick overview This workflow receives Shopify, Etsy, or Square order webhooks, normalizes them into a single order format, logs new orders to a Google Sheets “Orders” tab, and sends a confirmation email via Gmail (with preview/test modes), then updates the…