• Developers Ideas

  • BUNQ & Google Data Studio | Your own financial Dashboard?

It would be cool if you could import data from your BunQ accounts and visualise it into the Google Datastudio. So for example you could make your own visual good looking financial dashboard!

Did somebody already do this? I am not sure if it is possible but it would be cool. Maybe it can be managed by using the BUNQ API?

I have attached a example dashboard which is build with datastudio, so you'll get an idea what you can do with it.

    Hey @Marck-Teal-Penguin#32116 👋
    thank you very much for sharing this tool with us! 👍 I played around with it a little bit, and I think I have found my new favorite toy for the next weeks! 😉 I just imported a CSV export from bunq and adjusted the transaction amount format a little bit to get it working.

    Here is the RegEx I used for formatting the amounts:
    Search: /"(.*)","(-?[0-9]*)(?:.?)([0-9]*),([0-9]*)",/g
    Replace: "$1","$2$3.$4",

    I will for sure play around with this a little more, and lets see what other bunqers might create with it! 💡

      @JanBrodda#32217 Thanks for sharing the RegEx and good luck! I also could try making a first dashboard based on a .CSV export. Do you manage exporting the CSV files with several accounts within BunQ? Or do you have just one account?

      Even better would be a live connection with BunQ. Maybe that is possible with the BUNQ API?

      Thinking out loud; Maybe it is possible to export the BunQ data in realtime into Google Sheets, and within Google Data studio use that sheets as a datasource.

        @Marck-Teal-Penguin#32260 There is a possibility for everyone to create so-called "Community Connectors" for Google Data Studio. Those connectors would allow any user to provide an API key and query the bunq API. But I didn't have time to check it out in detail until now..

        See the following resources for details:
        https://developers.google.com/datastudio/connector/
        https://github.com/googledatastudio/community-connectors
        https://script.google.com/home

        Regarding your question about multiple bunq accounts as data source:
        You can create a single data set "bunq accounts" and import multiple files in Data Studio. So while you can only export one account at a time via bunq, you can import them into the same single data set in Data Studio.

          @Marck-Teal-Penguin#32116 @JanBrodda ,
          Hey 🙌,
          Just a very simple question why should someone use a service from google and upload his financial history too it? It hink using tools like https://bunqdesk.top is much better privacy vise and also get the job of visualizing your spendings done.

          Best wishes,
          Timo

            @TimoNowitzki#32274 I agree with you, local data processing has an advantage privacy-wise. But I really don’t mind feeding my data to Google, as I already trust them with all of my other data. And their service allows me to create custom analytics and play around with it, this is currently not possible in bunqDesktop as well.

            But it will be an individual decision if you would like to trust providers like Google, or do the whole data processing on your own..

              a month later

              @janbrodda Hi there, Just curious how far you have succeeded with the dashboard. I still have tot start mine. Maybe you could share Something!

                a month later
                9 days later

                Ik schrijf elke nacht m'n transacties weg en gebruik Power BI om dat te visualiseren! Ziet er vergelijkbaar uit!

                  @Marck-Teal-Penguin#35782 Om hier nog even reactie op te geven, de bunq API heeft bepaalde technieken nodig die hoogstwaarschijnlijk niet supported zijn door Google of andere standaard integraties. Dus als je een echte link wil neerzetten via de bunq API om alles up-to-date te houden dan moet er toch echt iets gebouwd worden denk ik

                    a month later

                    @Gregory#40721 Wat bedoel je met bepaalde technieken die hoogstwaarschijnlijk niet supported worden door Google? Je hebt volgens mij alleen een database nodig van gegevens uit je BUNQ rekening. Rekeningnummer, bij/af, omschrijving, datum, van/naar. Het lijkt mij dat je die gegevens met een API uit Bunq zou moeten kunnen halen. En Datastudio kan je prima inrichten dat het die data prima kan weergeven lijkt mij. Als het niet direct kan, zou je de data via een Google Sheets ofzo laten lopen, die je als bron dan weer in Datastudio kan gebruiken als input voor je Financial Dashboard. Mogelijk mis ik iets :) Ik ben aan het onderzoeken of het zou kunnen dus ik ben benieuwd!

                      @Marck-Teal-Penguin#47183 Je zegt daar dus mee dat er toch echt iets gebouwd moet worden :P

                      De post ging erover om direct met de API te integreren wat niet kan vanwege de uitgebreide installation/device/session setup die je nodig hebt voor de bunq API. Als je zelf een integratie neerzet en de data naar een database schrijft dan moet dat gewoon kunnen natuurlijk :)

                        5 years later

                        Is there any API information available for connecting bunq to powerbi?

                          Write a Reply...