Import Amex Transactions into Google Sheets

I’ve come up with a temporary workaround until I can come up with something better:

  1. Use IFTTT to add a new row to Google Sheets whenever a new transaction occurs (as in AMEX + Monzo Bills Pot + IFTTT = Closed Loop! 🙌)
  2. Add up the “Amount” column into a cell and reference that from my financial spreadsheet

Whenever I pay the bill I’ll need to make sure I manually add that row into the “AMEX Transactions” sheet, and any non-GBP transactions breaks it, but still a lot better than inputting the balance in manually