Hi there,
I thought I would start a new thread since the latest posts I could find about Google Sheets are from years ago. Now that Google is integrating AI into its workspace and has also launched App Sheets I feel like it could be a nice way forward to complement the Bunq App with more customizable expense tracking, budget predictions and autopay.

I've been using Google Sheets for our home expenses since 2015 but have only in the past years started using the Bunq API to export our expenses into the sheet. Personal admins are always kind of particular to the user unless they have to show them to a real accountant. So I cleaned up the way it is formatted and now it should work more generally for other people as well.

I just opened the repo here: https://github.com/newstate/bunq_monthlybills

There is still some development that could be done about the next month's payment predictions and also implementing an autopay that takes its values from the sheet. My idea is also to get an email via the Gmail API on every first of the month with an overview of the expenses and expected next month's payments.

I specifically did not use another API to do data processing (like a python server with pandas or databricks with spark), so there is some gymnastics in Javascript. I have also not looked beyond simple requests to the BUNQ API. Possibly, people without bunq could export and import their monthly bank statements that way in the future.

I would be interested to know if this is useful for any of you, maybe with some modifications, or if any of you would like to contribute and help bring the project further. I hope to learn to make it better and save us all accounting time. :)