Join the Community

Issue with Storing AI Output in Clay Table Column for Job Descriptions | Clay

Issue with Storing AI Output in Clay Table Column for Job Descriptions

·

Hi! I’m running into an issue where my AI output doesn’t store inside a column. (Walkthrough of the problem here) Context: I am trying to clean up a job description using AI and make it so the output is stored in a text column. Steps taken:

1.
Created a table to “find jobs” and got 86 Linkedin job URLs
2.
I ran Zenrows Scraper to extract the job description from the Linkedin job URLs — which generated a Bodytext
3.
I created a “Job Description Cleaner” column using OpenAI — I then created a custom prompt, bascially asking to clean and format the job description following a specific structure. Then, I added the “Zenrows Scraper” output inside the prompt, as the “job description” to clean.
4.
STUCK HERE — I selected Output format > Fields > Job_Description > Text. The problem is that I can’t seem to store that output inside a column inside my Clay Table.

Anyone here that ran into the same issue and found a fix?

33 comments

Channeled
APP
·
·
To ensure your AI output stores correctly in your table column, try these steps: 1. Right-click the column you want to edit 2. Select "Edit Column" > "Select Data Type" 3. Confirm that "Text" is selected as the data type 4. Click "Save Settings"When defining column outputs for AI integration, make sure: ** You've properly selected "Fields" as your output format ** Each field corresponds to a specific column in your table * The data type (Text in your case) matches the content you're trying to storeBy default, fields will return responses as Text unless another data type is specified. Double-check that your output field is properly mapped to store the AI's response effectively in your workflow. Sources: Mistral integration overview | Documentation | Clay University Use AI integration overview | Documentation | Clay University Select Column Data Type
Channeled
APP
·
·
Looks like you're still looking for help. We're escalating this over to our support team and someone should be in touch soon. In the meantime, feel free to include any other information that may be helpful in solving your issue!
Owen C.
·
·
Hey Ismael, thanks for reaching out. Looking into this now. :)
Ismael G.
·
·
Thanks Owen! If you need my table URL, here it is: https://app.clay.com/workspaces/466744/tables/t_6jVCDmgrPvuF/views/gv_FazjvFovotdW
Owen C.
·
·
Of course, sweet thank you! Just to confirm the problem is that you're unable to map one of the outputs into it's own column? You should be able to click into any of the cells that has ran with this AI and hover over the desired output and select "Add as column" as shown in the video below. Let me know if this is what you're trying to solve for!
Channeled
APP
·
·
Ismael G.
·
·
I’m a noob, my bad! Thank you so much, just started using clay for my SaaS yesterday and already got so much out of it. Our outreach game will be soooo good now
Owen C.
·
·
No worries at all Ismael! Of course, I'm so glad to hear this, let us know if you have any other questions or concerns. :)
1
Ismael G.
·
·
And now that I’ve uploaded the decision makers from these companies, I created a Find People table, and I want to use my Job Listing table to write to the Find people table. But I can’t seem to insert the field inside the table
Owen C.
·
·
Got it, that's because "field0" seems to be a single value instead of a JSON list. You can click "+Add" as shown in the image below. This will prompt two new areas where you can select a column within your current table and choose where to map it into the new table. Would also recommend checking this out: Clay University Write to Table for a video explaining the process. Hope this helps! Let me know how else I can assist here! :) https://downloads.intercomcdn.com/i/o/w28k1kwz/1349334841/d84df71a363fbcbf979853ba141b/CleanShot+2025-01-23+at+17_22_58%402x.png?expires=1737673200&signature=955416bb336df0ae602c5e7cba09507ac06f6aef3710a275c86a3c0322e1a7d5&req=dSMjH8p9mYlbWPMW1HO4zSfEPXCrRASMVmzG0vOSTlhhdvvgvz%2B75UAF5Yrg%0AdMgf%0A
Ismael G.
·
·
Gotcha! Thanks. Just to make sure… cause the video seems a bit outdated. Should I generate prompt from the JSON schema?
Ismael G.
·
·
Oh I think I figured it out.. But now I’m running into a new issue lol. Is it possible to map those based on the company fields?
Ismael G.
·
·
Table #1 : Freelance Copywriter Jobs Field0 = job description Company Domain = company url Table #2 : Freelance Copywriter Jobs - People Field0 (2) = job description Company Domain = company url I’m trying to paste the job descriptions from Table #1 to Table #2, as I will use the “people” table for my outreach, but I would like a column with the job description from the Table #1. I think it should work, as it’s pretty similar to a V lookup
Ismael G.
·
·
The only thing is that there are less rows in Table #2, as the find people feature skimmed my list a little.
Owen C.
·
·
Ah, if you’re looking to map this data to a specific person in a separate table, I’d recommend creating a "Lookup Single Row" enrichment in the people table. You can use the company domain as the unique identifier to pull all associated information from the corresponding row in the company table into the contact table. Then, clicking into the cell details in this column you can map the associated data from that company into this people table. Give this a try and use the same inputs. Let me know how this goes! :) https://downloads.intercomcdn.com/i/o/w28k1kwz/1349352521/702de6601d628bc033517ca2df47/CleanShot+2025-01-23+at+17_40_41%402x.png?expires=1737674100&signature=5c46dae7bde537d5a0ae693e760776bd1474342b02bd6fbde066ea4f8e5881a4&req=dSMjH8p7n4RdWPMW1HO4zfCGu8gHfPsZ5GT0SKCJXVLwrFx6o3ogNEz1aA%2Fs%0ABLdk%0A
Ismael G.
·
·
Thank you, I’m trying to add the Field0 (to add the job description) in my People table. I’m not sure I understand the row value tho
Owen C.
·
·
Of course! Row value is the data in your current table that you like to compare against the Target column in the table you are pulling data from. Since the field containing each job description is mapped into it's own column, using this will allow you to pull that data into the people table and achieve the desired result.
Ismael G.
·
·
Ismael G.
·
·
Weird
Ismael G.
·
·
Owen C.
·
·
Ah apologies for the confusion, try switching both the target column and the row value to company domain and retrying. :)
Ismael G.
·
·
And this will do what exactly? How will it give me the job description if all I have is the company domain?
Ismael G.
·
·
All i put as values are the company domain**
Ismael G.
·
·
Got it!! Awesome
Ismael G.
·
·
I had to then copy as column
Ismael G.
·
·
That’s weird. So in my people list, I got people that aren’t even from the companies
Ismael G.
·
·
It’s like the “find people at these companies” feature gave me different people
Owen C.
·
·
It is using the company domain to correspond a row within the people table to a row within the company table. Given there could be multiple people from the same company that is hiring, we need a way to associated each contact in the people table to a single company in the company table. The company domain is purely used a unique identifier in which we use to correspond pieces of data and then the lookup aspect pulls all mapped data from the company table.
Owen C.
·
·
This seems to be because the website (https://www.transperfectlegal.com/) is a parent website or an associated website with (https://www.transperfect.com/). If you visit both of these websites you'll see that they're associated with the same company, just the domains appear to be different.
Ismael G.
·
·
Oh I see, thanks for your help. That is all I needed. Have a great day!
Owen C.
·
·
To avoid this, you could use their LinkedIn Company URL as the unique identifier (in place of company domain). However this would require you to enrich the company profile using their URL. Hope this helps, feel free to reach out with any other questions or concerns. :)
1
Channeled
APP
·
·
Hi Ismael G.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:
Channeled
APP
·
·
Thank you so much for sharing your feedback Ismael G.!