Count rows by column
Allows you to count the total rows in a specific column of a spreadsheet, applying optional filters such as exact matches or non-empty values.
Google Sheets Action
This integration allows you to automate the counting of rows in a specific column of your Google Sheets spreadsheets, applying optional filters such as exact matches or non-empty values. This simplifies data management and analysis without the need for manual intervention.
Upon executing this action, you'll receive detailed information, including the total number of rows, the number of matching rows, and the percentage of matches, which you can use in your automated tasks to optimize processes and enhance efficiency in data handling.
Customization Options
Configurable fields you can adjust in your automation
- URL of your sheet document
- Exclude first row
- Sheet Number
- Filter: Column
- Filter: Type
- Filter: Value
Information provided
When executed, this operation delivers the following data, which can be used in the same automatic task.
Tags
- Total rows {{total_rows}}
- Total match rows {{total_match_rows}}
- Percent match rows {{percent_match_rows}}
Let's talk
Choose day and time.
We share the screen and answer all your questions.