I’ve made a way to do an Automatic Salary Sweep when you get paid, using Sheets and IFTTT. Let’s say on Payday you want to move all your leftover money into a Pot. You can do it now.
In your Monzo Transaction Google Sheet, set up a little table like so:
Yellow Cells = Formula, Green is the final outcome you want.
Name - enter how your salary payment looks when you get paid. (If this is not consistent, can do this other ways)
Time frame - Enter the formula ‘=today()-1’ -
Value - a Sum If that will look for Name and Date:
=sumifs('Monzo Transactions'!H:H,'Monzo Transactions'!E:E,[Name Cell],'Monzo Transactions'!B:B,">"&[Date Cell])
Account Balance - sums everything in your account - displays blank if no recent pay day is found.
=if([Value Cell]>0,sum('Monzo Transactions'!H:H),"")
Buffer Amount - Will tweak the final “action amount” - if you want to say move an extra 200 more than your balance, enter 200 here. Or a negative to move less than.
Action Amount - a sum of the relevant cells - and this is what tells IFTTT what to move. Either displays a value, or is blank.
=if([Acc Balance]<>"",[Value]-[Balance]+[Buffer],"")
(replace with relevant cell ref)
Done. So on Pay Day, this should look something like the screenshot above. Basically the cell in Green will update with the “excess” and you then go to tell IFTTT what to take out.
In IFTTT:
- set up a “When a cell changes in Google Sheets”,
- enter your Green Cell ref in the relevant box,
- Add Monzo Move Money to a Pot as the ‘That’
- And for the amount, use the ingredient {{value}} - which will be your green amount.
Presto, your balance Pre-Payday will move into a pot, leaving your main balance with just your salary.
You can do all sorts of little searches to do more automatic money moving.