Sync Multi-Bank Balance Data to BigQuery using Plaid — n8n Workflow
Overview
Automated Multi-Bank Balance Sync to BigQuery
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.
Who’s it for? Finance teams, accountants, and data engineers managing consolidated bank reporting in Google BigQuery.
How it works The Schedule Trigger runs weekly. Four Plaid API calls fetch balances from RBC, Amex, Wise, and
Nodes used
Workflow Preview
How it Works
- 1
Trigger
The workflow starts with a scheduled trigger, running on a defined schedule.
- 2
Process
Data flows through 17 nodes, connecting code, googlebigquery, httprequest.
- 3
Output
The workflow completes its automation and delivers the result to the configured destination.
Node Details (17)
HTTP Request
httpRequest
Google BigQuery
googleBigQuery
Code
code
How to Import This Workflow
- 1Click Download JSON button on the right to save the workflow file.
- 2Open your n8n instance. Go to Workflows → New → Import from file.
- 3Select the downloaded
sync-multi-bank-balance-data-to-bigquery-using-plaidfile and click Import. - 4Set up credentials for each service node (API keys, OAuth, etc.).
- 5Click Test Workflow to verify everything works, then activate it.
Or paste directly in n8n → Import from JSON:
Integrations
Created by
Fahmi Fahreza
@fahmiiireza
Tags
New to n8n?
n8n is a free, open-source workflow automation tool. Self-host it or use the cloud version.
Get n8n Free →