Send post-delivery CSAT surveys and log responses with Gmail, Google Sheets and Typeform
Ready for 3.0What this workflow does
This workflow has 19 nodes and runs when an HTTP POST request hits its webhook URL (plus 1 other trigger). Along the way it connects Gmail and Google Sheets.
How it runs
Trigger: When an HTTP POST request hits its webhook URL (plus 1 other trigger).
- Validate Delivered Event (If): checks a condition and branches into true / false
- Validate CSAT Submission (If): checks a condition and branches into true / false
- Extract Order Data (Edit Fields (Set)): sets or maps fields
- Locate Order in CSAT Sheet (Google Sheets): uses Google Sheets
- Validate Customer Email (If): checks a condition and branches into true / false
- Update CSAT Record (Google Sheets): update
- Fetch Sent Survey Records (Google Sheets): uses Google Sheets
- Standardize CSAT Payload (Edit Fields (Set)): sets or maps fields
- Determine Survey Eligibility (Code): runs custom JavaScript code
- CSAT Classification Engine (Code): runs custom JavaScript code
…plus 7 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 (8)
- Gmail
n8n-nodes-base.gmail - Webhook
n8n-nodes-base.webhook - If
n8n-nodes-base.if - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - Wait
n8n-nodes-base.wait - Switch
n8n-nodes-base.switch
From the author
Post-Delivery CSAT Automation System > n8n + Gmail + Google Sheets + Typeform --- This n8n workflow automates the entire post-delivery customer feedback loop. It sends a survey email after delivery, logs it in Google Sheets, captures CSAT responses,…