I am attempting a Zap step using ‘Lookup Spreadsheet Row’ in Google sheets, and I cannot find a way to tell Zapier to look for the first blank cell (or cell with no value) in the search column (leaving the ‘Search Value’ field blank fails the step as a value is required). Is there an operator Zapier recognises that tells it to search for the next blank row/cell in a column?
The broader challenge - I have a list of unique sequential IDs in column C, and I need Zapier to update a row to included new registrant details (such as name, email etc) when they register. Using the ‘create new row’ action simply inserts a new row below the last ID. I have also considered having Zapier assign a unique ID when it creates a new row, but I don’t know how to have it lookup the last ID in sequence and add the ID+1. I need the ID for later steps.