Unfortunately, you don’t have many options that are built into Airtable if you’re looking for this to be automated instead of manually triggered by you.
Unfortunately, there’s no way to automate that very cool “Send Records” function (either with or without the grid option).
And Page Designer has no ability to be automated either.
So you would need to recreate this table as an HTML table, and then automate the sending of the HTML-based email.
You can actually paste HTML code into the body of the SendGrid app and manually send your email from there, but the SendGrid app can’t be automated either, so that would be the same exact equivalent of manually right-clicking on a record and choosing “Send Records”.
So there’s really no advantage for you to use the SendGrid app.
All of this can be easily automated with an external automation tool like Integromat.
It will take some time for you to set everything up, but once you get everything setup and working, it will just happen silently & automatically & seamlessly in the background, without any manual intervention on your part at all.
(If you have a budget for this project and you’d like to hire an expert Airtable developer & expert Integromat consultant to help you create all of this for you, please feel free to send me a private message or contact me through my website at ScottWorld.com. Note that I am a professional Airtable consultant and a Registered Integromat Partner, and the Integromat link contains my personal referral code.)