Best answer

Updating multiple CMS items in Webflow from .csv file - Error : ValidationError:ValidationFailure

  • 8 April 2022
  • 7 replies
  • 69 views

Userlevel 1

Hello,

I am new to Zapier and am struggling to get my zap to work. I am attempting to import a .csv file from email parser by Zapier into Webflow CMS. Ultimately, emails will be sent to the parser with .csv attachments every 6 minutes and I need this information to auto update in Webflow. I would like my customers to be able to see this information in live time.

I am able to get the email through the email trigger, use the formatter utility to pull the .csv file, but it will not send to Webflow to create a new item. (ValidationError:ValidationFailure).

If anyone has any ideas I would appreciate it.

icon

Best answer by Troy Tessalone 8 April 2022, 21:01

View original

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

7 replies

Userlevel 1
This is what I have set up for my create item in Webflow

 

Userlevel 7
Badge +14

Hi @Jfff 

Good question.

What email app are you using? (e.g. Gmail)

 

Try using the Looping app to handle the line items: https://zapier.com/apps/looping/integrations

 

If using Zapier Email Parser, try these Zap steps...

  1. Trigger: Parer - New Email
  2. Action: Formatter > Utilities > Import CSV File
  3. Action: Looping - Line Items
  4. Action: Webflow - Create Item / Create Live Item

 

If using Gmail, try these Zap steps...

  1. Trigger: Gmail - New Attachment
  2. Action: Formatter > Utilities > Import CSV File
  3. Action: Looping - Line Items
  4. Action: Webflow - Create Item / Create Live Item

 

Userlevel 1

Thanks for the quick response Troy. I am using Parser. I set up the loop and it seems to be working fine. Still can’t get the info sent over to Webflow. From what I have read the items need to be separated by semicolons. I don’t see an option to change this anywhere. Below is what I have set up. Maybe I am missing something?

 

Userlevel 7
Badge +14

@Jfff

Looping help article: https://zapier.com/help/create/other-functions/loop-your-zap-actions

 

Don’t use the preview_loop_values field from the loop test in your Zap.
It is for preview purposes only and doesn’t appear in actual Zap runs.

 

You need to map different output variables from the Looping step.

The mapped variable should only have 1 value.

 

Userlevel 1

Thanks for the clarification. When I run a test only one CMS item is sent to Webflow. Shouldn’t all items in the loop be sent?

 

Userlevel 7
Badge +14

@Jfff 

Per the linked help article:

Looping help article: https://zapier.com/help/create/other-functions/loop-your-zap-actions

 

Userlevel 1

Scratch that. I turned my Zap on and all records are now populating in Webflow!

Thanks for the help. I’m sure I’ll be back with more questions as I move further on this quest.