• Auto update Balances > Google sheet

All bunq fans, think with me!

Looked all over together, but can’t find any way to auto update my google sheet with current bunq bank account balances.

Trying to make an always up to date cashflow overview in Google sheets or Airtable

  1. Is there any existing solution out there?
  2. If yes, can I run it in the cloud?
  3. Anyone made an app that can fire webhooks based on events on a bunq account? (In that way I can connect it to Zapier)
  4. Can’t believe bunq doesn’t work on a IFTTT/Zapier integration!! This would make it possible to automate without code. For our tech savvy non developers/business consultants out there

Looking forward to help anyone out trying to build this.

    @guidokok#61629 You mean the bunq-API?

    Most API's can be scripted in a macro in VBA... Generally a SOAP-request can be done and cells can be updated from the xml that you get back.

      @Samzoiets#61632 Yes Sam, with the bunq API. But don’t want to spent time writing a script, I want to use the API with Some sort of IFTTT / zapier interface.

        @guidokok#61742 This can be done with the bunq api, but it’s complicated, with private keys used in a custom encryption scheme.

        An odata endpoint with plain username/password would be a much better match for most users. That can be consumed from Google sheets or Excel.

        I’m not sure why bunq hasn’t made something like that. Perhaps they’re uncomfortable with username/password, or perhaps there’s not enough interest in a usable api.

          @guidokok#61742 Hi Guido, that's why bunq has an API. bunq can't write code for every service people are using. That work is up to the services like IFTTT, Zapier,...
          Or like @Sam said, you can do it yourself or let someone write the code for you.

          If I sounded rude, that's not what I wanted to do - in that case please attribute it to my english.
          I just wanted to explain, that it would be too much work for bunq to support every service in existence - that's what APIs are for. bunq can't spend time to do it for the explained reasons.
          I think a feature request for your problem would be better addressed to IFTTT or Zapier, because it's their business model to provide such services.

          @Wessel I'm not sure I would give my bunq username/password to google or someone else. I'm feeling more comfortable with OAuth and it's access restrictions and it's way to protect my credentials.

            @kameit00#61817 Same way can be said regarding the TransferWise integration they made. Some core services should be made by bunq themselves.

            For example ifttt and zapier are marketleaders, so it wouldn’t be weird bunq would make only integrations with them.
            Furthermore users are not be able to create an app on behalf of bunq.

            Authentication can be fully done with Oauth, so I don’t see any security/privacy concerns.

            If bunq would make this integration, consumers and non coders would be finally able to use the api. IMO it’s a missed chance that they left out this group by not using integration as a service providers.

              @wesselt#61759 They have an API first mentality, so it surprises me a lot

                Transferwise is a huge benefit for all customers. A feature of bunq now. A fitting feature for a bank.

                  @guidokok#61866 API first has nothing to do with implementing other services though. And it's up to other developers or services to integrate bunq, not the other way around imo

                    @Gregory#61997 API HAS something to do with this, as zapier and ifttt is basically a wysiwig API editor. Just as an API management tool is part of an API. It just opens the API to more services easily.

                    And therefore shouldnt be seen as a service, but as an extension of the existing bunq api.

                    Developers can’t make integrations with IAAS providers like zapier as they don’t allow it. Only the company (bunq) itself.

                      @guidokok#62116 I don’t think Gregory is saying that customers should be making this connection between bunq <-> Zapier/IFTTT, but rather those companies should implement the bunq API. I think indeed that the TransferWise integration serves a purpose for many many people, whereas an API integration seems to benefit less people (mostly the more techies among us).

                      A plain username/password API protection is not really the most secure thing imo. I can very well imagine that bunq does not offer this. But, since they offer the API, nobody is blocking someone from writing some kind of proxy server that does this for you. But then at least not all customers have a plain username/password access to their accounts. 😁

                        @Sander#62122 Agree with you. But customers don’t realise you don’t have to be a techy to benefit ifttt. With ready Made recipies 😀. Somehow the business case is not interesting enough.

                          Regarding security: oath can do the job or the proxy server you mentioned can be a good one as well!

                            Write a Reply...