Sync Crypto to 
Google Sheets
Coinbase, Kraken, Gemini, Binance and more. Holdings, trades and balances flow into a Google Sheet that updates itself.
Read-only API keys. We never request withdrawal access.
Watch Your Crypto Sync
Exchange data flows into your sheet on every run.
What Lands in Your Sheet
Holdings tab
Asset, units, average cost, current price, market value and unrealized gain. One row per asset per exchange.
Trades tab
Timestamp, asset, side (buy or sell), units, price, fees and proceeds. Backfilled on first sync.
Income tab
Staking rewards and interest with timestamp, asset and amount. Group by month or asset for tax reporting.
Multi-exchange roll-up
Connect every wallet you have. One sheet shows your total crypto position across exchanges.
How It Works
Connect exchanges
Sign in to Coinbase, Kraken, Gemini or Binance through OAuth or a read-only API key.
Pick a sheet
Use the BankSync portfolio template or write into your own spreadsheet.
Schedule it
Every 15 minutes, hourly, daily. Open your sheet, the data is already there.
Frequently Asked Questions
How do I sync Coinbase to Google Sheets?
Sign up for BankSync, connect Coinbase through OAuth or a read-only API key, pick Google Sheets as the destination and choose a schedule. Holdings, trades and balances sync into your spreadsheet automatically.
Which crypto exchanges work with this?
Coinbase, Coinbase Advanced, Kraken, Gemini, Binance, Binance.US, Crypto.com, KuCoin, Bitstamp and Bitfinex. Holdings, trades and balances sync from each into the same Google Sheets schema.
Can I track tax-relevant trade history?
Yes. BankSync syncs every trade with timestamp, asset, units, price, fees and proceeds, ready to drop into a capital-gains template or pass to a tool like CoinTracker or Koinly.
Does BankSync request withdrawal access to my exchange?
No. BankSync only requests read-only scopes. Where the exchange supports IP allow-listing, we provide a static IP range so your API key is locked to our infrastructure.
How fresh is the price data?
BankSync syncs holdings as often as every 15 minutes using the exchange-reported price at the time of sync. For live ticker prices, combine BankSync rows with the GOOGLEFINANCE function in your sheet.
Track Crypto in Google Sheets
Coinbase, Kraken, Gemini, Binance. Holdings and trades, in your sheet, on a schedule.
Start Free Trial14-day free trial • Cancel anytime