Sync NAB to Google Sheets Automatically

Connect your National Australia Bank accounts via CDR and automatically push transactions, balances, and more into Google Sheets every day.

NAB Classic Banking and NAB Business Everyday, synced at 6:02am into Transactions 2026.

Set it up once. Then forget about it.

  1. 01

    Connect NAB via CDR

    Sign up for BankSync and authorise your NAB account through the official CDR consent flow. Your credentials are never shared with BankSync.

    NABRead-only
    CommBankRead-only
    UpRead-only
    ConsentCDR
  2. 02

    Connect your Google Sheet

    Authorise BankSync to write to your Google Sheets account, select or create a spreadsheet, and map transaction fields to your columns.

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

    Transactions sync automatically

    BankSync syncs your NAB transactions to Google Sheets daily. New rows are appended automatically; no action required from you.

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

What lands in your sheet.

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

Your sheet is one stop. Not the whole story.

NAB to Google Sheets, in short.

Consent
Read-only access under the Consumer Data Right (CDR), authorised on NAB’s own consent screen and revocable at any time. Your login is never stored.
Data
Transactions, balances and account details from transaction, savings and credit card accounts, where the account and your consent support them.
Schedule
Choose hourly, daily, or weekly automatic syncs based on your plan, or run a manual sync at any time.
History
United States, Canada, and Australia up to 2 years and United Kingdom up to 60 days.

Questions, answered.

How do I sync NAB transactions to Google Sheets?

Sign up for BankSync, connect your NAB account through the secure CDR authorisation flow, select Google Sheets as your destination, and configure your sync schedule. BankSync will automatically import your NAB transactions daily.

Is NAB supported by BankSync?

Yes. National Australia Bank (NAB) is supported via the Australian Consumer Data Right (CDR) framework. BankSync connects through Fiskil, an accredited CDR data recipient (ADRBNK000246), to securely access your NAB transaction data.

What NAB data can I sync to Google Sheets?

You can sync transaction history (date, description, amount, balance, category), account balances, and account details from your NAB transaction accounts, savings accounts, and credit cards. Investment and loan account data is also supported.

Is my NAB data safe with BankSync?

Yes. BankSync uses read-only CDR access; your NAB login credentials are never stored by BankSync. Access is granted through NAB's official CDR authorisation portal and can be revoked at any time through your NAB app.

Can I sync multiple NAB accounts to Google Sheets?

Yes. You can connect multiple NAB accounts (transaction, savings, credit card, home loan) and sync them all to the same Google Sheet or to separate sheets. Each account gets its own rows with an account identifier column.

Sync NAB to Google Sheets.