Automate expense reporting from Airtable to QuickBooks
Ready for 3.0What this workflow does
This workflow has 9 nodes and runs on Airtable events. Along the way it connects Airtable. It also calls sandbox-quickbooks.api.intuit.com over HTTP.
How it runs
Trigger: On Airtable events.
- Search records (Airtable): search
- If: checks a condition and branches into true / false
- Download File (HTTP Request): calls an HTTP API
- QBO-Create Expense (HTTP Request): calls sandbox-quickbooks.api.intuit.com (POST)
- Merge: merges the data from its input branches
- QBO-Upload File (HTTP Request): calls sandbox-quickbooks.api.intuit.com (POST)
- Update record (Airtable): update
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 (6)
- Airtable Trigger
n8n-nodes-base.airtableTrigger - Airtable
n8n-nodes-base.airtable - If
n8n-nodes-base.if - No Operation, do nothing
n8n-nodes-base.noOp - HTTP Request
n8n-nodes-base.httpRequest - Merge
n8n-nodes-base.merge
From the author
This n8n template from Intuz provides a complete solution to automate your expense approval and accounting process. It seamlessly connects an Airtable base, where expenses are submitted, to your QuickBooks account, eliminating manual data entry and ensuring…