How to Sync Brazilian Bank Transactions to Google Sheets
Google Sheets is one of the most versatile tools for personal finance. You can build custom dashboards, run complex formulas, create pivot tables, and share your data with a financial advisor, all without paying for expensive software. The only missing piece for Brazilian users has historically been getting real bank transaction data into the spreadsheet without manual work. Manio solves that.
Why Google Sheets for Personal Finance?
Unlike dedicated budgeting apps, Google Sheets gives you complete control over your data. You decide which columns exist, how transactions are categorised, and what formulas run on top of the data. Many Brazilian finance enthusiasts prefer this flexibility over the rigid structure of apps like YNAB or Notion databases.
Sheets also integrates naturally with the rest of Google Workspace. You can pull in data from Google Forms (for cash expenses), connect to Google Data Studio for charts, or share a read-only version with a spouse or accountant.
How Manio Connects Brazilian Banks to Google Sheets
Manio uses the Open Finance Brasil API to read transactions from your bank accounts, then writes them directly to a Google Spreadsheet you specify. The Google Sheets integration works through Google's OAuth system. You grant Manio permission to write to a specific spreadsheet, and it adds new transactions automatically.
What Gets Written to Your Sheet
Each transaction row includes the following columns by default:
- Date: Transaction settlement date in DD/MM/YYYY format
- Description: Merchant or counterparty name, cleaned by Manio
- Amount: Transaction value in BRL (positive for income, negative for expenses)
- Type: Pix, TED, boleto, compra, etc.
- Account: Which bank account the transaction came from
- Transaction ID: Unique identifier for deduplication
Step-by-Step Setup
Step 1: Create Your Spreadsheet
Open Google Sheets and create a new spreadsheet. You can use our template (available after signing up) or start with a blank sheet. If using a blank sheet, we recommend adding headers in row 1: Date, Description, Amount, Type, Account, Transaction ID.
Step 2: Connect Your Bank
In Manio, go to "Bank Connections" and add your bank. Manio redirects you to your bank's Open Finance consent screen. You authorise with your bank credentials directly, never sharing them with Manio. Choose which accounts to share.
Step 3: Connect Google Sheets
Go to "Destinations" and select Google Sheets. Authorise Manio to access your Google account. You will be prompted to select or create the specific spreadsheet where transactions should be written.
Step 4: Create Account Links
Map each bank account to a sheet in your Google Spreadsheet. You can send all accounts to one sheet (the Account column differentiates them) or create separate sheets for each account.
Step 5: First Sync
Trigger your first sync from the Manio dashboard. Manio will import up to 90 days of transaction history immediately, then continue syncing automatically on schedule.
Building Useful Formulas on Top of Synced Data
Once your transaction data is flowing in automatically, you can build powerful analyses. Some popular approaches:
Monthly Spending by Category
Add a "Category" column next to the Description column and manually categorise a few transactions. Then use a SUMIF formula to sum spending per category per month. Over time, you can use VLOOKUP or XLOOKUP tables to auto-categorise known merchants.
Cash Flow Dashboard
Create a summary tab that uses SUMIFS to show total income vs. expenses per month. Add a sparkline chart to visualise trends. Connect it to a Google Data Studio dashboard for better visuals.
Budget vs. Actual
Add a "Budget" column next to each month's actual spend and use conditional formatting to highlight when you go over budget in red.
Which Brazilian Banks Work with This Integration?
Manio supports all banks participating in Open Finance Brasil, which includes every major Brazilian bank: Nubank, Itaú, Bradesco, Santander, Banco do Brasil, Caixa, Inter, C6 Bank, BTG Pactual, Sicoob, Sicredi, and dozens more. If your bank is in Open Finance Brasil, it works with Manio.
Keeping Data Fresh
Manio syncs on a schedule. The Trial plan runs daily (50 syncs included), while the Pro plan syncs every 8 hours with unlimited syncs. Transactions appear in your spreadsheet without you doing anything. The Transaction ID column ensures no row is ever written twice, even if a transaction is returned by the bank API multiple times.
For bank-specific Sheets guides, see how to sync Nubank, Itau, Bradesco, and Inter to Google Sheets. If you are considering YNAB instead, see how to sync Nubank, Itau, Bradesco, and Inter to YNAB. Want to understand how Open Finance protects your data? Read our guide on Open Finance security.