Skip to main content
Question

How do I push contact info from a CSV file with multiple items per order into our CRM using Zapier?

  • January 30, 2024
  • 1 reply
  • 26 views

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?

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • January 30, 2024

Hi @LennertDC 

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