Quick overview
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 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 structured SQL statement is executed and all transaction records are inserted into your designated Google BigQuery table. Setup Create a BigQuery dataset (e.g., quickbooks) and table (e.g., transactions) — ensure the table schema exactly matches the SQL query inside the Load Data to BigQuery node. Add your QuickBooks Online and Google BigQuery credentials in the n8n Credential Manager before configuring any other nodes. Open the Clean & Classify Transactions node and update the internalTransferAccounts, expenseCategories, and incomeCategories JavaScript arrays to match your QuickBooks Chart of Accounts exactly. Open the Load Data to BigQuery node, select the correct Google Cloud project, and verify the SQL query references the correct dataset and table name. Save and activate the workflow — it will now run automatically every Monday and load the previous week's transactions into BigQuery. Requirements A running n8n instance (Cloud or Self-Hosted) A QuickBooks Online account A Google Cloud Platform project with BigQuery enabled A BigQuery table with a matching schema Customization Change Schedule: Modify the schedule node to run daily, monthly, or at a different time Adjust Date Range: Change the date macro in the Get Last Week's Transactions node Refine Classification Rules: Add custom logic in the Clean & Classify Transactions node to handle specific edge cases Additional info Published by Fahmi Fahreza, Indonesia’s first official n8n Brand Ambassador and founder of WithMi Automation, built from real client implementations, not tutorials. → Let us build it for you: withmiautomation.com → Learn to build it yourself: academy.withmiautomation.com → Bring Fahmi to your team (training, workshop, talkshow): fahmiiireza.com. An n8n automation workflow template by Fahmi Fahreza.
Fahmi Fahreza
web
free
Others in the same category, ranked by how often they are opened.
