*JESUS* Google sheets + Webflow via Zapier: ValidationError: Validation Failure

Design help Data API
1

Hello

i’m trying to zap a sheet to update/create items in my collection, and when i have linked all the info in the Zapier, the testing page tries to send a zap and gives me this:

ValidationError: Validation Failure

I have read multiple threads about this, however i cannot find a simple and good answer which fits my case. I have tried changing the multi-reference fields to option fields in the collection list in webflow, but it still wont work.

I also tried switching to excel, but it wont work there either.

READ LINK:
https://preview.webflow.com/preview/marin-design?utm_medium=preview_link&utm_source=designer&utm_content=marin-design&preview=fe4385f66f8bda4761ff8cb1c1e4804a&pageId=60018618e284b207430e9fd3&mode=preview

Uten navn
Uten navn2560×1440 290 KB
Uten navn2
Uten navn22560×1440 281 KB

Here is my public share link: LINK
(how to access public share link)

2

Did you get this fixed? I’m getting the same response from Zapier. I am trying to sync blog posts from a spreadsheet. I’m wondering if it’s actually the IMAGE field that’s causing the problem. I can’t figure out how to provide the image in Google Sheets so that it will work. It’s the only field that I can’t change or remove.

https://preview.webflow.com/preview/point-one-ff28b7?utm_medium=preview_link&utm_source=designer&utm_content=point-one-ff28b7&preview=4740c0e62f4712f9b3a5b415a98b49bb&pageId=63f2f8a72d342c421611c89b&workflow=preview

3

Hi @BlakeDuerden :wave: welcome to the forum.

Here’s a tutorial on created on doing this, maybe it’ll help: