Resolving a google sheets error

:bullseye: What is your goal?

To automate tracking for my mom’s personal training business, have make.com watch for new session-related calendar events (events that contain session), then parse the name and session number so that google sheets can then update the necessary client name column (based on the name that text parser parses), and update the sessions completed row that i have.

:thinking: What is the problem & what have you tried?

It seems that everything is confiigured properly, but I keep getting an error that row number is not returning an output. I don’t know why exactly - it could be that search rows doesn’t recognize the value i gave it but I’m not sure how that’s possible. It might be a problem with text parser too. Wondering if anyone has had similar troubles/ and what worked as a solution?

:clipboard: Error messages or input/output bundles

BundleValidationError
Validation failed for 1 parameter(s).
Missing value of required parameter ‘rowNumber’.

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.

:camera_with_flash: Screenshots (scenario flow, module settings, errors)

1 Like

Hey there,

the error happens because Search Rows isnt finding anything. Check your search criteria and check the sheet to verify that there should be something returned.

Hi @Sean_Manning ,

Could you please verify that the row number specified in the Update Row module exactly matches the row number returned by the Search Rows module?
If there’s any mismatch between these values, it can lead to errors during the update operation.

Best regards,
Msquare Automation
Platinum Partner of Make
@Msquare_Automation