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
Hourly, daily, or weekly depending on your plan. Google Sheets uses the latest completed sync.
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 can sync supported holdings hourly on eligible plans using the exchange-reported value available at sync time. For a separate ticker-price source, combine BankSync rows with GOOGLEFINANCE.
Track Crypto in Google Sheets
Coinbase, Kraken, Gemini, Binance. Holdings and trades, in your sheet, on a schedule.
14-day free trial • Cancel anytime