Find matching rows in a spreadsheet
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.
Apps it connects
Authenticate each one once and the workflow is ready to run.
What it does
Each integration step this workflow runs, in order, what it is for, and the conditions and loops that decide when it runs.
- 1Google SheetsRead rowsReads every row of the tab each hour, keyed by its column headings and with no cap, so rows added at the bottom are always searched.
How it works
What happens on each run, in plain English.
Every hour, one tab of a Google Sheet is read in full and the rows you are looking for are picked out: every row on it, the rows where one column holds a given value, or the rows where that column is still empty. A match ignores capitals and stray spaces, and a row with nothing in it is skipped.
What it finds is listed on the run page and handed to whatever step you add next, such as a message for each row or an update that marks it done. On its own it changes nothing in the sheet and sends nothing.
A column heading the tab does not have fails the run and names the headings it does have, so a renamed column is noticed rather than passed off as an hour with nothing to find.
You May Also Be Interested In
Save matching emails to a spreadsheetSaves each new Gmail message that matches your search as a row in your spreadsheet, and never saves the same message twice.Forward emails that mention a keywordForwards each new Gmail email that mentions one of your keywords to the address you choose, as soon as it arrives.
Gmail alerts in SlackPosts the emails that match your subject, sender or label filters into a Slack channel as they arrive.
Answer Telegram questions from the web, with sourcesAnswers questions asked in a Telegram chat by searching the web, and replies with the answer and the pages it came from.
Start from a workflow that already works.
Add "Find matching rows in a spreadsheet" to your workspace, connect its apps, and make it yours. No credit card required.
Free plan available · No credit card required