You can also create custom reports and add them to the emails via attachment.
Here is a link to a looped email send that I created to avoids errors when flow variables are passed that have missing values. (Such as some emails containing CC lines or attachments and others not requiring them).
In fact, I recently incorporated a nice example of something that you could never pull off in Alteryx… You can have Chat GPT or GPT4ALL access those tables by dropping them into into an adequately descriptive prompt if you convert the tables to AsciiDoc format and insert them into the text strings. You can then incorporate the custom AI descriptions, analysis or visualizations into each email. You can even utilize a vector database from a PDF or other document with guidance / examples so that better informs your model for it’s custom purpose.