Hi everyone,
I’m building a Make scenario where a new lead reply in SmartLead triggers a webhook and sends details to Slack — but only if the lead hasn’t replied in the last 30 days.
Here’s what I’ve set up so far:
Current Setup:
- Trigger:
A custom webhook receives data from SmartLead when a new reply is received. - Step 2:
I use the Search Rows module to look across 3 Google Sheets (Interested,Not-Interested, andNeutral) to check if the lead’s email already exists. - Filtering Logic:
The goal is to only treat the reply as “new” if:
- The lead’s email is not found in any sheet, OR
- Their most recent reply is older than 30 days ago
- I don’t think my filtering logic is correct.
If either condition is true, we move forward and log/send the Slack message. Otherwise, we skip it.
Scenario Image:
What I am trying to do:
I am trying to set up a process where, whenever a new lead responds to a campaign, a webhook is triggered by Smartleads. This webhook will use the lead’s email and check the timestamp on the page to determine if the lead has replied within the last 30 days. It will search across all sheets for any previous replies from the same lead. If a reply is found in any of the sheets, the process will not continue. However, if no replies are found, it will proceed to the next steps.
Here is how the Google Sheet looks from inside. All other sheets are also the same.
So, I need your help to find the solution to it. It would be better if you could send an image of the actual solution in a scenario setting. Also, please reply to it ~ASAP
@