Sync ANZ to Google Sheets Automatically
Connect your ANZ accounts via CDR and automatically push transactions, balances, and more into Google Sheets every day.
Set it up once. Then forget about it.
- 01
Connect ANZ via CDR
Sign up for BankSync and authorise your ANZ account through the official CDR consent flow. Your credentials are never shared with BankSync.
ANZRead-onlyCommBankRead-onlyUpRead-onlyConsentCDR - 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 · DateMerchantB · DescriptionCategoryC · CategoryAmountD · AmountAccountE · Account - 03
Transactions sync automatically
BankSync syncs your ANZ transactions to Google Sheets daily. New rows are appended automatically; no action required from you.
HourlyDailyWeeklyNext runTomorrow, 6:00amLast 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. Coles Fitzroy
- Category
- A spending category you can filter, group and chart by. Groceries
- Amount
- Signed, in the account’s currency: money out is negative. -$92.65
- Account
- The account the row came from, so several banks share one table. ANZ Access Advantage
- Account #
- The last four digits of the account number. xxxx2023
- Institution
- The bank or card issuer behind the account. ANZ
Your sheet is one stop. Not the whole story.
ANZ to Google Sheets, in short.
- Consent
- Read-only access under the Consumer Data Right (CDR), authorised on ANZ’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.
- Other destinations
- ANZ → NotionANZ → ExcelANZ → Airtable
- Other Australian banks
- CommBank → Google SheetsWestpac → Google SheetsNAB → Google SheetsBrowse all AU banks
Questions, answered.
How do I sync ANZ transactions to Google Sheets?
Sign up for BankSync, connect your ANZ account through the secure CDR authorisation flow, select Google Sheets as your destination, and configure your sync schedule. BankSync will automatically import your ANZ transactions daily.
Is ANZ supported by BankSync?
Yes. ANZ is supported via the Australian Consumer Data Right (CDR) framework. BankSync connects through Fiskil, an accredited CDR data recipient (ADRBNK000246), to securely access your ANZ transaction data.
What ANZ data can I sync to Google Sheets?
You can sync transaction history (date, description, amount, balance, category), account balances, and account details from your ANZ transaction accounts, savings accounts, and credit cards. Investment and loan account data is also supported.
Is my ANZ data safe with BankSync?
Yes. BankSync uses read-only CDR access; your ANZ login credentials are never stored by BankSync. Access is granted through ANZ's official CDR authorisation portal and can be revoked at any time through your ANZ app.
Can I sync multiple ANZ accounts to Google Sheets?
Yes. You can connect multiple ANZ 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.
