Problem with Webflow Zapier Integration

Design help Data API
1

Hello,
i’m having troubles on intergrating google spreadsheet row to create new collection item.
When i catch my data from spreadsheet via zapier, i select webflow option and choose my project and my collection. then i fill the data exactly it appears on the collection and i when i’m testing my zap i got this error:The app returned “ValidationError: Validation Failure”.

i tried several times to check if i have missmatched some required data but nothing helps.
Anyone know how to solve it?
Thanks.

image
image833×229 18.8 KB

2

Hey,

I just tried to reproduce this issue of sheets data to webflow new item in CMS but it worked fine for me.

image
image1453×334 13.5 KB

You should use False for both archieve and draft. And also make sure your site is published and not in draft stage. It should work.

3

Yes I’ve been having this trouble too (using Airtable instead of Google Sheets) and it seems to be a widespread blocker for many Webflowers.

Followed multiple tutorials which step it out perfectly such as the one by @MackenzieChild but still seem to receive an error. Any ideas guys? @PixelGeek might be across this too

1 Like
4

Hi Frazer, are you trying to create a new live item in the CMS with a zap from Airtable to Webflow, or add a reference or multi-reference? If you have an example I might be able to take a guess as I recently spent a week trying to solve it.

1 Like
5

@tim28 I am trying to create a new live item in CMS with Zap but from a webflow form. It does add reference to other collection items which I am using their UUID as values.

But I am receiving the same error when testing the Zap. Any thoughts?

6

Hi Veronica, are you trying to generate a new live CMS item from the Webflow form, and tie it to a multi-reference field in another collection? The only way I was able to successfully get mine to work was with Webhooks by Zapier. You need to leave the multi-reference field blank in your first zap, then create a second “Webhooks by Zapier” to tie the new live item to the other CMS collection, using the Webflow ID in quotation marks if part of a series.

Testing the API call with Postman saved me from pulling my hair out.

If you want to share any screenshots I might be able to help further.

7

Screen Shot 2020-08-30 at 11.59.42 AM
Screen Shot 2020-08-30 at 11.59.42 AM888×548 61.4 KB

Thanks Tim! Here is a screenshot, I’ve circled the fields that are Reference Fields in Webflow. They are not Multireference fields but do they need to be wrapped in quotes “”?

I actually tried just doing the Create Live Item via Zap without these fields first but still get that same error once I try to update them in the next Zap.

8

Actually I was able to get it to work this. Looks like I goofed and was adding a reference from the wrong collection!

Once I made sure all the ids were mapping objects for the proper collection of that Reference field, it worked. Thanks @tim28!

9

Yay, way to go! I know these zaps to reference fields can be confusing, glad to try and help if I can. :slight_smile: