Every hour, finds the rows on a Google Sheets tab where a column holds a value you choose, or is empty, ready for the steps you add.
Uses
Google Sheets
Find matching rows in a spreadsheet
Run every hour.Run every hour.
Set spreadsheetUrl to blank.Set spreadsheetUrl to blank.Set tabName to blank.Set tabName to blank.Set lookupColumn to blank.Set lookupColumn to blank.Set lookupValue to blank.Set lookupValue to blank.Google SheetsRead the rows of spreadsheetUrl. Save it as sheet.Read the rows of spreadsheetUrl. Save it as sheet.Set found to nothing.Set found to nothing.
If a step below fails, save the error as searchErrorIf a step below fails, save the error as searchErrorTry
Run Python code on rows, headers, column, value, and tab and save it as found.Run Python code on rows, headers, column, value, and tab and save it as found.On error
If searchError.message contains inputs are too largeIf searchError.message contains inputs are too largeYes
Stop and report a problem: The '@tabName' tab has sheet.count rows, more than this workflow can search in one run: the search takes up to 1 MB of the sheet, which is a few thousand rows of a typical sheet. Move rows you no longer need to search onto another tab so this one fits, then run it again.Stop and report a problem: The '@tabName' tab has sheet.count rows, more than this workflow can search in one run: the search takes up to 1 MB of the sheet, which is a few thousand rows of a typical sheet. Move rows you no longer need to search onto another tab so this one fits, then run it again.No
No steps
Stop and report a problem: searchError.message.Stop and report a problem: searchError.message.If found.problem isn't blankIf found.problem isn't blankYes
Stop and report a problem: found.problem.Stop and report a problem: found.problem.No
No steps
Keep each item in sheet.rows where found.row_numbers contains item.row_number and save it as matchingRows.Keep each item in sheet.rows where found.row_numbers contains item.row_number and save it as matchingRows.
Show in the output: found.summary.Show in the output: found.summary.