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 ?
Best answer by Herr_FiView original
You may need to try using another tab in the GSheet with formulas for UNIQUE: https://support.google.com/docs/answer/3093198?hl=en
@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:
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.
@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))”
@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!