BundleValidationError occasionally occurring when syncing data from notion to google sheets

[timjeffries]

What are you trying to achieve?

sync data from Notion into Google Sheets

Steps taken so far

I’ve built out the automation and it’s all running except occasionally I’m getting the following error.

What is this trying to tell me?

BundleValidationError

Validation failed for 3 parameter(s).
Collection can’t be converted to text for parameter ‘7’.
Collection can’t be converted to text for parameter ‘8’.
Collection can’t be converted to text for parameter ‘9’.

I’ve also attached a view of the overall scenario and the module that’s spitting the error.

Screenshots: scenario setup, module configuration, errors

[mszymkowiak]

Hi!

The Notion database returns parameters (properties) as an array of collections.

Please take a look at this guide: Mapping Arrays on Make.com.

[timjeffries]

Thanks heaps for this.

I was pretty tired by the time I wrote this post and had just made the simple mistake of selecting the array and not the string.

Your post prompted me to check and that was the issue. Thanks again.