HELP - How to send an email with a MySql result records BUT in a single email

[Mijares72]

Hi.. I´m trying to send a Daily email "Daily Report" with the result records of a MySQL query. I´ve already accomplish to send an email for each record (using iterator).

BUT now, I need to send a SINGLE email containgn a "table" with the N records retrieve from the MySQL query. I need the email to be structured something like this:

How can i do that ?

thanks folks.

 

[ArshilAhmad]

Hi @Mijares72,

Pabbly

connect.pabbly.com

The use case you are trying to achieve is not possible through Iterator or any existing tool. If you are familiar with coding (or even if you are not, you can ask ChatGPT to write one), you can try using Code by Pabbly to convert the JSON received from MySQL into your desired format and then send it through Gmail.