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

21 comments

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