Clay Icon

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

  • Avatar of Channeled
    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!

  • Avatar of Arturo O.
    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!

  • Avatar of Dan
    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: ?

  • Avatar of Arturo O.
    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

  • Avatar of Channeled
    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!

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Hi Dan! This thread was recently closed by our Support team. If you have a moment, please share your feedback: