Weekly ETL pipeline: QuickBooks financial data 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 QuickBooks Online and Google BigQuery.
How it runs
Trigger: On a schedule (every week).
- 1. Get Last Week's Transactions (QuickBooks Online): work with transaction
- 2. Clean & Classify Transactions (Code): runs custom JavaScript code
- 3. Format Data for SQL (Code): runs custom JavaScript code
- 4. Load Data to BigQuery (Google BigQuery): uses Google BigQuery
Services it uses
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 - QuickBooks Online
n8n-nodes-base.quickbooks - Code
n8n-nodes-base.code - Google BigQuery
n8n-nodes-base.googleBigQuery
From the author
Quick overview This template sets up a weekly ETL (Extract, Transform, Load) pipeline that pulls financial data from QuickBooks Online into Google BigQuery. It not only transfers data, but also cleans, classifies, and enriches each transaction using your own…