Sync Multi-Bank Balance Data to BigQuery using Plaid — n8n 工作流
概览
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
使用的节点
HTTP RequestGoogle BigQueryCode
工作流预览
⚡
S
Schedule Trigger
Fetch RBC Balances (Plaid)
Fetch Amex Balances (Pla…
Fetch Wise Balances (Pla…
Fetch PayPal Balances (P…
S
Split RBC Accounts
S
Split Amex Accounts
S
Split Wise Accounts
S
Split PayPal Accounts
Map RBC Accounts to QBO
Map Amex Accounts to QBO
Map Wise Accounts to QBO
Map PayPal Accounts to QBO
C
Combine All Accounts
Structure Account Records
Prepare BigQuery Insert
Load Accounts into BigQu…
17 nodes19 edges
工作原理
- 1
触发器
工作流由 定时 触发器启动,按预定计划运行。
- 2
处理
数据流经 17 个节点, connecting code, googlebigquery, httprequest。
- 3
输出
工作流完成自动化并将结果发送到配置的目标。
节点详情 (17)
HT#1
HTTP Request
httpRequest
GO#2
Google BigQuery
googleBigQuery
CO#3
Code
code
如何导入此工作流
- 1点击右侧 下载 JSON 按钮保存工作流文件。
- 2打开你的 n8n 实例,依次点击 工作流 → 新建 → 从文件导入。
- 3选择下载的
sync-multi-bank-balance-data-to-bigquery-using-plaid文件并点击导入。 - 4为每个服务节点配置 凭证(API 密钥、OAuth 等)。
- 5点击 测试工作流 验证一切正常,然后激活它。
或直接在 n8n → 从 JSON 导入 中粘贴:
{ "name": "Sync Multi-Bank Balance Data to BigQuery using Plaid", "nodes": [...], ...}
集成
codegooglebigqueryhttprequestmergescheduletriggersplitout
创建者
Fahmi Fahreza
@fahmiiireza
标签
codegooglebigqueryhttprequestmergescheduletriggersplitout