Sending last month of data as attachment

Hi!

We have a Smartsheet where all rows created within the last month need to be sent as an Excel file to a certain email address on the last day of the month.

So far I've set a filter for the last 31 days on the sheet, and then used the recurrence feature on 'File: Send as Attachment' to capture the whole month. Will the filter still be applied when sent and opened as an attachment?

However, that will also send rows that have a created in date before that month in some cases (e.g. a filter for the last 31 days on March 31st would still show February 28th).

Is there a way to get all rows created within the last month to send to as an email attachment on the last day of that month?

Is it also possible to do this with only some of the columns showing (i.e. this is a report for our finance team, where other information is irrelevant to them and they just need to see columns with the financial information)?

Thanks for any help you can give! :)