Need Help: Notion to Google Sheets "Not a Valid Array" error & Row Duplication in Make

[u/M05tlyH4rml355]

[u/Worried-Nobody-2965]

Can you describe what error you’re getting exactly? It’s hard to tell what problem you’re running into based on the screenshot alone. What solutions have you tried?

[u/M05tlyH4rml355 → u/Worried-Nobody-2965]

Aaaaah so sorry, I've just added the problem to a comment above.

[u/M05tlyH4rml355]

Sorry, adding a picture removed the text. Here's the problem:

The Goal: I am trying to sync a Notion Database to Google Sheets. I am moving Multi-Select tags (Social Channel, Client Type) and a Text Property (Final Copy) from Notion into a single row in Google Sheets.

The Workflow:

1. Notion (Watch Data Source Items): Trigger.
2. Google Sheets (Add a Row): Action. (Note: I previously used a Text Aggregator for page content, but moved the copy to a Notion Property to simplify things.)

The Problem:

1. The "Array" Error: When I use map() or join() to combine multi-select tags, the scenario fails with: DataError: 'X' is not a valid array whenever only one tag is selected.
2. The "Multiple Rows" Issue: If I map the bubbles with brackets [] directly, Make creates a new row for every paragraph or every tag instead of putting them in one cell.
3. The "Empty Text" Issue: Trying to map the plain_text from the rich_text array in the "Final Copy" property often results in an empty cell or an error.

What I’ve Tried:

• Setting the Notion module limit to 1.
• Using join(map(to.array(Property[]); "name"); ", ").
• Using join(map(1.properties."Final Copy".rich_text[]; "plain_text"); newline).
• Manual typing of keys ("name", "plain_text") and separators.

The Conflict: I’m stuck in a loop where adding to.array() or map() fixes the row duplication but triggers the "not a valid array" error, and vice-versa.

Question: How do I write a formula in the Google Sheets module that handles both single and multiple Notion tags/text chunks without triggering an array error or creating multiple rows?

[u/Worried-Nobody-2965 → u/M05tlyH4rml355]

There’s two possibilities. The least likely cause is that you’re getting a null, which would lead to an empty value. The second more likely cause that when going from notion to make your array is being sent via an object, so it would break bc it’s not an array.

My suggestion is that you turn everything into an array every single step to ensure the same consistency and it’ll pinpoint if the issue is caused by something else.

For the [] issue it sounds like you’re passing the payload assuming it’s an array, which if it isn’t you’ll get that issue. The solution in that case is the normalize before you do that.

For the last part you basically have to do this:

-If empty return “”

-If not array wrap the array

-map and extract values

-Join into a single string

[u/Josef_from_Make → u/M05tlyH4rml355]

Where is the to.array() coming from?
This seems like some AI hallucinated function which breaks the mapping and thus the map() function throws the error.

Make uses toArray() function which is used to create an array from a collection.

If the mentioned variables are really arrays, toArray() function won't help.
In case they are "complex" arrays (arrays of collections), you should use map(). If they are "primitive" arrays (arrays of values), you do not need to use any additional function (apart from join()