COUNT function with Google sheets

[Shreyas Umesh]

Hi Pabbly team,

[1.] I have a complicated workflow to be executed. Wanted to check if Pabbly can do it.

1. Google sheets trigger - on schedule when a new row is created.
2. Check how many times an email ID has appeared in a particular column of the sheet and send the count number back to the dashboard as results.
3. Multiply the number by X
4. Send an email using Gmail.

Step 1, 3 & 4 is possible however I'm confused about how I can get the second step working.
Do I need any steps before or after?

[2.] The count functions from the spreadsheet formulae don't work.

I tried with the example that's been given in your table. They don't generate the correct results. Please check.

 

[Pabbly]

Hi Pabbly team,

[1.] I have a complicated workflow to be executed. Wanted to check if Pabbly can do it.

1. Google sheets trigger - on schedule when a new row is created.
2. Check how many times an email ID has appeared in a particular column of the sheet and send the count number back to the dashboard as results.
3. Multiply the number by X
4. Send an email using Gmail.

Step 1, 3 & 4 is possible however I'm confused about how I can get the second step working.
Do I need any steps before or after?

[2.] The count functions from the spreadsheet formulae don't work.

I tried with the example that's been given in your table. They don't generate the correct results. Please check.

We are looking into this and will update you shortly.

 

[Shreyas Umesh]

Hi Team,

It's been a month and more, haven't received any update on this. Please check.

 

[Pabblymember11]

Hey @Shreyas Umesh

We checked the possibility of using count functions with spreadsheet formulae but as of now it does not seems to be supported.

Further, we have updated the Spreadsheet formula documentation as well. Please check it here - https://www.pabbly.com/spreadsheet-formulas/

 

[Shreyas Umesh]

Got it, thanks for the update.

Is there any way we can do the count of a particular text in a particular column?

 

[Pabblymember11]

We have checked with the technical and unfortunately we won't be able to provide a workaround as of now. In near future, possibly we will be supporting count functions which is needed to full fill your use case of counting a particular text in a particular column.

Thank!

 

[Shreyas Umesh]

Alright, thanks for letting me know.