AustraliaNow Live
·Australian banks now supported via CDR.Browse AU banks
BankSync

Sync Canadian bank data to Google Sheets

Transactions, balances and holdings from any CDB-accessible Canadian bank land in Google Sheets on a schedule, read-only and mapped to your columns.

Start free trialAll Canada options →
RBC Chequing and TD Visa, synced at 6:02am into Transactions 2026.

Canadian banks to Google Sheets, in three steps.

  1. 01

    Connect your Canadian bank

    Pick your bank from the list: big banks, neobanks, regionals and brokerages. Authorise read-only access on your bank’s own consent screen.

    RBCRead-only
    TDRead-only
    ScotiabankRead-only
    ConsentBank’s own screen
  2. 02

    Map fields into Google Sheets

    Connect your Google Sheets workspace and map BankSync fields to its columns or properties.

    DateA · Date
    MerchantB · Description
    CategoryC · Category
    AmountD · Amount
    AccountE · Account
  3. 03

    Save and sync

    Your bank data appears in Google Sheets on the next run. Choose hourly, daily, or weekly automatic syncs based on your plan, or run a manual sync at any time.

    HourlyDailyWeekly
    Next runTomorrow, 6:00am
    Last run● 3 new rows, 6:02am

Set up Google Sheets, start to finish.

Choose the spreadsheet, tab, and write shape your model expects. Filmed with sample accounts.

What lands in your sheet.

Date
The day the bank posted the transaction. 19/10/2026
Description
The description the bank gives the transaction. Loblaws
Category
A spending category you can filter, group and chart by. Groceries
Amount
Signed, in the account’s currency: money out is negative. -$92.14
Account
The account the row came from, so several banks share one table. RBC Chequing
Account #
The last four digits of the account number. xxxx1070
Institution
The bank or card issuer behind the account. RBC
Map them onto the columns you already have, in any order. One row per transaction, keyed so a re-sync never writes it twice.

Canadian banks we support.

Credit unions

All Canadian institutions (185)

Browse all 185 Canadian banks →

Canadian banks are the start. Not the whole story.

BankSync

Spreadsheets

Workspaces

AI you choose

Your code

Canadian banks to Google Sheets, in short.

How
BankSync syncs supported Canadian account data from CDB-accessible banks to Google Sheets. Choose hourly, daily, or weekly automatic syncs based on your plan, or run a manual sync at any time. Connect through the regulated CDB consent flow; banking credentials are never stored.
CDB
Consumer-Driven Banking, regulated by Department of Finance Canada. Canada's Consumer-Driven Banking framework (rolling out 2025-2026) provides a regulated path for sharing bank data. Until full rollout, BankSync routes through Plaid under existing data-sharing agreements.Consumer-Driven Banking Act
Data
Transactions, balances and holdings, where the provider, account type and your consent support them. Live transaction tabs.
History
United States, Canada, and Australia up to 2 years and United Kingdom up to 60 days.
Other destinations
Canadian → NotionCanadian → AirtableCanadian → Excel

Questions, answered.

How do I sync Canadian bank data to Google Sheets?

Sign up for BankSync, connect your Canadian bank via the CDB consent flow, choose Google Sheets as the destination, map the fields, and save. Choose hourly, daily, or weekly automatic syncs based on your plan, or run a manual sync at any time.

Which Canadian banks can I sync to Google Sheets?

Every CDB-accessible institution. That includes the major banks (RBC Royal Bank, TD Canada Trust, Scotiabank, BMO), neobanks, regional banks, and credit unions.

Is my Canadian banking data safe?

Yes. BankSync only ever holds a scoped, revocable CDB consent, never your bank credentials. All connections are made through licensed providers (Plaid).

How often does Google Sheets update?

Choose hourly, daily, or weekly automatic syncs based on your plan, or run a manual sync at any time.

Can I sync multiple Canadian banks to the same Google Sheets workspace?

Yes. Connect as many Canadian institutions as you want; BankSync writes them all into the same Google Sheets spreadsheet with an account column so you can filter by bank.

Is BankSync available in Canada?

Yes. BankSync is live in Canada and supports the Big 6 (RBC, TD, Scotiabank, BMO, CIBC, National Bank), digital banks like Tangerine and EQ Bank, and major credit unions like Desjardins. We connect through Plaid.

When will Canadian Open Banking go live?

Canada's Consumer-Driven Banking framework was passed in 2024 and is rolling out through 2025-2026. BankSync will migrate to the regulated framework as soon as it is live, with no change required from users.

Sync Canadian bank data to Google Sheets.

Start free trialView pricing →