{ "edges": [ { "to": "a4f93441-e29b-494d-a69c-d3bfd5695448", "from": "c553c09e-5f4c-44d0-979b-344191c6c3b4", "toPort": "0", "fromPort": "0" }, { "to": "5d3befc8-8831-42a2-9d83-0a81df2ab1f9", "from": "3077ceaa-38d5-4b20-b3f3-96c9c9587121", "toPort": "0", "fromPort": "0" }, { "to": "3c180c3d-c5e1-4a34-894b-973ac7cfe246", "from": "3077ceaa-38d5-4b20-b3f3-96c9c9587121", "toPort": "0", "fromPort": "1" }, { "to": "b09a3969-8253-4bac-94e7-b053a8fd48f1", "from": "3077ceaa-38d5-4b20-b3f3-96c9c9587121", "toPort": "0", "fromPort": "2" }, { "to": "3077ceaa-38d5-4b20-b3f3-96c9c9587121", "from": "d4ad096a-addf-48c7-a693-fc07e30f1ed6", "toPort": "0", "fromPort": "0" }, { "to": "cc898a60-e1af-4a6c-b26a-fbd53a88cba3", "from": "a4f93441-e29b-494d-a69c-d3bfd5695448", "toPort": "0", "fromPort": "0" }, { "to": "c553c09e-5f4c-44d0-979b-344191c6c3b4", "from": "24749ad3-95c9-4d7d-a8a5-1e39c5257909", "toPort": "0", "fromPort": "0" } ], "nodes": [ { "id": "24749ad3-95c9-4d7d-a8a5-1e39c5257909", "name": "Stripe Subscription Canceled", "type": "integration", "params": { "events": [ "customer.subscription.deleted" ], "service": "stripetrigger", "operation": "run", "__originalType": "n8n-nodes-base.stripeTrigger" }, "position": [ -240, 320 ] }, { "id": "c553c09e-5f4c-44d0-979b-344191c6c3b4", "name": "Get Customer Details", "type": "integration", "params": { "service": "stripe", "resource": "customer", "operation": "run", "customerId": "={{ $json.data.object.customer }}", "__originalType": "n8n-nodes-base.stripe" }, "position": [ 112, 320 ] }, { "id": "a4f93441-e29b-494d-a69c-d3bfd5695448", "name": "Send Feedback Survey Email", "type": "integration", "params": { "html": "=

Hi {{ $json.name || \"there\" }},

\n\n

Thank you for being a customer. We're sorry to see you go.

\n\n

To help us improve our service, would you mind sharing why you decided to cancel? It only takes 1 minute:

\n\n

Share Your Feedback

\n\n

You were subscribed to: {{ $('Stripe Subscription Canceled').item.json.data.object.items.data[0].plan.nickname || 'Your Plan' }}

\n\n

Your feedback means the world to us and will help us serve our customers better.

\n\n

Thank you,
[Your Company Name]

\n\n

If you have any questions, feel free to reply to this email.

", "options": {}, "service": "smtp", "subject": "We're sorry to see you go — Quick 1-min survey", "toEmail": "={{ $json.email }}", "fromEmail": "user@example.com", "operation": "read" }, "position": [ 480, 320 ] }, { "id": "cc898a60-e1af-4a6c-b26a-fbd53a88cba3", "name": "Log to Cancellations Sheet", "type": "integration", "params": { "columns": { "value": { "Plan Name": "={{ $('Stripe Subscription Canceled').item.json.data.object.items.data[0].plan.nickname || $('Stripe Subscription Canceled').item.json.data.object.items.data[0].plan.id }}", "Email Sent": "={{ $('Send Feedback Survey Email').item.json.accepted ? 'Success' : 'Failed' }}", "Customer ID": "={{ $('Stripe Subscription Canceled').item.json.data.object.customer }}", "Customer Name": "={{ $('Get Customer Details').item.json.name || 'N/A' }}", "Customer Email": "={{ $('Get Customer Details').item.json.email }}", "Cancellation Date": "={{ new Date().toISOString() }}" }, "schema": [ { "id": "Cancellation Date", "required": false, "displayName": "Cancellation Date", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Customer ID", "required": false, "displayName": "Customer ID", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Customer Email", "required": false, "displayName": "Customer Email", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Customer Name", "required": false, "displayName": "Customer Name", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Plan Name", "required": false, "displayName": "Plan Name", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Email Sent", "required": false, "displayName": "Email Sent", "defaultMatch": false, "canBeUsedToMatch": true } ], "mappingMode": "defineBelow", "matchingColumns": [] }, "options": {}, "service": "googleSheets", "operation": "append", "sheetName": { "__rl": true, "mode": "list", "value": "gid=0" }, "documentId": { "__rl": true, "mode": "list", "value": "" } }, "position": [ 832, 320 ] }, { "id": "d4ad096a-addf-48c7-a693-fc07e30f1ed6", "name": "Survey Response Webhook", "type": "trigger", "params": { "kind": "n8n-nodes-base.webhook", "path": "survey-response", "options": {}, "httpMethod": "POST" }, "position": [ -240, 640 ] }, { "id": "3077ceaa-38d5-4b20-b3f3-96c9c9587121", "name": "Route by Feedback Type", "type": "switch", "params": { "rules": { "values": [ { "outputKey": "Price Concerns", "conditions": { "options": { "caseSensitive": false }, "combinator": "or", "conditions": [ { "operator": { "type": "string", "operation": "contains" }, "leftValue": "={{ $json.reason }}", "rightValue": "expensive" } ] }, "renameOutput": true }, { "outputKey": "Feature Requests", "conditions": { "options": { "caseSensitive": false }, "combinator": "or", "conditions": [ { "operator": { "type": "string", "operation": "contains" }, "leftValue": "={{ $json.reason }}", "rightValue": "feature" } ] }, "renameOutput": true } ] }, "options": { "fallbackOutput": "extra" } }, "position": [ 112, 624 ] }, { "id": "5d3befc8-8831-42a2-9d83-0a81df2ab1f9", "name": "Log Price Concerns", "type": "integration", "params": { "columns": { "value": { "Plan Name": "={{ $json.plan }}", "Customer Name": "={{ $json.name }}", "Response Date": "={{ new Date().toISOString() }}", "Customer Email": "={{ $json.email }}", "Additional Comments": "={{ $json.comments || 'N/A' }}", "Cancellation Reason": "={{ $json.reason }}" }, "schema": [ { "id": "Response Date", "required": false, "displayName": "Response Date", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Customer Email", "required": false, "displayName": "Customer Email", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Customer Name", "required": false, "displayName": "Customer Name", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Plan Name", "required": false, "displayName": "Plan Name", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Cancellation Reason", "required": false, "displayName": "Cancellation Reason", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Additional Comments", "required": false, "displayName": "Additional Comments", "defaultMatch": false, "canBeUsedToMatch": true } ], "mappingMode": "defineBelow", "matchingColumns": [] }, "options": {}, "service": "googleSheets", "operation": "append", "sheetName": { "__rl": true, "mode": "name", "value": "Price Concerns" }, "documentId": { "__rl": true, "mode": "list", "value": "" } }, "position": [ 480, 512 ] }, { "id": "3c180c3d-c5e1-4a34-894b-973ac7cfe246", "name": "Log Feature Requests", "type": "integration", "params": { "columns": { "value": { "Plan Name": "={{ $json.plan }}", "Customer Name": "={{ $json.name }}", "Response Date": "={{ new Date().toISOString() }}", "Customer Email": "={{ $json.email }}", "Additional Comments": "={{ $json.comments || 'N/A' }}", "Cancellation Reason": "={{ $json.reason }}" }, "schema": [ { "id": "Response Date", "required": false, "displayName": "Response Date", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Customer Email", "required": false, "displayName": "Customer Email", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Customer Name", "required": false, "displayName": "Customer Name", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Plan Name", "required": false, "displayName": "Plan Name", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Cancellation Reason", "required": false, "displayName": "Cancellation Reason", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Additional Comments", "required": false, "displayName": "Additional Comments", "defaultMatch": false, "canBeUsedToMatch": true } ], "mappingMode": "defineBelow", "matchingColumns": [] }, "options": {}, "service": "googleSheets", "operation": "append", "sheetName": { "__rl": true, "mode": "name", "value": "Feature Requests" }, "documentId": { "__rl": true, "mode": "list", "value": "" } }, "position": [ 480, 640 ] }, { "id": "b09a3969-8253-4bac-94e7-b053a8fd48f1", "name": "Log Other Feedback", "type": "integration", "params": { "columns": { "value": { "Plan Name": "={{ $json.plan }}", "Customer Name": "={{ $json.name }}", "Response Date": "={{ new Date().toISOString() }}", "Customer Email": "={{ $json.email }}", "Additional Comments": "={{ $json.comments || 'N/A' }}", "Cancellation Reason": "={{ $json.reason }}" }, "schema": [ { "id": "Response Date", "required": false, "displayName": "Response Date", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Customer Email", "required": false, "displayName": "Customer Email", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Customer Name", "required": false, "displayName": "Customer Name", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Plan Name", "required": false, "displayName": "Plan Name", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Cancellation Reason", "required": false, "displayName": "Cancellation Reason", "defaultMatch": false, "canBeUsedToMatch": true }, { "id": "Additional Comments", "required": false, "displayName": "Additional Comments", "defaultMatch": false, "canBeUsedToMatch": true } ], "mappingMode": "defineBelow", "matchingColumns": [] }, "options": {}, "service": "googleSheets", "operation": "append", "sheetName": { "__rl": true, "mode": "name", "value": "Other Feedback" }, "documentId": { "__rl": true, "mode": "list", "value": "" } }, "position": [ 480, 784 ] } ] }

Automate cancellation feedback collection with Stripe and Google Sheets