• Google Spreadsheets support with Google Scripts and Bunq API

I've been fighting with this all-day, and although I haven't done the import into Google Sheets (through API-Connector), getting a basic understanding through cURL should help. I've documented my experience here: https://together.bunq.com/d/24919-getting-started-with-bunq-api-through-curl-a-step-by-step-tutorial

Using practically the same procedure from the tutorial I wrote I am now able to use the API-Connection Add-On in Google Sheets. Through this I can now get a list of all transactions available in the Sandbox (none, add one manually first 😀 ).

    So how do i find out what i should set for {user_id} and {monetary_account_id}??

      @Auke-Grey-Swan#144542 you need to get your IDs by making API calls:
      - {user_id}: GET /user/
      - {monetary_account_id}: GET /user/{user_id}/monetary-account
      - you'll also need a customer statement ID: GET /user/{user_id}/monetary-account/{monetary_account_id}/customer-statement

      The easiest way to do it is by using our Postman collection: https://github.com/bunq/postman

      Use these requests to get the IDs you need for the request:
      - Get user info
      - List monetary accounts (save the ID of the account you want to read/create a statement for)
      - List customer statements (save the ID of the statement you want to fetch data from)

      You need to create a customer statement first. You can do it in the app or in Postman using Create a customer statement. You'll need to specify the start and end date in the request body. Here's an example:

        21 days later

        @Willem-Orange-Quokka#147915 Looks like the sandbox version is broken. Perhaps the sandbox environment was reset. I’ll see if I can reregister it later this week.

          @wesselt#147921 Aight, reading this line "Anyone with the URL can request transactions" -- does this mean you have access to my account on that level if I grant access to the production one?

            @Willem-Orange-Quokka#147939 Yeah, a developer controls the app, so I can do anything the app can. You can limit accounts when granting access, and oauth cannot be used to transfer money outside your account.

              @Willem-Orange-Quokka#147939 Have you tried bunq2ifttt (https://github.com/woudt/bunq2ifttt)? You can have it add transactions to a Google spreadsheet when they happen. However this does not export in bulk, so maybe it's not for you. Nevertheless I wanted to mention it as an option :)

                @Roeshimi#147980 thanks will check it out

                  @Willem-Orange-Quokka#148173 With some help from @Bastiaan I was able to get the sandbox version up and running again.
                  I've added a privacy policy (https://github.com/wesselt/easylist/blob/master/PRIVACY) that lists what information is stored and what for. The source code is also available, so if you want to be sure, you can run the code on your own server.

                    @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?