Count number of users in a Google Sheet automatically to trigger new flow?

Hey guys - I cant seem to figure this out anywhere. How do I count the number of times a user has shown up in order to trigger a new flow (i.e. if a user shows up 1x send x message, if a user shows up 2x send y message?) really appreciate any thoughts.

Page 1 / 1

Hi @joinjade

Some options to consider…

Try Airtable which is a relational database and you can linked records across Tables, plus include a Count field: https://support.airtable.com/hc/en-us/articles/360042807213-Count-field-overview

If sticking with GSheets, then try one of these options…

Add another Tab to the GSheet to use with a GSheets Update Row step (if you’re doing relatively low/infrequent volume for the triggered Zap).
The new tab would have 2 columns INPUT and OUTPUT.

INPUT would be the value you’re searching for.

OUTPUT would be the count of the INPUT value from the other tab with the full data set.

For the OUTPUT use the QUERY or COUNTIF(S) function in the formula.

QUERY: https://support.google.com/docs/answer/3093343?hl=en

COUNTIF: https://support.google.com/docs/answer/3093480?hl=en

COUNTIFS: https://support.google.com/docs/answer/3256550?hl=en

OR

Use this GSheet searches: Find Many Rows
NOTE: The max rows returned is 10.

Then perform some sort of evaluation to determine the count of returned records, possibly using a Code step.