Skip to main content
Google Sheets is the most popular Redbark destination. Transactions are written to a sheet (tab) within a spreadsheet you choose.

​
Setup

1

Connect your Google account

Click Add Destination, select Google Sheets, and sign in with Google. Redbark Sync will request permission to access your spreadsheets.
2

Select a spreadsheet

Choose which Google Sheets spreadsheet to use from the list of spreadsheets in your Google Drive.
3

Select a sheet

Pick the sheet (tab) within the spreadsheet where data will be written. If your spreadsheet only has one sheet, it is selected automatically.

​
Multi-account syncing

When you create a sync with multiple bank accounts, an extra step lets you choose how accounts are laid out in the spreadsheet:
  • All to one tab: all accounts sync to the same sheet tab. Transactions from every account appear together. This is the default.
  • Account per tab: each bank account gets its own tab in the spreadsheet. Tabs are created automatically and named after the bank account.
This step only appears when you select two or more accounts. With a single account, transactions go to the tab you chose during destination setup.

​
How it works

On each sync, Redbark Sync:
  1. Checks for headers: if the first row is empty, column headers are created automatically
  2. Reads existing Transaction IDs: column A is scanned to identify transactions that have already been synced
  3. Appends new rows: only new posted transactions are appended to the bottom of the sheet. Pending transactions are excluded to avoid duplicates when they later post with updated details.

​
Transaction columns

ColumnTypeDescription
A - Transaction IDTextUnique identifier used for deduplication
B - DateDateTransaction date
C - DescriptionTextTransaction description
D - AmountNumberTransaction amount
E - DirectionTextcredit or debit
F - CategoryTextTransaction category (if available)
G - MerchantTextMerchant name (if available)
H - AccountTextBank account name
I - StatusTextposted (only settled transactions are synced)
J - ClassTextpayment, transfer, fee, interest, or other
K - Post DateDateDate the transaction was posted
You can add your own columns to the right of the last data column. They are not affected by syncs.

​
Authentication

Google Sheets uses OAuth 2.0 with refresh tokens. Your access token is refreshed automatically before each sync. If your Google session is revoked, re-authenticate from the destinations page.

​
Tips

  • Multiple accounts: you can sync several bank accounts in one sync. Use “Account per tab” mode to keep them separated, or “All to one tab” to combine them.
  • Formulas are safe: syncs only append rows and never modify existing data. Your formulas, charts, and formatting are preserved.
  • Shared spreadsheets: you can share the spreadsheet with others. Only the Google account used to connect needs to grant access to Redbark Sync.