Sync multi-bank balance data to BigQuery using Plaid

Description

Quick overview
This workflow automatically fetches balances from multiple financial institutions (RBC, Amex, Wise, PayPal) using Plaid, maps them to QuickBooks account names, and loads structured records into Google BigQuery for analytics.

How it works
The Schedule Trigger runs weekly.
Four Plaid API calls fetch balances from RBC, Amex, Wise, and PayPal.
Each response splits out individual accounts and maps them to QuickBooks names.
All accounts are merged into one dataset.
The workflow structures the account data, generates UUIDs, and formats SQL inserts.
BigQuery node uploads the finalized records.

Setup
Add your Plaid and Google BigQuery credentials in the n8n Credential Manager before making any changes to the workflow.
Open the configuration node and replace all hardcoded client IDs and secrets with the corresponding credential variables you just created.
Test each credential connection individually to confirm Plaid and BigQuery are both authenticating and responding correctly.
Open the Schedule Trigger node and set the frequency to match your preferred reporting cadence before activating the workflow.

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