Hi @corb ,
I do not think the attachment functionality could be used this way. You would need to have existing file first to attach it.
To create CSV file from an Airtable view, I would just use Make.com - it has a handy CSV module.

In the Airtable module you specify the view to take data from.
In the CSV you select what data should be included:

In the Gmail you use the output text as data and name the file the way you want.csv

You could use automation to trigger this scenario (instead of time scheduler I am using above).
Let me know if that helps?