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.

 

[Mijares72]

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.

Ok. BUT, in what kind of Format you suggest to convert the records table, so it would be possible to send it in a single email ?

 

[Preeti Paryani]

Hello @Mijares72,

You can convert the data captured in the advance format to a table format or any other required format using a code step. This will allow you to summarize and structure the records efficiently before including them in the email.

To generate the necessary code for this transformation, you can take assistance from ChatGPT or any coding resource as per your preference.