Automate QuickBooks invoicing & customer creation from Airtable sales orders
Ready for 3.0What this workflow does
This workflow has 17 nodes and runs when an HTTP GET request hits its webhook URL. Along the way it connects Airtable and QuickBooks Online. It also calls sandbox-quickbooks.api.intuit.com over HTTP.
How it runs
Trigger: When an HTTP GET request hits its webhook URL.
- Get Airtable Orders Records (Airtable): uses Airtable
- If: checks a condition and branches into true / false
- Get Customer Details (Airtable): uses Airtable
- QuickBooks - Find Customer (QuickBooks Online): get many
- If: checks a condition and branches into true / false
- Create a customer (QuickBooks Online): create
- Append Customers (Merge): merges the data from its input branches
- Get Products (Airtable): search
- Search Product ID (Airtable): search
- Data Preparation (Code): runs custom JavaScript code
…plus 6 more steps. See the full node list below.
Services it uses
HTTP calls to: sandbox-quickbooks.api.intuit.com
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 (8)
- Airtable
n8n-nodes-base.airtable - QuickBooks Online
n8n-nodes-base.quickbooks - Merge
n8n-nodes-base.merge - Code
n8n-nodes-base.code - HTTP Request
n8n-nodes-base.httpRequest - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Webhook
n8n-nodes-base.webhook - If
n8n-nodes-base.if
From the author
This n8n template from Intuz provides a complete solution to automate your entire invoicing process. It intelligently syncs confirmed sales orders from your Airtable base to QuickBooks, automatically creating new customers if they don't exist before…