Loop through CSV file before sending Email
Hi All,
I have a requirement where I receive a CSV file containing Owner Email, Id and other details as column.
I want to send an email to the people in the “Owner Email” column of the CSV. But it is possible that one Email can have multiple entry.
In that case I want to loop through the data and send the data related to that email address together in one email. So I don’t want to send seperate email to the same email address , rather I want to loop through the csv to see the email address related data and send everything in one email.
So if an email has multiple entry in the table , I would like to send everything related to this unique email in one email.
Can you please help me with suggestions on how to achieve it?
I am attaching two sample pipelines:
1)Parent - which groups the data based on the email and send the data to Child pipeline.
2)Child - which split the groups, apply xslt transformation(generate HTML table), and send the table through email.
Parent_2021_08_27.slp (4.9 KB)
Child_2021_08_27.slp (10.2 KB)
Also, I am attaching the sample XSLT file, which you can modify based on your requirements:
XSLT_Transformation (1).txt (1.1 KB)
Note: You must create a SMTP account in order to be able to send emails, using Emails Sender Snap.Regards,
Spirp Taleski