Sync QuickBooks Chart of Accounts to Google BigQuery

Description

Sync QuickBooks Chart of Accounts to Google BigQuery
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.

Who Is This For?
Data Analysts & BI Developers**
Build a robust financial model and analyze changes over time.
Financial Analysts & Accountants**
Track structural changes in your Chart of Accounts historically.
Business Owners**
Maintain a permanent archive of your financial structure for future reference.

What the Workflow Does
Extract**
Every Monday, fetch accounts created or updated in the past 7 days from QuickBooks.
Transform**
Clean the API response, manage currencies, create stable IDs, and format the data.
Format**
Convert cleaned data into an SQL insert-ready structure.
Load**
Insert or update account records into BigQuery.

Setup Steps
1. Prepare BigQuery
Create a table (e.g., quickbooks.accounts) with columns matching the final SQL insert step.


2. Add Credentials
Connect QuickBooks Online and BigQuery credentials in n8n.


3. Configure the HTTP Node
Open 1. Get Updated Accounts from QuickBooks.
Replace the Company ID {COMPANY_ID} with your real Company ID.
Press Ctrl + Alt + ? in QuickBooks to find it.


4. Configure the BigQuery Node
Open 4. Load Accounts to BigQuery.
Select the correct project.
Make sure your dataset and table name are correctly referenced in the SQL.


5. Activate
Save and activate the workflow. It will now run every week.

Requirements
QuickBooks Online account
QuickBooks Company ID
Google Cloud project with BigQuery and a matching table

Customization Options
Change Sync Frequency**
Adjust the schedule node to run daily, weekly, etc.
Initial Backfill**
Temporarily update the API query to select * from Account for a full pull.
Add Fields**
Modify 2. Structure Account Data to include or transform fields as needed.