Clay Icon

Referencing Claygent Column Across Tables in Company and Person Table

ยท
ยท

I have a company table with a Claygent column and I want to reference the column from a Claygent in the matching person table. But it doesn't seem to be an option

  • Avatar of Audrey M.
    Audrey M.
    ยท
    ยท

    Also please look at my Outreach Email Content column. It doesn't seem to work as I thought

  • Avatar of Clay T.
    Clay T.
    APP
    ยท
    ยท

    Hey there Audrey sorry for the delay taking a look.

  • Avatar of Clay T.
    Clay T.
    APP
    ยท
    ยท

    So you can use the "Lookup Multiple Rows in Other Table" to pull data from one table to another, you will need to make sure that there is matching data point that connects both tables. Here is a video that can help you set that up: https://www.loom.com/share/72f4e67e20424ba7a784ca9a5056f1a9

  • Avatar of Clay T.
    Clay T.
    APP
    ยท
    ยท

    As for you Outreach email Content Column, Chat GPT AI would be more suited for that purpose. While Claygent could perform the function, it is mostly a web scraper and would require a more detailed prompt perform your email action

  • Avatar of Audrey M.
    Audrey M.
    ยท
    ยท

    Can you give me an example of the right kind of prompt for the claygent?

  • Avatar of Clay T.
    Clay T.
    APP
    ยท
    ยท

    Let me search for one

  • Avatar of Audrey M.
    Audrey M.
    ยท
    ยท

    with the chatpgt module, it is returning a subject and a text - how do I add them to 2 different columns?

  • Avatar of Clay T.
    Clay T.
    APP
    ยท
    ยท

    Let me take a look

  • Avatar of Audrey M.
    Audrey M.
    ยท
    ยท

    This is the column I want to bring into the people table. It doesn't show up on any of the lists even with a lookup

  • Avatar of Clay T.
    Clay T.
    APP
    ยท
    ยท

    So to connect the table we need to make sure they both a have a data input in common. For this case we can use the company domain to accomplish this. When setting up this integration we will choose the column from the target table, which will be the domain column. And then set to contains the domain name from the column in current table.

  • Avatar of Audrey M.
    Audrey M.
    ยท
    ยท

    please show me as I have tried a lot already

  • Avatar of Clay T.
    Clay T.
    APP
    ยท
    ยท

    Ok let me make a loom video.

  • Avatar of Audrey M.
    Audrey M.
    ยท
    ยท

    by the way the formula generator is very buggy - it takes a while to be able to type in formula field

  • Avatar of Clay T.
    Clay T.
    APP
    ยท
    ยท

    Thank you for the feedback, I will make sure to bring up the formula generator with the team.

  • Avatar of Audrey M.
    Audrey M.
    ยท
    ยท

    LuisArturo have you got a way for me to split the content from subject and body from the chatgpt column?

  • Avatar of Clay T.
    Clay T.
    APP
    ยท
    ยท

    Hey there Audrey sorry for the delay, let me take a look for you.

  • Avatar of Clay T.
    Clay T.
    APP
    ยท
    ยท

    So quick question which table are you asking for again. I can't seem to find the column