Not quite embedded in Automator but the flow for this solution is as follows:
Export the data into a CSV or space delimited file.
Use the attached to send an email that takes the file and adds it into the email as a mail body, NOT an attachment.
Invoke it using a post process script or after the export in whatever workflow engine / logic is being used.
Below a link to a zip file where you will find an xml process file that contains a model and a project. Please, make sure that you copy the classic.prn also included in the zip file in the following location c:\datawatch\GMA path. Import the process file to the Automator.
Make sure you add the system.io in the namespace. The script should be in the project post-export.
Hope this help,