Grid data via Email

Create the required HTML and add it to the email.

you can't, directly, but assuming the amount of data you're trying to send would be reasonable for an email to contain, you could query that data and manually construct the necessary HTML for a table which you embed in your email pretty simply.

You can send grid data via email in two ways:
1. Without export - Convert the data source into an HTML table using an expression and place it in the email body.
2. With export - Use the Export Data Store Entity to Excel smart service to generate an Excel file, then attach it to the email.

Use the HTML method for simple, readable tables in the email body, and the Excel export for large or detailed datasets that users can download and analyze.