IFTTT + Google Sheets + Monzo = Then what?

Monzo Chat
30

Ok. Who knows whether this will actually work… but I’ve mutilated my spreadsheets to try to craft a version that will work for others. Its based off a few assumptions though (since its based on my circumstances);

  • That you have both a personal and a joint account.
  • That you mostly use the joint account for spending and saving.
  • That you work on the assumption that you own HALF of the joint account balance.
  • That you use the CSVs from monzo (either via auto updates with monzo plus or copy pasted into this template).
  • That you care about monthly comparisons of balances (rather than 4 weekly, or whatever).

So, here is the link. First thing you’ll need to do is go to ‘File’ then ‘Make a copy’;
image

When you open it, you should see 4 sheets.
image

  • For the Raw Personal you can edit the URL in the formula found in the yellow box; so that it points at your monzo transactions google sheet (alternatively follow step below for both personal and joint).
  • For the Raw Joint you will need to export data from within the app (I typically email it to myself then open in gmail, then copy paste into this section). Include the headings.
  • The Money Dashboard should then populate with charts showing balance over time etc. These charts are pulling their figures from one of the six hidden sheets that contain pivot tables. These pivot tables mostly look at the Helper Sheet and arrange the information in an order that makes sense for creating charts. You will likely need to adjust some things to make it look right. I had balance data going back 10 years so if you only have a couple months data I have no idea if it will work properly.
  • The Helper Sheet creates a tidy list of balances against dates. The overall balance listed here is the sum of the main account and main pots, plus half of the joint account/pots. This sheet also contains a bunch of additional columns like ‘Year’, ‘Month’ etc that are used in the pivot tables on the hidden sheets.

Troubleshooting;
If the charts look weird or empty, first place to look should be the ‘Helper Sheet’.

  • Check that the balances are populated properly.
  • Try removing the rows up until the date of you got your monzo account
  • If a particular chart looks broken, you can investigate by finding the hidden sheet that it references and checking that the table makes sense.
  • Try checking the pivot tables on the hidden sheets for any ‘filters’ that shouldn’t be there or are incorrect. e.g. “That’s weird its only showing data for 2019, oh its because the pivot table is filtered to only show 2019 for some reason”
  • You will likely need to adjust the formatting on the charts as this might break if you have more or less data that I had in it.
  • Feel free to message me on here, but keep in mind that its notoriously difficult to troubleshoot other people’s spreadsheet woes :slight_smile:

If you’re interested in this kind of stuff, I highly recommend you try to build your own dashboards from scratch rather than relying on this. The process of building the formulas yourself means that if something goes wrong you know how to fix it. I’ve been iterating on these spreadsheets for years and years, starting from basically nothing and no experience.

Let me know how you get on!

7 Likes