Weekly ETL pipeline: QuickBooks financial data to Google BigQuery
n8n template #6493Summary
Use templateQuick 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 business logic. How it works Every Monday, the workflow automatically fetches all transactions from the previous week directly from your QuickBooks Online account. Custom business logic cleans up text fields, generates stable transaction IDs, and classifies each transaction as income, expense, or internal transfer. The cleaned and enriched data is prepared as a bulk-insert-ready SQL statement formatted for BigQuery compatibility. The str
Hand off to your agent
Prompt
Help me set up the n8n workflow "Weekly ETL pipeline: QuickBooks financial data to Google BigQuery" (https://n8n.io/workflows/6493). It uses: QuickBooks Online, Google BigQuery, Code. Import the template JSON into my n8n instance, list every credential I need to create, and walk me through testing it.
Paste into Claude Code and it will do the rest.
Apps and nodes
Similar workflows
NameViews
- 🗼 AI powered supply chain control tower with BigQuery and GPT-4o7,497
- Full-cycle invoice automation: Airtable, QuickBooks & Stripe1,406
- Automate real-time QuickBooks invoice sync to Google Sheets1,074
- Automate real-time QuickBooks invoice alerts in Slack486
- Sync multi-bank balance data to BigQuery using Plaid361
- Automate QuickBooks sales receipts & customer creation from Stripe payments290
- Automate QuickBooks invoicing & customer creation from Airtable sales orders241
- Sync QuickBooks chart of accounts to Google BigQuery157