Best answer

Count spreadsheet rows processed

  • 4 October 2020
  • 4 replies
  • 940 views

Userlevel 1

Hi there,

I have a Zap that is looking at a spreadsheet. The trigger looks at this spreadsheet and does some action (like firing an api call). Is it possible to keep a count of number of rows processed at a time?

Example i could add 50 rows today and 70 tomorrow. I am trying to figure out if there is a way for me to track how many rows out of 50 have been processed today and how many got processed tomorrow and send out an email to the admin with the result.

How can i achieve this? Appreciate any help.

 

Cheers

R

icon

Best answer by nicksimard 6 October 2020, 20:24

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

4 replies

Userlevel 3
Badge +1

Is what you are requiring the same as counting how many times the Zap fires in a period?

Userlevel 1

I think so i.e based on my understanding, if the filter criteria is not met, then Zap wont fire. So if there are 10 rows added to the spreadsheet and only 8 met the criteria then the zap count should be 8 but not 10. the admin will will/should get an email that 8 rows are processed

Userlevel 7
Badge +11

@Raghu One way to accomplish this would be to use our Storage app to increment a value by 1 each time a row triggers the Zap. You can learn more about that process in our help docs.

If you’re looking to send the total at the end of the day, you could then have a Zap scheduled to run at a specific time, retrieve the value from Storage then reset it to zero so it can be used again on the following day. Does that sound like what you’re trying to accomplish?

Userlevel 3
Badge +1

@Raghu the above from @nicksimard will work.  But the result is pretty invisible. 

If you are passing the timestamp into the spreadsheet (are you using Google or Excel?) each row has a date.  You could summaries the rows based on date and get a count.  Or you could use Pivot Table report that would be dynamic.

If you need some help with Pivot Tables etc let me know.  

 

But the key for me is... Why do you want to count this?  What will you do with that information?