Google Sheets - Update a Row is not recognizing rownumber and will not update Google Sheet

Questions
, , , , ,
1

:bullseye: What is your goal?

My goal is to enter an idea/topic into Google Sheets column A, ‘click’ Generate in Column B, and have OpenAI create a completion, and then update column C in the Google Sheet with the created content.

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

The problem (and I have spent literally the past five weeks trying to resolve this through ChatGPT and gotten nowhere, is that ‘Update a Row’ continually fails to recognize the rownumber field mapped from the first module, which has been either “Google Sheets - Watch for Changes” or “Google Sheets - Search a Row.” I have run all modules individually first to ensure the fields are mapped and that each module works correctly on its own. I have done sanity checks (ironically) to show that the modules are correctly configured, the data structure is valid, modules correctly parse. I have screenshots showing the modules’ output is correct. But once I connect Search a Row > Create a Completion > Update a Row, Update a Row fails.

I’d like to add more images to show you the settings and output of each module run separately, so please advise how to do so. Thanks in advance for your assistance!

: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)

chrome_P4kLMiZfv9.png
chrome_P4kLMiZfv9.png1920×1032 135 KB

6

Hey Glenn,

you can’t run that module on its own, it has nowhere to get the row ID from. Can you run the entire scenario and show the output then?

1 Like
7

That’s wrong. Search modules already iterate the data, no need to add an iterator module after a search module.

2 Likes
8

Welcome to the Make community!

You cannot individually run a single module if you don’t have example input data values for each required field, which you must input into the dialog box when you manually run a single module. This is because when you run a single module directly, the mapped variables in the module’s fields are null (do not contain any value), as the previous modules do not run and produce any variable values.

Instead, try running the full scenario by clicking the “Run Once” button:

For more information, see these duplicate questions previously asked and answered by other community members:

— @samliew
P.S.: investing some effort into the tutorials in the Make Academy will save you lots of time and frustration using Make!