I would like to write a Google Apps Script that can pull transaction data from my bank and add it to a google spreadsheet. I thought Plaid might be a good option, but I am unable to figure out how I would use the Plaid API within google apps script. Plaid supports Node.js while Google Apps Script uses a JavaScript cloud scripting language.
Google Apps Script does allow you to use external APIs but I believe Plaid makes you add a bank through Link.
Does anyone have any idea of a better way to do this?
Thanks!
co-founder of bkper.com here.
We use Plaid to offer direct bank connections to users, offering a Google Apps Script library to easily allow access to data, under a secure OAuth2 layer.
You can use it to access your data without the need to worry about implement Link connections and tokens management :-)