Automated email send in workflow trough smtp

I wish you a wonderfull day!

So, I'm trying to send some simple table data through an email.
But being new to al of this i can't figure it out. I tried searching the forum but coult not get a clear anwser.

This is what i have so far.

The email is being send but the text in the email is:

[object Object],[object Object],[object Object]

What can i do to get the information i want in the e-mail?

If anyone can help me in the right direction that will be much appreciated!

Do you see the data when hovering over {{query1.data}} ? It's underlined in red, so it might not find the data.

1 Like

Hi Pannenkoek,

You are sending an array of objects and that's why it's not appearing as text.

Easiest solution would be to use {{query1.data.toString()}} but less readable.

Other option would be to use a code block and convert the array of objects into a desired string which you can reference in the SMTP block.

Let me know if that helps!

1 Like

Thank you so much!

With your help i got it working.

I used a code block to format the data from the query.

This is what i am using now:

Thanks again!

Pannenkoek

1 Like