About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Best answer

Filtering trigger from Gsheet to Slack message [Unique_Count]

H

Hello !

I'm using a Zap to send an automatic message in Slack once a certain status is triggered in my Gsheet, i.e : Status which represent the status of my prospect engaged in my new outreach campaign. 

 

The problem is that this status has multiple item in my sheet but I only want to keep one item.

More concretely I'm sending a message in Slack once a new campaign is launched.

But one campaign means more contact in it.

I just want to send one message per campaign instead of one message per new contacts enrolled in my campaign.

My current filter is set on “only continue if” status = “campaign launched” … But in reality the most accurate filter would be something like “only continue if” status = “unique_count of campaign launched per company” … 

In the screenshot below, you can see that I get 3 messages because 3 new contacts has been enrolled in the same campaign, but I only want to keep one message.

A kind of “Count_UNIQUE” filter … 

Any idea ?

icon

Best answer by Herr_Fi 25 July 2022, 20:39

View original

4 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @Herr_Fi 

Good question.

You may need to try using another tab in the GSheet with formulas for UNIQUE: https://support.google.com/docs/answer/3093198?hl=en

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
rachael.silvano
Userlevel 5
Badge +7

Hi there @Herr_Fi - thanks for coming by the Community with your question! I see that you also opened a ticket with our pals in Support, which is perfect. To help others who may come to this thread in the future, I’ll copy their response here: 

 

To ensure that only one message per campaign launch is sent, I'd recommend adding a worksheet to the existing spreadsheet with a column labeled "campaign name". 
 
Then, you can add a "Find or Create New Row" action after the trigger using the campaign name to find an existing row or create a new row for that campaign. After the Find or Create Row/Record Step, add a Filter. The Find or Create Row/Record Step will return a value called Zap Data Was Found
 
Set the Filter to only continue the Zap if the Zap Data Was Found field is (boolean) is false, meaning that we haven’t seen this record before.
 
More info about this workaround can be found here: https://community.zapier.com/featured-articles-65/how-to-stop-duplicate-triggers-from-running-your-zap-9614

 

If that did the trick, let us know! If not, I’d follow up with the Support ticket you created, they can definitely help you out as well. 

 

Best,

Rachael

H

Hey @Troy Tessalone & @Rachael S , Thanks for your prompt feedback 😃

I’ve made it easier, just by creating another WF with the unique status using a Query. 

UNIQUE is not very useful here as it will not allow to select only defined rows plus, first_name and last_name is always changing. 

Here is the Query if needed : “=UNIQUE(QUERY(Status!A2:G8000,"SELECT A,B,F",0))”

Best,

Arnaud

 

jesse
Userlevel 7
Badge +9

Hey @Herr_Fi thanks so much for coming back to this thread and sharing your solution! We’ll go ahead and mark is as the best answer. 🙂 If anything else comes up, feel free to start a new thread and we’d be happy to help!

Reply


Terms & Conditions