• Google Spreadsheets support with Google Scripts and Bunq API

@wesselt#148380 Nice thanks!

    @wesselt#148380 Hey Wessel, QR scanned niet

      @wesselt#148650 Got it, was scanning the wrong one!

        a month later

        @lexy-Blue-Panda#143827 Hi Lexy, I am trying to connect Google sheets to my Bunq account to get the balance of one of my monetary accounts but I get error 403. I suspect it's because Google sheets isn't allowed to connect but, I am uncertain how to give google sheet the permission it needs. Using Postman I can see all my account information and I've created a new API Key specifically for Google sheets. But no clue how to give the other permissions.

          2 months later

          @wesselt#148380 Would like to run this with my own account and locally on my NAS (for security purposes). Can you explain a bit more in detail how to do this. Already got it running however all settings and config need to be adjusted:
          trying to understand the settings.py and Postgresql settings (first need to get this db running on my NAS)

          Thanks

            @Maartenvt#165786 Hi Maarten, the code gets the Postgres connection string from get_connection_string(). This should return a string like:

            def get_connection_string():
    return "host='127.0.0.1' dbname='easylist' user='goofy' password='topsecret'"

            I'll add a comment to github. Good luck and let me know if you have other questions!

              @wesselt#165788 Thanks for the reply. Seems like Postgresql is not the best solution for me as I'm running everything on a synology NAS (low support). Tried to move to MySQL, however without any luck. Would love to have a more simple solution like using the Google Apps Script functionality to load / sync data into my sheets (as shown during the demo of Bunq). You have any examples how to setup this connection in Google Apps Script?

                2 months later

                @wesselt#165788 Hey Wessel, ik heb nog een issue in je code gevonden en een issue aangemaakt in GitHub (https://github.com/wesselt/easylist/issues). Komt erop neer dat Google Sheets een \n ziet als een enter, waardoor de sheet niet goed uitkomt. Veel transacties (grofweg 50%) bevatten zo'n "\n". Denk dat het relatief eenvoudig op te lossen is door overal "\n" weg te filteren. Zou je daar naar willen kijken? Gaat trouwens om de csv-variant.

                Verder zou het nog helpen om een uitleg te geven hoe je dit correct deployed.

                  2 months later

                  Hey Wessel, when I would use your solution, would it also be possible to see the insights category of each transaction? I would like to use it to get more insight in personnel expenses, but I don't want to classify every transaction manually.

                    Write a Reply...