IMLError Function 'encodeURL' finished with error!

[elvet_jay]

Hello everyone, I am encountering this error message when trying to run my scenario.

My goal is to add a new contact to Smartsuite everytime a new row is added to my spreadsheet.

I am adding rows using the Bardeen chrome extension and I scrape profile information from LinkedIn Profiles.

I am using in Module 1: Google Spreadsheet → Watch New Rows
and in Module 2: Smartsuite → Create a new contact.

The scenario fails to run Module 1.

This is the error message:

IMLError

Function ‘encodeURL’ finished with error! Function ‘composeWatchRowsRange’ finished with error! object null is not iterable (cannot read property Symbol(Symbol.iterator))

Origin

Make

Automatic error handler

If you want to handle this error automatically, choose one of the following options. This will create a new error-handler route in your scenario. You can then expand the route in any way you like.

I looked for solutions in

• Make community
• Reddit
• Perplexity.ai
• ChatGPT4

Is it a problem in my module settings, in Google Sheets or in Make.com? Remember Watch New Row is a new function I believe.

Best of luck, and thank you for your time,

Ben

[samliew]

Welcome to the Make community!

What is the content in the new row that caused the error?

[Janella]

@samliew

What is the content in the new row that caused the error?

Hi - if I can add on to this, I’m getting this same issue and I’m trying to watch rows with URL contents.

[Michaela]

Hello @elvet_jay welcome to the Make Community

When setting the “Row with headers” field, make sure to use the correct range. I noticed from your screenshot that you’ve set the range from “A1:AE,” but “AE” does not seem like a valid range. It should match the range in your sheet, like “A1:F10,” or whatever fits your data in Google Sheets.

[elvet_jay]

[elvet_jay]

Hello @samliew
Hello @Michaela

Thank you for taking care of me here. And thank you for the kind welcoming message.

So the content in the Google Spreadsheet is scraped profile data from LinkedIn Profiles using Bardeen.ai.

It’s information like:

Partner | CEO
Nov. 2022–Heute · 1 Jahr 4 Monate
https://www.linkedin.com/company/58681/

Could it be due to the symbols like “|” or “·“ ?

As you can see in the above screenshots, the spreadsheet expands up to column “AE”.

Have a wonderful day and talk to you soon,

Benjamin

[elvet_jay]

@Janella I found the solution to my problem. @Michaela pointed me in the right direction:

THE SOLUTION IS:

ROW WITH HEADERS → Write: A1:AE1.

What I wrote and what caused the erorr: A1:AE.

Now the scenario is running.

[Michaela]

Hello again @elvet_jay

I’m glad to hear that my suggestion helped steer you in the right direction!

Thanks a lot for circling back to this thread and sharing what ultimately worked for you and how you’ve set everything up. This could be super helpful to many others who are looking for similar information