I Need to store all details from Sent Mail and Twilio Messages like Subject, Body and sent To and From, Message, To Phone Number etc etc in postgresql Log table. This is just like logging the details in different tables after the mails and messages are sent.
What is the error message (if any)?
I need a way to capture all those details and then store it in Postgresql table. As Output of Send Mail node.
Hi @SWAPNIL_NANDANWAR, I am not sure I understand the problem here. Are you running into any issues with simply adding a Postgres node after your Send Email (or Twilio) node inserting the data you’re looking for? If so, can you share your workflow and the exact error you’re seeing?
I am asking because from quickly testing this on my side this appears to work fine.
Here I want to save the Send Mail Node’s details like Text (i.e Body), Subject, To Email for every mails as a log in postgresql table.
In Twilio it works fine as we get different details like Body, from , to etc as the output of the Twilio node. But same doesn’t happen in case of Send Mail node. I am attaching screen shots from Twilio and Send Mail nodes.
I am good with Twilio output but don’t know how to get details from Send Mail node.
There is No Error, I just need a way to capture few details as logs in our table.
Twilio which is fine. I have mentioned with arrows and Highlights for the details that I get which is wat I needed -
Hi @SWAPNIL_NANDANWAR, seeing you have shared only a screenshot of your workflow I don’t quite know what your Code node returns or how your database table looks like.
But it seems to me you can use a Set node to simply read the values you’re looking for from your Code node into the right columns, then insert your data into your Postgres table:
I’ve tested this just now and it’s working fine:
On a separate note, you might want to consider switching from using n8n desktop to using the Docker version of n8n (as the desktop version has been deprecated and won’t receive further updates).
Could you please let me know how do I upload my whole workflow that would help you in more details as I do not see the output like {{ $node[“Code”].json[“subject”] }} and {{ $node[“Code”].json[“text”] }} in Set node, when I connect it to Send Mail node. Attaching the screenshot for the same -
I do not see the output like {{ $node[“Code”].json[“subject”] }} and {{ $node[“Code”].json[“text”] }} in Set node, when I connect it to Send Mail node
Hi @SWAPNIL_NANDANWAR, you might need to write these expressions manually in your Set node. Alternatively, simply select the node in my example workflow here on the forum, press Ctrl+C to copy it, and finally press Ctrl+V in your own n8n canvas to paste it.
This also works the other way round, you can select your workflow on the right in your n8n canvas, then copy and paste it here on the forum (make sure you remove anything confidential though).
