Manage customer inquiries from email & web forms with Slack & Google Sheets
Ready for 3.0What this workflow does
This workflow has 11 nodes and runs when a new email arrives over IMAP (plus 1 other trigger). Along the way it connects Google Sheets, Slack and Gmail.
How it runs
Trigger: When a new email arrives over IMAP (plus 1 other trigger).
- Extract Email Content (HTML): parses or builds HTML
- Parse Webhook Data (Edit Fields (Set)): sets 7 fields: customerName, customerEmail, subject…
- Parse Email Data (Edit Fields (Set)): sets 7 fields: customerName, customerEmail, subject…
- Merge: merges the data from its input branches
- Route by Inquiry Type (Switch): routes items into 3 branches
- Send Auto-Reply Email (Gmail): uses Gmail
- Save to Google Sheets (Google Sheets): append or update
- Notify Urgent - Slack (Slack): uses Slack
- Notify General - Slack (Slack): uses Slack
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 (9)
- Email Trigger (IMAP)
n8n-nodes-base.emailReadImap - Webhook
n8n-nodes-base.webhook - HTML
n8n-nodes-base.html - Edit Fields (Set)
n8n-nodes-base.set - Merge
n8n-nodes-base.merge - Switch
n8n-nodes-base.switch - Google Sheets
n8n-nodes-base.googleSheets - Slack
n8n-nodes-base.slack - Gmail
n8n-nodes-base.gmail
From the author
This n8n workflow is designed to centralize the management and tracking of customer inquiries received through multiple channels (email and web forms). Who's it for? Customer support teams Marketing teams Sales teams Small to medium-sized businesses…