Can I manually add a value into a cell which could then cause an IFTTT action that would move the value of the cell into a specific pot?
Im trying to figure out a way of automatically moving money into a pot when I use a credit card that isnt an account that can be added to monzo. When I use the card I receive either an email or sms message, so if I can somehow get the value of the transaction into the spreadsheet, this could trigger the action. Although not entirely sure how to do that bit either yet!!
Its basically the New Day Amazon card, but I want to auto move the money to a pot in Amazon so I can pay in full end of each month.
So yes! You can do that - thereās a specific trigger in IFTTT called āWhen a Cell in Google Sheets is Updatedā (or soemthing very similar)
I set up something very similar to do what youāre describing for American Express - I did a mini write up here
What I did was use Zapier to extract the balance amount from the regular email I got - apparently there are ways you can extract from SMS or Notifications in Android, but not iOS, so thatās the solution I went with.
The solutionsā a touch Janky because the IFTTT āCell Updateā doesnāt always fire on time reliably, but when it works, it works great.
The āCell Updateā idea is a great use case for the Google Sheets integrations, cos you can do so many more powerful things than Regular IFTTT alone can acheive. Things like āIf my Balance is below X then Move Y from Potā, or āIf I spend more than Ā£30 at McDonalds in 1 week then [other things]ā.
Happy to help if you need it - this is my all time favourite Plus feature so if I can get more people using it Iām happy
I should have known that @BritishLibrary will have already been all over this
Itās also worth noting that Monzo were planning on building this prior to all the lockdown and stuff. So it may come built into the app at some point in the future.