Sync QuickBooks Chart of Accounts to Google BigQuery - n8n Workflow | Neura Market
Sync QuickBooks Chart of Accounts to Google BigQuery
Weekly ETL workflow that syncs updated QuickBooks accounts to BigQuery for historical financial tracking and analysis.
This n8n workflow automates the synchronization of your QuickBooks Chart of Accounts to Google BigQuery, running every Monday to capture accounts created or updated in the past 7 days. It extracts data via QuickBooks API, transforms it by cleaning responses, handling currencies, generating stable IDs, and formatting for SQL insertion, then loads it into BigQuery for upsert operations. This ensures a structured, historical archive ideal for long-term reporting.
Perfect for data analysts, BI deve
Platform
n8n
Category
CRM - Sales
Price
$14.99
Creator
BestWorkflows
QuickBooks
BigQuery
ETL
Finance
Accounting
Data Sync
BI
Analytics
Automation
Reporting
How to import this workflow into n8n
1Purchase or download the workflow to get the n8n workflow JSON file.
2In your n8n instance, open Workflows and choose "Import from File" (or paste the JSON with Ctrl+V on the canvas).
3Open each node marked with a credential warning and connect your own accounts and API keys.
4Run the workflow once manually to verify the data flow, then toggle it to Active.