Error when updating a sheets row (invalid number in parameter)

BundleValidationError
Validation failed for 1 parameter(s).

  • Invalid number in parameter ‘rowNumber’.

So my basic flow is this: Take information from sheets, filter only entries marked by “QUEUE” and another variable, create a word document, then go back into the original sheets file and update “QUEUE” to the current date for the entries completed

I’m new to the platform and keep getting the error mentioned above, what am I doing wrong?
Thanks!

Hello @strengthchallenges; Google Sheets Update module isn’t referencing the Row Number from the first Google Sheets Search module. As such, the update module doesn’t know what to update. Right now, Mailed is that Row Number spot.

Hey @ImMichaelCannon thank you for the reply. What is the correct sequence of modules / how do I get the Sheets Update to reference and change the Row Number from the original Sheets reference?

Howdy @strengthchallenges, per the attached, you seem to have things mostly correct. Just change the Row Number variable to the originating information from module #1.

Row Number expects a positive integer, not a text string. Row Number is the sheet’s row where the information originally came from, and is used to know where to update.

1 Like

Thank you so much for the help! Answer was sitting right there, appreciate it.

1 Like