Short version: Is there any way to email a specific tab within a Google sheet on a monthly basis, and then clear down (delete) a different tab as part of one automation?
Long version: I have IFTTT setup to track all my transactions from my Monzo bank account. The transactions are written/appended to Sheet 1 in the spreadsheet.
Every month I go to the spreadsheet and, on Sheet 2 I have a quick SUMIF set of queries that runs and from which I get my monthly travel/food expenses.
Ideally, I’m looking for a way to get Sheet 2 emailed to me at the end of every month, and then have all the data deleted from Sheet 1 so it is only every holding a month of data.
I’ve looked at Zapier but it seems to only have ‘lookup row’ style functionality when it comes to emailing data.
Don’t mind upgrading/paying for something that will do this. I’m on iOS/MacOS too if that helps.