ERROR Google Sheets - Search Rows5+0.6s The operation was completed. Google Sheets - Update a Row8 The operation failed with an error. Error Validation failed for 1 parameter(s). - Missing value of required parameter 'rowNumber'

Knowledge Hub
1

:bullseye: What is your goal?

I AM ATTEMPTING TO COMPLETE AN AUTOMATION IN MAKE HOWEVER ERRORS ARE SHOWING ME:
•
Google Forms - Watch Responses1+0.1s
The operation was completed.
• Google Gemini AI - Generate a response2+0.8s
The operation was completed.
• JSON - Parse JSON3
The operation was completed.
• Google Sheets - Search Rows5+0.6s
The operation was completed.
• Google Sheets - Update a Row8
The operation failed with an error.
Error
Validation failed for 1 parameter(s).

  • Missing value of required parameter ‘rowNumber’.

OUTPUT IN GOOGLE SHEETS IS STATING 0 NUMBER OF BUNDLES
HOW DO I CORRECT THIS TO GET MY AUTOMATION TO COMPLETE ITS FUNCTION ?

:link: Create public scenario page

3

Hi @D_ELISABETH_MARSHALL ,

It appears that the Search Rows module is returning 0 results, which means no row number is being found. Because of this, there isn’t a row ID available to pass to the Update a Row module.

Could you please check the following to help identify the issue?

  • Make sure the search value exactly matches the value in your sheet (including spacing, capitalization, and formatting).

  • Confirm that the module is searching in the correct column and the correct sheet tab.

Verifying these points should help ensure that the Search Rows module returns the correct row, allowing the Update a Row module to work as expected.

Hope this helps! Let us know if you need further assistance.

With regards,
Mohamed Jahar

4

You simply need to add another filter condition to only continue if there are results from the search module.

Screenshot 2026-03-12 181442
Screenshot 2026-03-12 1814421061×675 58.8 KB

Have you seen these previous discussions?

Your question may already have answers here:

Based on the above, you may have asked a duplicate question. Before creating a new topic in the forum, you can search this forum for existing answers and the Help Centre to get to a solution faster.

Still require assistance?

If the previous/related discussions are not similar to your question, please reply providing additional details to demonstrate the difference(s) between your question and the ones above.

If you require help understanding or implementing workarounds/solutions in the related discussions, please reply with more details of what you have tried, including screenshots.

— @samliew

1 Like