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:
Created a table to “find jobs” and got 86 Linkedin job URLs
I ran Zenrows Scraper to extract the job description from the Linkedin job URLs — which generated a Bodytext
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.
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?
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
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!
Hey Ismael, thanks for reaching out. Looking into this now. :)
Thanks Owen! If you need my table URL, here it is: https://app.clay.com/workspaces/466744/tables/t_6jVCDmgrPvuF/views/gv_FazjvFovotdW
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!
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
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
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
Gotcha! Thanks. Just to make sure… cause the video seems a bit outdated. Should I generate prompt from the JSON schema?
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?
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
The only thing is that there are less rows in Table #2, as the find people feature skimmed my list a little.
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
