IFTTT + Google Sheets + Monzo = Then what?

Looking at mine, it looks quite good when it looks like three weeks ago/six weeks ago were £0 on lunches, and probably only a meal deal in weeks four/five.

Until you realise those are the only days I’ve been in the office! :smiley: Any day at zero is because I’ve been at home. I used to be so much better about prepping for the week but now I go in probably once a week, it feels easier to buy something. Must. Stop!

1 Like

This what I want this sheet to kick me into doing.

I’ve also been skipping breakfast so by lunchtime I’m starving so I buy half of Tesco!


If you’re really keen you can map time and value of your lunches and track weekly work lunch expenses;

1 Like

There isn’t much correlation between later and a higher spend over a traditional lunch time. But if you go early, you’re a cheap date! Is that just a breakfast snack?

It was typically lunch for two, but if I was grabbing lunch earlier then it was probably just for myself. The other weird times are at airports or in different timezones.

There are two main pink clusters of around £14 at 12:15 and at 13:15. Subway was a 15 minute walk from work back in pre-pandemic days.

Thankfully we’re both now working from home most of week, but that lunch expense was just added to our grocery spend;

The spike last month was going to a fancy restaurant as a treat and blowing nearly all of our monthly food budget haha.

Limiting it to the last couple of months was bad enough, never mind if I saw all time. That’s a really cool and useful graph though!

I kind of messed it up a bit though and it I had to manually go back through loads of transactions.

The Tesco near work where I get lunch and the Tesco near home where I get petrol all got categorised the same. I made the mistake of selecting ‘all past and future’ transactions when categorising so everything went to ‘eating out’ :grimacing:

Ouch! Pre-pandemic I was in the habit of tagging lunch transactions with #lunch while eating my sandwich which made it relatively straight forward to identify lunch spends. I’ve not been doing it so much anymore so its not as useful, unless I go back through all my transactions and tag the lunches.

Another way that you could approach the same problem would be to just sum all transactions that occur during your typical lunch break by filtering the time column.

1 Like

To fix, you could search for Tesco <£x and that would at least show you the ones you need to change.

1 Like

That’s only on iOS, us poor Android people don’t have advanced search :frowning:

1 Like

Just want to revive this topic, partially because its one of the last remaining open google sheets thread, but also to re-raise the issue/bug of missing interest payments in the google sheet export.

This was not a major issue when the auto-export was first set up, but that was over a year ago and saving rates are a little healthier now. Missing interest payments from the CSV export means that the live google sheet feed cannot be used to accurately determine account balance. Which is frustrating as its a paid-for feature.

Can I pretty please ask for someone at monzo to take on a mini project in the new year to add interest payments to the CSV google sheets export (including the live export)? Even if its needs to be its own column to avoid messing anything up, that would be perfectly fine.


Which interest do you mean? For Plus/Premium?

You’ve got me doubting myself now, but my understanding is that no interest payments appear in the Google sheets exports at all. Including plus/premium interest payments as well as payments from interest bearing savings pots.

1 Like

Plus/Premium does, but it doesn’t have a merchant name, so if you’re using that column for uniques or anything, it won’t show.

Same as paying for Plus/Premium. Unsure about interest pots.

1 Like

Ah yeah you’re right, so it’s specifically the pot interest that doesn’t appear in the exports :+1:


And if they can add virtual card from a pot to the sheet at the same time, that would be great.

I wonder if a separate feature request of “Things Missing from Google Sheets Export” is needed.

I think there’s a growing list now depending on your usage….


My top 3…

1 Like

Want to give this another another bump.

Increasing interest rates on savings pots is awesome, but interest still doesn’t show up in the automatic Google sheets export (a paid-for feature of plus and premium) or the regular Google sheets export.


I haven’t seen this being mentioned anywhere, but I would love it if the Google Sheet could have a second spreadsheet on the same file that JUST has the balance of each connected account. I would love to automate all my finances further if this was possible.

Also, If anyone has any cool spreadsheets, dashboards, ideas, IFTTT uses and even ChatGPT uses, please share.

1 Like

This post is probably a good place to start for some basics on how to make the most of the export using Google sheets:

1 Like