.png){kind=logo}
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
Also please look at my Outreach Email Content column. It doesn't seem to work as I thought
Hey there Audrey sorry for the delay taking a look.
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
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
Can you give me an example of the right kind of prompt for the claygent?
Let me search for one
with the chatpgt module, it is returning a subject and a text - how do I add them to 2 different columns?
Let me take a look
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
it is on this table: https://app.clay.com/workspaces/219706/tables/t_JIjMj0VNJUEZ/views/gv_DaKdZbQzKJlN
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.
please show me as I have tried a lot already
Ok let me make a loom video.
by the way the formula generator is very buggy - it takes a while to be able to type in formula field
Thank you for the feedback, I will make sure to bring up the formula generator with the team.
LuisArturo have you got a way for me to split the content from subject and body from the chatgpt column?
Hey there Audrey sorry for the delay, let me take a look for you.
So quick question which table are you asking for again. I can't seem to find the column