How to Sync Your Bank Transactions to Google Sheets Automatically

If you've ever spent 20 minutes downloading CSV files from your bank portal, reformatting columns, and pasting them into a spreadsheet — this guide is for you.

SheetLink connects your bank accounts to Google Sheets via Plaid and lets you sync transactions with one click. No CSV exports. No manual formatting. No recurring subscription required to get started.

Here's exactly how to set it up.

What You'll Need

• A Google account
• A Google Sheet (existing or new)
• A bank account supported by Plaid (10,000+ institutions — most US banks)
• The SheetLink Chrome extension (free)

Step 1: Install the SheetLink Chrome Extension

1. Go to the Chrome Web Store

   Search for "SheetLink" or use this direct link. Click Add to Chrome.

2. Pin the extension

   Click the puzzle piece icon in your Chrome toolbar and pin SheetLink so it's always one click away.

3. Sign in with Google

   Click the SheetLink icon and sign in with your Google account. This connects SheetLink to your Google Sheets.

Step 2: Connect Your Bank

1. Open the Bank tab

   In the SheetLink popup, click the Bank tab at the bottom.

2. Click Connect Bank

   This opens Plaid Link — a secure modal handled entirely by Plaid. SheetLink never sees your bank credentials.

3. Search for your bank

   Type your bank name (e.g. "Chase"), log in, and select the accounts you want to share. Plaid returns an encrypted token to SheetLink — not your password.

4. Confirm your connection

   Your bank name and connected accounts will appear in the Bank tab.

Step 3: Link Your Google Sheet

1. Open the Sheet tab

   Click the Sheet tab in the SheetLink popup.

2. Paste your Google Sheet URL

   Open the Google Sheet you want to use (or create a new one), copy the URL, and paste it into SheetLink.

3. Confirm the link

   SheetLink will verify it has write access to the sheet.

Step 4: Run Your First Sync

Go to the Home tab and click Sync Now.

SheetLink will:

1. Fetch transactions from your connected bank(s) via Plaid
2. Write them to a Transactions sheet with all Plaid transaction fields — date, description_raw, merchant_name, amount, category_primary, account_name, and more
3. Write account balances and metadata to an Accounts sheet

The whole process takes 5–15 seconds depending on transaction volume.

What the Output Looks Like

Your Transactions sheet will have clean, structured data that's ready for pivot tables, SUMIF formulas, charts, or anything else you want to build:

Next Steps

Now that your transactions are flowing into Google Sheets, here's what people typically build:

• Monthly budget — SUMIF by category, compare to targets
• P&L for freelancers — separate income from expenses by account
• Spending trends — pivot table by merchant over time
• Tax prep sheet — filter deductible business expenses