Integrating Heyreach and Clay for Hubspot Activities: Concatenation Help

Hey we are using heyreach and a webhook to push the messages sent into clay. In turn the clay table is using a HTTP POST to write the contents of the message into a Hubspot Activity (Logged LinkedIn Message). At the moment this works for the last message received but not the messages sent, or multiple messages received. Just wondering if there is a easy way to concatenate all of the messages into a single activity, or use some type of Array to tell Clay to push the latest message in the JSON into the column in the table which represents the body of the activity in Hubspot. Table: https://app.clay.com/workspaces/260756/tables/t_y666tRFJN46W/views/gv_4hufhwc472zM

6 comments

Channeled
APP
·
·
👋 Hey there! Our support team has got your message - we'll be back in touch within 24 hours (often sooner!). If you haven't already, please include the URL of your table in this thread so that we can help you as quickly as possible!
Arturo O.
·
·
Hey Dan, thanks for the message and details breakdown of your flow, this makes sense! I have here a video showing how to use the formula generator to combine values from different columns or nested fields in a way to concatenate them. https://www.loom.com/share/75cf18efe4bf47979c6b4868d1594e6c?sid=eaae06e6-07c2-4551-91d3-6456d05c5f28 How I would prompt it is to maybe separate each message, if they exist, to separate with a semi-colon or any symbol that would help you identify each one. Of course, you can also prompt it to use other labels if needed. Once you have the expected value in one cell, you can export that out to Hubspot. Let me know if you run into any issues!
Dan
·
·
Hi Arturo im not sure that helps. The messages are created and part of the payload in the JSON. That means for each contact the JSON/Message parameters change every time a new message is sent via the webhook. You can see an example of this in call A12. Each time a message is sent or recieved the JSON is updated with multiple "recent messages" How do we tell clay how to pull the latest message or merge multiple messages together from within the JSON? Is there a prompt to say return the latest message so in our live example Recent Messages > 1 > Message: ?
Arturo O.
·
·
Appreciate the follow up, Dan! It sounds like two separate situations in this case, the potential solution I offered above would help for the specific row in question when pushing to Hubspot. For your "tell clay how to pull the latest message or merge multiple messages together from within the JSON?" question: This sounds like it has to happen from HeyReach itself where you tell them to show you the responses and messages from into a single JSON to then POST it to Clay, since Clay is only catching the payload in the end and has no way to interact with HeyReach beforehand, and it's not a live 2-way sync. I recorded this loom with some thoughts but let me know if you can share a bit more of an overview if there's something else we could include here: https://www.loom.com/share/07bec672f69d4a769471a0223f84dd86
Channeled
APP
·
·
We haven't heard back from you in a bit, so we're going to go ahead and close things out here - feel free to let us know if you still need something!
Channeled
APP
·
·
Hi Dan! This thread was recently closed by our Support team. If you have a moment, please share your feedback: