Automated QuickBooks sales anomaly detector with professional email alerts
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 21 nodes and runs on a schedule (every day). Along the way it connects QuickBooks Online.
How it runs
Trigger: On a schedule (every day).
- Create_Date_Range (Edit Fields (Set)): sets or maps fields
- Fetch_30Day_Invoices (QuickBooks Online): uses QuickBooks Online
- Fetch_30Day_Sales_Receipts (HTTP Request): calls an HTTP API
- Fetch_Yesterday_Invoices (QuickBooks Online): uses QuickBooks Online
- Fetch_Yesterday_Sales_Receipts (HTTP Request): calls an HTTP API
- Filter: keeps only the items that match a condition
- Total_30Day_Sales_Receipts (Code): runs custom JavaScript code
- Filter: keeps only the items that match a condition
- Extract_Yesterday_Sales_Receipts (Code): runs custom JavaScript code
- Merging_30Day_Invoices_Sales_Receipts (Merge): merges the data from its input branches
…plus 10 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 (10)
- Edit Fields (Set)
n8n-nodes-base.set - QuickBooks Online
n8n-nodes-base.quickbooks - Filter
n8n-nodes-base.filter - HTTP Request
n8n-nodes-base.httpRequest - Summarize
n8n-nodes-base.summarize - If
n8n-nodes-base.if - Send Email
n8n-nodes-base.emailSend - Code
n8n-nodes-base.code - Merge
n8n-nodes-base.merge - Schedule Trigger
n8n-nodes-base.scheduleTrigger
From the author
📈 Is Your Business Flying Blind Day-to-Day? Get QuickBooks Sales Alerts That Matter. What if you could spot a major sales problem—or a winning campaign—the very next morning, instead of weeks later? Imagine receiving a beautiful, data-rich alert directly in…