Sync QuickBooks chart of accounts to Google BigQuery
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 a schedule (every week). Along the way it connects Google BigQuery. It also calls quickbooks.api.intuit.com over HTTP.
How it runs
Trigger: On a schedule (every week).
- 1. Get Updated Accounts from QuickBooks (HTTP Request): calls quickbooks.api.intuit.com
- 2. Structure Account Data (Code): runs custom JavaScript code
- 3. Format Data for SQL (Code): runs custom JavaScript code
- 4. Load Accounts to BigQuery (Google BigQuery): uses Google BigQuery
Services it uses
HTTP calls to: 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 (4)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - Google BigQuery
n8n-nodes-base.googleBigQuery
From the author
Quick overview Keep a historical, structured copy of your QuickBooks Chart of Accounts in BigQuery. This n8n workflow runs weekly, syncing new or updated accounts for better reporting and long-term tracking. How it works 1. Every Monday, the workflow…