Skip to main content

Hi

I have data from a lead generation platform coming in via email. The data is an attached csv file.
The first part, capturing the csv file on the email in Zapier works.
 

The data looks as follows:

Email 1 SKU 1
Email 2 SKU 1
Email 2 SKU 2
Email 3 SKU 5

 

So people can request multiple items at the same time (same ‘order’). These different items show on different lines in the csv.

 

I now want to get this contact information into our CRM, but I want to push it to our CRM like this:

Email 1 SKU 1
Email 2

SKU 1, SKU 2

Email 3 SKU 5

 

How can I achieve this? Is it possible with loops?

Hi @LennertDC 

You would likely have to use custom Code to first prep the data.