Automating Lead Response Tracking in HeyReach Webhook for Clay | Clay

Automating Lead Response Tracking in HeyReach Webhook for Clay

Hi All, I need help with a HeyReach to Clay webhook. I want to pull through the response from the lead, however I can't know when in the sequence the response will be, the recent messages can be as many as 7+. This is because we send follow ups if they don't respond. So the lead might respond straight away (2 messages total) or after we send 5 messages (6 messages total)- I have a table where I extract the reply and run an enrichment to categorise it (interested, not interested etc). Is there a way I can add a column automatically based on 'is reply: true'?

48 comments

Channeled
APP
·
·
💤 You've caught us outside of our support hours (9am-9pm EST), but don't worry - we'll be back in touch within 24 hours (often sooner!). If you haven't already, please include the URL of your table in the thread below so that we can help you as quickly as possible!
Will Y.
·
·
I've tried to run a formula but I can't get it to only extract the message if the 'is_reply' is true
Will Y.
·
·
This formula seems to be stable, but if there is a better way of doing this then I'm all ears
Muhammad S.
·
·
Write a formula Extract the message field if is_reply field is true and it should see all the 7 fields and will help you extract message where is_reply would be true, does that work? Plain simple JS.
Will Y.
·
·
Yeah I tried that but it wouldn't extract from all of them unfortunately, I tried a few formula variates with no luck
Muhammad S.
·
·
This should work. If you could give me the whole JSON structure of the cell I can write you a formula that will fix
Will Y.
·
·
In the following list / find the messages with the is_reply value 'true' and extract only those message
Muhammad S.
·
·
it works
1
Muhammad S.
·
·
and it should work
Muhammad S.
·
·
BTW, check the one where it is not
Muhammad S.
·
·
there has to some issue with the JSON there
Will Y.
·
·
it's not working on any of them
Will Y.
·
·
they are all the first message I sent, rather than the reply
Muhammad S.
·
·
sweet
Muhammad S.
·
·
Can you change the is_reply to is Reply?
Muhammad S.
·
·
Will Y.
·
·
Same thing, doesn't work
Muhammad S.
·
·
i am going to fix the formula for you
Muhammad S.
·
·
i am seeing an issue
Muhammad S.
·
·
JSON.stringify({{Webhook}}?.recent_messages?.filter(message => message?.['is reply'] === true))
Will Y.
·
·
brilliant thank you. The is_reply should be true btw
Muhammad S.
·
·
try this
Will Y.
·
·
still not working, pulls through the first message, not the reply
Will Y.
·
·
Will Y.
·
·
I have a meeting at half bast fyi if I go radio silent
Muhammad S.
·
·
its ok, did you try clicking output is correct, save formula?
Muhammad S.
·
·
if it still does not work, create a new formula field and past the formula there
Muhammad S.
·
·
if still does not work, DM me , i will let you know how to get the JSOn structure and once you get me the JSON structure I will give you exact formula
Will Y.
·
·
yes, but that still didn't work

Muhammad S.

JSON.stringify({{Webhook}}?.recent_messages?.filter(message => message['is reply'] === true).map(message => message.message))

please try this last one

Muhammad S.
·
·
you are close
Will Y.
·
·
output for the last 2

Muhammad S.

JSON.stringify({{Webhook}}?.recent_messages?.filter(message => message['Is Reply'] === true).map(message => message.message))

Muhammad S.
·
·
Made a slight change that could potentially make a big difference
Will Y.
·
·
nah that's not working
Muhammad S.
·
·
lol
Will Y.
·
·
I think I've figured out a way
Muhammad S.
·
·
great
Will Y.
·
·
Insted of formula, I'm using 'ask question'
Will Y.
·
·
Muhammad S.
·
·
It uses a credit.
Will Y.
·
·
I have open AI
Muhammad S.
·
·
sweet
Will Y.
·
·
Thanks for the help though
Muhammad S.
·
·
ofc
Arturo O.
·
·
Hey Will, thanks for the inquiry, happy to look into it! Do you mind sending the link to the table so we can take a look? https://downloads.intercomcdn.com/i/o/1171717996/ac7729f84b426e1d0358af02/image.png?expires=1727114400&signature=7cce0a4092811854dd3f1f2168655cc40cf1d76d06dbcb622b353e930dde880f&req=dSEgF85%2FmohWX%2FMW1HO4zYTywCz9B5MS2BKsam%2FhVPsHiA%3D%3D%0A Appreciate you jumping in there as well, Muhammad! Also, quick question, Will. Within HeyReach, what triggers it to send the webhook to Clay? If possible, it would be best to ensure you have a filtered view in that platform where you only see actual replies and on what step, making sure those are part of the values that get imported into Clay to then further analyze.
Will Y.
·
·
Hi Arturo, I've found a good solution which is working for me so no need to work on it now but thanks
Channeled
APP
·
·
Hi Will Y.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: