Sending info back to Google Sheets

I am trying to send data from ScrapingBee back to my Google sheet. I keep getting the error “The operation failed with an error. Validation failed for 1 parameter(s).” I selected Row Number but it keeps giving me the error. I want it to put the info in the newest row.

When asking your question, please include:

:footprints: The steps you have taken
:camera_flash: Relevant screenshots
:link: Any links you have
[ Code { "and": "JSON", "in" : "code block"} ]
:x: Exclude Personal Information.

Hi @DUNK,

Can you share me how your full scenario looks like and can you show me the mapping for Gsheets and also the error screenshot?

2 Likes

Hey @Runcorn,

I have attached the screenshots. The scenario I’m trying to build is, 1) drop a link into Google sheet, 2) ScarapingBee scrapes site, 3) OpenAI writes long description, 4) OpenAI writes short description, 5) Title and both descriptions get added back to the same row on the Google sheet.

Thanks again…



Hi @DUNK,

I have just spent the last couple of hours trying to work out my own BundleValidationError also. For my issue the reason I was getting the error was because the data was not in a format that Airtable recognises.

This error comes from Make as I expect it knows what format is required and validates it before sending it to the target module.

Can you post a photo of the output of the first module so we can see what format the Row Number is? Seems silly but worth checking.

Cheers