Connect your bank account to Google Sheets

2 min

...

There is no shortage of amazing personal finance apps that allow you to connect your bank account and keep track of your finances. But let's be honest - not a lot of apps can beat the versatility of a spreadsheet. This is why we decided to build a no-code tool to help you connect your European bank account to Google Sheets. It's totally free and the source code for the script is available on  Github

The tool works with personal and business bank accounts, including popular neobanks like Revolut, N26, Starling and Wise (ex Transferwise).

 

How to get started

To connect your bank account to Google Sheets, you will need to follow these three steps:

  • Step 1 - Create an account on Nordigen.com Go to Nordigens's  Open Banking Portal and get your own unique token to use Nordigen's service for connecting your bank account.
  • Step 2 - Copy the Google Sheets template
    We have created a Google Sheets template that you can copy. Once you have copied the template, you will be able to make edits to the file.  Here is the link to the Google Sheets template file.
  • Step 3 - Follow instructions on the Google Sheets file
    Once you have a Nordigen account, you should be able to copy/paste your Nordigen token in the Google Sheets file. 

 

🎉 Voilà - your bank account is now connected to your Google Sheets file.

 

What you can do

Once you have connected your bank account to Google Sheets, you can:

  • see your transactions in one place and make calculations using formulas,
  • build custom spending categories to track your spending,
  • track your budget changes over time and forecast your spending,
  • (if you connect your business account) calculate your cashflow and runway,
  • do anything you can dream of. 

 

Behind the project

This tool was built as a hobby project by Roberts Bernans, Chief Product Officer and cofounder of Nordigen. It uses Nordigen's free open banking data API.

Share
share on facebook share on linked

Article by

...Team Nordigen
Recommended articles
API docs

This document explains how to integrate with Nordigen API to connect to your users’ bank account and access account information from bank PSD2 APIs.

API docs
Contact sales
Join our Newsletter

We frequently share industry news and Nordigen product updates to our closest friends, fintech innovators and industry experts. Sign up to our newsletter to hear more from us.

By providing your email, you accept
Nordigen's Privacy Policy.