Google Sheets setup and field reference

Transactions and balances from 12k+ banks land as new rows in your sheet, hourly, daily or weekly, mapped to the columns you already use.

Sample data: Chase Checking and Amex Gold in an example sync at 6:02am into Transactions 2026.

From bank to Google Sheets in three steps.

  1. 01

    Connect your bank

    Any of 12k+ banks, read-only, through your bank’s own consent screen.

    ChaseRead-only
    American ExpressRead-only
    ConsentBank’s own screen
  2. 02

    Link Google Sheets

    Sign in with Google, pick a spreadsheet and map bank fields to its columns.

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

    Pick a schedule

    Hourly, daily or weekly, or on demand. New transactions arrive as new rows.

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

Google Sheets, set up start to finish.

Setting up Google Sheets in BankSync, filmed with sample accounts.

What lands in your sheet.

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

Data Security & Permissions

How We Use Your Google Sheets™ Data

BankSync requires access to your Google Sheets™ to automatically sync your banking data. Here's exactly what we do:

Write banking data
Insert transaction records, balance updates, and financial summaries into your spreadsheets
Read sheet structure
Understand your existing data format to maintain consistency
Update existing data
Modify and refresh financial information as new transactions occur

Required Permissions

BankSync requires the following permissions to function properly:

Google Sheets Access
To read and write your financial data in the spreadsheets you specify for syncing.
User Email Access
To identify your account and ensure data is synced to the correct user's spreadsheets.
External Requests
To securely connect to banking APIs and retrieve your financial data for synchronization.

Data Security

Your data security and privacy are our top priorities:

No data storage
We don't store your banking credentials or sensitive financial data
Encrypted transmission
All data is encrypted in transit using industry-standard protocols
Read-only access
We only access the specific sheets you authorize for syncing
Secure banking connections
Bank connections use OAuth and are managed by trusted financial data providers

The same data can also go to spreadsheets, workspaces, AI assistants and your own code.

Google Sheets, in short.

Data
Transaction date, Amount, Merchant name, Category, Account name, Account balance, Transaction type, Notes, Currency, and Pending status, chosen per feed.
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, Austria, Belgium, Bulgaria, Cyprus, Czechia, Germany, Denmark, Estonia, Spain, Finland, France, Greece, Croatia, Hungary, Ireland, Iceland, Italy, Liechtenstein, Lithuania, Luxembourg, Latvia, Malta, Netherlands, Norway, Poland, Portugal, Romania, Sweden, Slovenia, and Slovakia up to 60 days.
Access
Read-only, authorised on your bank’s own consent screen. BankSync never stores your bank login and cannot move money.
Setup
About 5 minutes. Works with Google Workspace and personal Google accounts.
Status
Available today.
Choosing a tool?
See how BankSync syncs bank transactions to Google Sheets, what it costs, and how it compares.

Questions, answered.

How does the BankSync Google Sheets integration work?

Connect your bank read-only, connect Google Sheets and pick where rows go, then map bank fields to your columns. Each scheduled run adds new transactions as new rows.

Which fields can BankSync sync to Google Sheets?

Transaction date, Amount, Merchant name, Category, Account name, Account balance, Transaction type, Notes, Currency, and Pending status. You choose which ones to map, and to which column.

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.

Will a re-sync create duplicate rows in Google Sheets?

No. Every transaction is keyed by its bank transaction id, so a re-sync updates or skips it instead of writing it twice.

Can BankSync move money or see my bank password?

No. Access is read-only and authorised on your bank’s own consent screen. BankSync never stores your bank login and cannot move money.

Bank data in Google Sheets.

BankSync is not affiliated with, endorsed by, or an official partner of Google Sheets. Google Sheets trademarks belong to their respective owners.