Link account balance to google sheet


#1

Hi there,

I’m trying to integrate our total account balances of our various accounts with google sheets, to have a real-time view on how much money we’re having in the banks. Does this exist, and can you help me implementing it?

Many thanks!


#2

Hi there,

FreeAgent doesn’t directly integrate with Google Sheets, though our API does have an end-point that’ll allow you to query the figures from your Trial Balance, if this would be helpful to you? It is theoretically possible to make API requests using the scripting language in Google Sheets, though this would be quite an involved process.

Can I ask what you’re trying to achieve? Did you know that you can view the current balance in each account in FreeAgent via Accounting > Reports > Show Transactions?

Kind regards,
Dave J