Referencing Claygent Column Across Tables in Company and Person Table

Audrey M. · 2024-02-29 13:40:54.661127+00

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

Referencing Claygent Column Across Tables in Company and Person Table | Clay

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 Team
APP
·
·
Hey there Audrey sorry for the delay taking a look.
Clay Team
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 Team
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 Team
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 Team
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
Loading attachments
Audrey M.
·
·
it is on this table: https://app.clay.com/workspaces/219706/tables/t_JIjMj0VNJUEZ/views/gv_DaKdZbQzKJlN
Clay Team
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 Team
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

21 comments