I'm trying to build out an automation that detects when members of a contact list (Claytable) mention key words on their LinkedIn posts. If they do mention these key words, I want to push a slack notification to my sales team. I think I'm like 90% of the way there, but I need a way for the workflow to detect "I've already alerted the team about this post" and to not rerun and push to slack if that post has already been sent to clack. Anyone have any luck building something like this before?
To prevent duplicate Slack notifications, add a column to track notification status. Use conditional formulas with logical operators to only send Slack messages when the post hasn't been processed before. [1]
We have a template for brand mention signals that includes Company and People data monitoring with Slack notifications - you can copy it to see the full workflow structure. [4]
Is that what you were looking for?
Kind of, but I could use some more hands on guidance for my use case
Here's a specific approach for your LinkedIn post monitoring workflow:
Step 1: Add a tracking column
Create a boolean column called "Slack_Sent" in your table to track notification status. [1]
Step 2: Set up conditional logic
In your Slack action, use conditional runs with this formula: Slack_Sent != true AND Keywords_Found > 0 [2]
Step 3: Update tracking after sending
Add a formula column that sets "Slack_Sent" to true after the Slack notification runs. [3]
Step 4: Use Write to Table for post data
If monitoring multiple posts per contact, use "Write to Other Table" to create individual rows for each post with unique identifiers (post URL + date). [4]
This prevents duplicate notifications while maintaining a clean audit trail of which posts triggered alerts.
Did that answer your question?
If you need any further help refining your automation or have more questions about your workflow, I’m here to assist. Would you like to provide more details about what you’re trying to achieve or any specific challenges you’re facing?
