# Weekly extraction and classification of QuickBooks transactions to BigQuery
This automation streamlines the ETL process for financial data: once a week, it pulls transactions from QuickBooks Online, cleans and classifies them (income, expense, transfer) using custom logic, and loads them into Google BigQuery. This enables complex SQL queries, long-term storage, and integration with other data sources.
## Who it´s for
- Financial analysts who need regular transaction exports from QuickBooks for analysis.
- Business owners looking to maintain a historical archive of financial activity.
- Accounting teams using data for reconciliation and audit purposes.
- BI developers building dashboards on structured financial datasets.
## What the automation does
- Runs weekly via a cron schedule trigger.
- Pulls last week’s transactions from QuickBooks Online.
- Cleans and normalizes data (removes duplicates, standardizes formats).
- Classifies transactions using embedded JavaScript logic.
- Formats data into secure SQL inserts and loads into Google BigQuery.
- Makes data immediately available for analytics after pipeline completion.
## What´s included
- Ready-to-use n8n workflow.
- Scheduled trigger and processing logic.
- Integrations with QuickBooks Online and Google BigQuery.
- Basic textual guide for setup and adaptation.
## Requirements for setup
- n8n instance (self-hosted or cloud).
- QuickBooks Online account with API access enabled.
- Google Cloud project with BigQuery activated and write permissions.
- Basic understanding of JSON, OAuth, and API usage.
## Benefits and outcomes
- Saves time on manual data export and formatting.
- Reduces human error in transaction classification.
- Centralized storage with full SQL analytical capabilities.
- Enables integration with other business systems.
- Ensures consistent weekly updates.
- Supports audit trails and financial reporting.
## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via chat
No feedback yet