How to get row information for Google Sheets Updater

I am reading from Google Sheets, finding the first row where a certain cell is blank, processing with information from the other cells in that row, then writing back the missing cell. The Google Sheets Updater wants me to specify the range in A1 notation. What’s the best way to capture that information when I find the first row with a blank cell? Or should I use something other than the Google Sheets Updater?

It seems the value for Range in the Google Sheets Updater can not be entered dynamically so I have reconfigured my workflow to get around that.

1 Like

Sorry for the trouble - glad you were able to find a workaround. :+1:

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.