This workflow follows the Emailsend → Google Sheets recipe pattern — see all workflows that pair these two integrations.
The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"id": "demo-messy-legacy",
"name": "Messy Legacy Workflow",
"nodes": [
{
"id": "legacy-webhook",
"name": "Legacy Webhook",
"type": "n8n-nodes-base.webhook",
"parameters": {
"path": "legacy/customer-sync",
"httpMethod": "POST"
}
},
{
"id": "legacy-switch",
"name": "Switch Legacy Route",
"type": "n8n-nodes-base.switch",
"parameters": {
"numberOfOutputs": 3,
"rules": [
{
"value1": "={{$json.priority}}",
"operation": "equal",
"value2": "high"
},
{
"value1": "={{$json.priority}}",
"operation": "equal",
"value2": "normal"
}
]
}
},
{
"id": "custom-transform",
"name": "Normalize Customer",
"type": "acme-nodes-base.customerNormalizer",
"parameters": {
"mode": "legacy-demo"
}
},
{
"id": "crm-update",
"name": "CRM Update",
"type": "n8n-nodes-base.postgres",
"parameters": {
"operation": "update",
"table": "customers",
"matchingColumn": "demo_customer_id"
}
},
{
"id": "notify-ops",
"name": "Notify Ops",
"type": "n8n-nodes-base.slack",
"parameters": {
"resource": "message",
"operation": "post",
"channel": "#demo-legacy",
"text": "High priority legacy sync completed."
}
},
{
"id": "notify-ops-copy",
"name": "Notify Ops Copy",
"type": "n8n-nodes-base.emailSend",
"parameters": {
"toEmail": "ops@example.test",
"subject": "Legacy sync completed"
}
},
{
"id": "audit-append",
"name": "Append Audit Row",
"type": "n8n-nodes-base.googleSheets",
"parameters": {
"operation": "append",
"sheetName": "demo_legacy_audit"
}
},
{
"id": "old-csv-trigger",
"name": "Old CSV Trigger",
"type": "n8n-nodes-base.manualTrigger",
"parameters": {}
},
{
"id": "old-csv-mapper",
"name": "Normalize Customer Copy",
"type": "n8n-nodes-base.function",
"parameters": {
"functionCode": "return items;"
}
},
{
"id": "dead-helper",
"name": "Dead Legacy Helper",
"type": "legacy.internalHelper",
"parameters": {
"note": "Intentionally isolated demo node."
}
}
],
"connections": {
"Legacy Webhook": {
"main": [
[
{
"node": "Switch Legacy Route",
"type": "main",
"index": 0
}
]
]
},
"Switch Legacy Route": {
"main": [
[
{
"node": "Normalize Customer",
"type": "main",
"index": 0
}
],
[
{
"node": "CRM Update",
"type": "main",
"index": 0
}
],
[]
]
},
"Normalize Customer": {
"main": [
[
{
"node": "CRM Update",
"type": "main",
"index": 0
}
]
]
},
"CRM Update": {
"main": [
[
{
"node": "Notify Ops",
"type": "main",
"index": 0
},
{
"node": "Notify Ops Copy",
"type": "main",
"index": 0
}
]
]
},
"Notify Ops": {
"main": [
[
{
"node": "Append Audit Row",
"type": "main",
"index": 0
}
]
]
},
"Notify Ops Copy": {
"main": [
[
{
"node": "Append Audit Row",
"type": "main",
"index": 0
}
]
]
},
"Old CSV Trigger": {
"main": [
[
{
"node": "Normalize Customer Copy",
"type": "main",
"index": 0
}
]
]
}
}
}
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
Messy Legacy Workflow. Uses acme-nodes-base, postgres, slack, emailSend. Webhook trigger; 10 nodes.
Source: https://github.com/jiushiaaa/OpenWorkflowDoctor/blob/928f5f7581953242b109acc52aa2db0466a3c92e/samples/n8n/messy-legacy.workflow.json — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
Receive request via webhook with customer question Analyze sentiment and detect urgency using JavaScript Send urgent alerts to Slack for critical cases Search knowledge base and fetch conversation his
PURPOSE: Automatically send professional appointment reminders via email and SMS to reduce no-shows and improve patient experience.
zaad9_teams_dane. Uses emailSend, airtable, slack, microsoftTeams. Webhook trigger; 7 nodes.
aula-00-mapa-do-n8n. Uses emailReadImap, stopAndError, httpRequest, graphql. Event-driven trigger; 46 nodes.
Scheduled processes retrieve customer feedback from multiple channels. The system performs sentiment analysis to classify tone, then uses OpenAI models to extract themes, topics, and urgency indicator