Edit existing Google App Script that queries an API to pull balance data instead of the transactions data (Full API doc is provided)
Budget: £20 – £250 GBP
In the pastebin is code for Google App Script. When you press on the button in the Google Sheets document it loads the getTransactions function which populates transactions from my bank account into a sheet called Transactions.
Instead of appending the Date, Text, Amount, Category I want it to output the Available Balance Closing Amount instead.
Here is info on the API: https://developer.gocardless.com/bank-account-data/overview
I know it uses the /balances/ endpoint instead of /transactions/.
Basically, I need the Google Apps Script code to be edited to pull the balance from the API instead of the transactions.
Once this is done I will then duplicate it and make it work with my other bank account also. I then plan to import these into my existing finances spreadsheet. The end goal is to then Click a button in my Finances sheet to run the script for both of these spreadsheets that will then append the bank balances that I will reference elsewhere in the Finances Google Sheet.
https://pastebin.com/raw/9XfuYKfs
Instead of appending the Date, Text, Amount, Category I want it to output the Available Balance Closing Amount instead.
Here is info on the API: https://developer.gocardless.com/bank-account-data/overview
I know it uses the /balances/ endpoint instead of /transactions/.
Basically, I need the Google Apps Script code to be edited to pull the balance from the API instead of the transactions.
Once this is done I will then duplicate it and make it work with my other bank account also. I then plan to import these into my existing finances spreadsheet. The end goal is to then Click a button in my Finances sheet to run the script for both of these spreadsheets that will then append the bank balances that I will reference elsewhere in the Finances Google Sheet.
https://pastebin.com/raw/9XfuYKfs