Skip to main content

Hi, I’m new to Zapier. I’d like to ask how to add a counter that is already implemented in a spreadsheet. The formula in the spreadsheet is the following =COUNTIF(F2:F, K2) I want to count the filtered leads, and i have 2 filters set in zapier, so i guess the counter should be placed below the 2 filters.

 

Hi @DannthemaN 

For us to have more info, post screenshots with how your Zap steps are outlined and configured in EDIT mode.


@Troy Tessalone 

 

 


 


 


 


Hi there @DannthemaN 👋

Am I correct in thinking that you’re wanting to increment one of the values in those four cells in the Google Sheets spreadsheet based on the terminal that’s supplied by the Facebook Lead Ads trigger step? 

If so, you might want to explore using paths for this. Paths by Zapier would allow you to run different actions based on certain rule conditions being met. You could use a Get many Spreadsheet Rows (Google Sheets) action to pull the values from the four rows that would need to be updated. Then you’d have four paths, one you’d set it up to check whether the value in that What Is The Nearest Terminal To Your Location field (from the Facebook Lead Ads trigger) matches WITA. And another path to check it matches TLSA and so on.

Within each path you’d have a Formatter (Numbers > Perform Math Operation) action take the current value in the relevant cell for that terminal’s total number of leads, and add one to it. Then use an Update Spreadsheet Row (Google Sheets) action to update that specific cell with the new lead total. 

Hope that helps to get you pointed in the right direction. If I’ve misunderstood what you’re looking to do here or you run into any trouble on that do let us know! 🙂