Have you found and tried the Stored procedure SQL action?
It should allow you to run a procedure, and then in a subsequent action it allows you to use the output as part of the action (e.g. sending the SQL procedure's output as part of the body of that email).
(Attaching a screenshot of where you can select this SQL action).

Feel free to post again in case you would like more details/help.