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.
Best answer
Count number of users in a Google Sheet automatically to trigger new flow?
Best answer by Troy Tessalone
Hi
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.
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+14- Zapier Expert
- 31350 replies
- Answer
Hi
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.
⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
1 person likes this
thank you!
- Beginner
- 17 replies
I think this can be a starting point:
https://www.techjunkie.com/see-who-viewed-google-doc/
https://gsuitetips.com/tips/sheets/view-your-activity-dashboard/
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.