Sync CommBank to Google Sheets Automatically
Connect your Commonwealth Bank 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 CommBank via CDR
Sign up for BankSync and authorise your CommBank account through the official CDR consent flow. Your credentials are never shared with BankSync.
CommBankRead-onlyUpRead-onlyNABRead-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 CommBank 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. Woolworths Surry Hills
- Category
- A spending category you can filter, group and chart by. Groceries
- Amount
- Signed, in the account’s currency: money out is negative. -$84.20
- Account
- The account the row came from, so several banks share one table. CommBank Smart Access
- Account #
- The last four digits of the account number. xxxx9036
- Institution
- The bank or card issuer behind the account. CommBank
Your sheet is one stop. Not the whole story.
CommBank to Google Sheets, in short.
- Consent
- Read-only access under the Consumer Data Right (CDR), authorised on CommBank’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
- CommBank → NotionCommBank → ExcelCommBank → Airtable
- Other Australian banks
- Westpac → Google SheetsNAB → Google SheetsANZ → Google SheetsBrowse all AU banks
Questions, answered.
How do I sync CommBank transactions to Google Sheets?
Sign up for BankSync, connect your CommBank account through the secure CDR authorisation flow, select Google Sheets as your destination, and configure your sync schedule. BankSync will automatically import your CommBank transactions daily.
Is CommBank supported by BankSync?
Yes. Commonwealth Bank (CommBank/CBA) is supported via the Australian Consumer Data Right (CDR) framework. BankSync connects through Fiskil, an accredited CDR data recipient (ADRBNK000246), to securely access your CommBank transaction data.
What CommBank data can I sync to Google Sheets?
You can sync transaction history (date, description, amount, balance, category), account balances, and account details from your CommBank transaction accounts, savings accounts, and credit cards. Investment and loan account data is also supported.
Is my CommBank data safe with BankSync?
Yes. BankSync uses read-only CDR access; your CommBank login credentials are never stored by BankSync. Access is granted through CommBank's official CDR authorisation portal and can be revoked at any time through your CommBank app.
Can I sync multiple CommBank accounts to Google Sheets?
Yes. You can connect multiple CommBank 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.
