This n8n workflow automates a weekly process to extract, transform, and load financial transactions from QuickBooks Online into Google BigQuery. Designed for financial analysts, data scientists, and business owners, it ensures a structured, enriched dataset for advanced reporting and analysis. The workflow begins every Monday, fetching last week’s transactions from QuickBooks. It then cleans and classifies each transaction using custom JavaScript logic, ensuring accurate categorization as income, expense, or internal transfer. After processing, the data is formatted into a bulk SQL insert statement, which is then executed to populate a designated BigQuery table, creating a reliable data warehouse for financial insights.