Automate QuickBooks customers & sales receipts generation from a Google Sheet
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 5 nodes and runs on Google Sheets events (row added). Along the way it connects Google Sheets and QuickBooks Online.
How it runs
Trigger: On Google Sheets events (row added).
- Check Customer Existence (QuickBooks Online): get many
- Customer Exists? (If): checks a condition and branches into true / false
- Create Sales Receipt (QuickBooks Online): create (payment)
- Create Customer (QuickBooks Online): create
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 (3)
- Google Sheets Trigger
n8n-nodes-base.googleSheetsTrigger - If
n8n-nodes-base.if - QuickBooks Online
n8n-nodes-base.quickbooks
From the author
This n8n template from Intuz provides a complete and automated solution to streamline your sales and accounting process. Simply add new transaction details to a designated Google Sheet, and this workflow takes over. Using specific status keywords in a column…