Google sheets Missing value of required parameter 'rowNumber'. Error

[Connor3]

Hi everyone,

After an automated text is sent, I want a cell within that person’s row in Google sheets (each person has a row with name, number, etc…) to change to “Sent”.

I keep getting a Missing value of required parameter ‘rowNumber’ error in the update a row module.

To get an idea of this scenario, I am having an automated text sent to a person after a row is added to Google sheets. After specific amount of time, a text will be sent out. It’s not fully built out yet which is why there is only one branch after the router.

It works when I add a random number in the “Row number” field, but it will then only go to that cell number, not cell that is within the row of a specific person I just texted

All I want is the Google sheets update a row to find the cell within the row used (so the person I texted) and update a cell to say “Sent”.

Thank you!

[Stoyan_Vatov]

Hey Conor,

few issues here.

First the Search Rows already returns a separate bundle for each row it finds, no need to iterate it.

Second, you never map the entire [bundle] that the previous module produced (unless in some extremely niche cases).

And third, you need to map the row number from the previous module in the Row Number field. You are mapping the E column called Status.

[samliew]

Welcome to the Make community!

In short, delete the Iterator and it’ll make sense.
This is because you do not have an ARRAY to Iterate over.

I’d recommend going through the Make Academy if you haven’t yet!

Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —

Learn Make

• Help Centre | Tutorials – Make’s “manual” - search for help here first
• Make Academy – Basics 101: Learn Make properly to get your money’s worth
• Mapping – What is mapping? What can I map?
• Mapping with arrays – How to map items in an array
• Date Format: tokens for parseDate | tokens for formatDate
• HTTP modules – Make a request, Get (download) a file
• Webhooks – Error Handling, Responding to webhooks

How-Tos

• Router Magic Formula - YouTube
• Error Handlers in Make - YouTube playlist
• Aggregate an array for mapping complex fields
• Getting started with OpenAI - How to setup and use OpenAI in Make
• Text Parser module - Use pattern matching to extract the text you want
• Webhooks – Make Academy - tutorial on how to use Webhooks