

It uses Nordigen's free open banking data API. This tool was built as a hobby project by Roberts Bernans, Chief Product Officer and cofounder of Nordigen.
#Google sheets login code#
It's totally free and the source code for the script is available on Github. Create a Google Sheets script to import a SQL table (here with MySQL). This is why we decided to build a no-code tool to help you connect your European bank account to Google Sheets.

But let's be honest - not a lot of apps can beat the versatility of a spreadsheet. Customize the permission level to Viewer and uncheck the option to notify if preferred, then click Share or Send.There is no shortage of amazing personal finance apps that allow you to connect your bank account and keep track of your finances. Click the Share button in the top right corner.Įnter the Service account email address which you recorded previously (e.g., in Notepad), or it may be automatically suggested if you've already used it. Open a spreadsheet that you want to connect to from Dundas BI. If you used a Gmail account to create your spreadsheets, first sign into Google Sheets. There are a couple of ways to proceed depending on the type of account used to create the spreadsheets. Now that the credentials have been generated, they must also be authorized to access the spreadsheet data. Copy and paste this with the service account's e-mail address for later use. As in the title, it uses Googles Sheets API.
#Google sheets login password#
If you require the P12 file type instead of the default JSON, you will require some additional information.Ī popup will appear displaying the password for the private key. I made a login system that stores entered usernames and passwords and can use those to login and do something. This file will be needed later to set up a data connector in Dundas BI. Turn on Applets to monitor specific cells in your spreadsheets as well create news docs, rows, and cell updates. When finished, a certificate file should be downloaded. For example, click to edit the new service account, go to the Keys tab if applicable, and click Add Key.
