Import Bank Transactions into Google Sheets Automatically

Yes. BankSync can only read your data; it cannot move money, change settings or passwords, trade, or apply for products. You sign in inside the provider’s own window (Plaid, Fiskil or SnapTrade), so BankSync never sees or stores your bank password.

Pick Hourly, Daily, Weekly or Manual on the feed’s Schedule tab; Free and Starter run weekly, Standard adds daily, and Professional and above unlock hourly. “Sync Now” works on every plan, and rows appear in Google Sheets once the provider has the data.

Transactions, balances, investment trades, holdings, open orders and loan data, plus receipts, invoices and documents, where the accounts and provider support them. One feed carries one data type, so transactions and balances to Google Sheets means two feeds, and investment accounts cannot share a feed with checking or savings.

No. Every record is keyed on the provider’s unique id and skipped if already written, so overlapping ranges, retries and back-to-back syncs are safe. Exceptions: two feeds writing the same account deduplicate separately, edited or deleted rows are not re-detected, and re-running a feed from the beginning can duplicate.

The first run backfills what the bank’s provider returns, and the ceiling is set by the market, not your plan: Australia up to 2 years (Fiskil), United States up to 2 years (MX), United States up to 2 years (Finicity), United States and Canada up to 2 years (Plaid), and United Kingdom up to 60 days (Salt Edge). Individual banks vary, a backfill can reach the rest of that window, and balances, holdings and loans are point-in-time, so their history starts at your first sync.

Disconnect from the Banks tab after removing the bank from any feeds that use it. It is a soft delete with a “Reactivate Bank” option for about 30 days; on permanent removal the provider connection is revoked, and data already written to Google Sheets stays where it is.

Enrichments fill fields as transactions sync: your rules and learned corrections apply first, and the AI Categorizer fills what is still empty. Merchant Cleanup turns “SQ *BLUE BTL COF 0442 OAK” into “Blue Bottle Coffee”. The AI Categorizer is in beta on Professional plans and above.

All plans include a 14-day free trial. A card is collected at signup, but it is not charged during the trial, and you can cancel before it ends.

Yes. Install the BankSync add-on from the Google Workspace Marketplace (Extensions → Add-ons → Get add-ons) and set up transactions and balances feeds without leaving your sheet. Other data types are set up in BankSync.

Connect your Google account once, signing in on Google’s own page, then choose the spreadsheet and tab in each feed’s Destination tab. One connection can power many feeds. You also choose By Row or By Column and which row holds your headers.