Capture cleaning enquiries from WordPress forms with Google Sheets and Gmail
Ready for 3.0What 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.
- Configure Enquiry Pipeline (Code): runs custom JavaScript code
- Parse Form Fields (Code): runs custom JavaScript code
- Check If Real Enquiry (If): checks a condition and branches into true / false
- Assign Enquiry Owner (Code): runs custom JavaScript code
- Handle Spam or Incomplete (Code): runs custom JavaScript code
- Compose First Reply (Code): runs custom JavaScript code
- Send Webhook Response to Site (Respond to Webhook): sends the response back to the webhook caller
- Prepare Sheet Row (Code): runs custom JavaScript code
- Append Enquiry to Sheets (Google Sheets): append
- Check Sending Condition (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 cleaning enquiries from a website form via a webhook, normalizes the submitted fields, logs each enquiry to Google Sheets, and (optionally) sends acknowledgement and owner-notification emails through Gmail based on…