Clay Icon

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. 1.

    Created a table to “find jobs” and got 86 Linkedin job URLs

  2. 2.

    I ran Zenrows Scraper to extract the job description from the Linkedin job URLs — which generated a Bodytext

  3. 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. 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?

  • Avatar of Channeled
    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

  • Avatar of Channeled
    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!

  • Avatar of Owen C.
    Owen C.
    ·
    ·

    Hey Ismael, thanks for reaching out. Looking into this now. :)

  • Avatar of Ismael G.
    Ismael G.
    ·
    ·
  • Avatar of Owen C.
    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!

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·
  • Avatar of Ismael G.
    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

  • Avatar of Owen C.
    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. :)

  • Avatar of Ismael G.
    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

  • Avatar of Owen C.
    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

  • Avatar of Ismael G.
    Ismael G.
    ·
    ·

    Gotcha! Thanks. Just to make sure… cause the video seems a bit outdated. Should I generate prompt from the JSON schema?

  • Avatar of Ismael G.
    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?

  • Avatar of Ismael G.
    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

  • Avatar of Ismael G.
    Ismael G.
    ·
    ·

    The only thing is that there are less rows in Table #2, as the find people feature skimmed my list a little.

  • Avatar of Owen C.
    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

  • Avatar of Ismael G.
    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

  • Avatar of Owen C.
    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.

  • Avatar of Ismael G.
    Ismael G.
    ·
    ·
  • Avatar of Ismael G.
    Ismael G.
    ·
    ·

    Weird

  • Avatar of Ismael G.
    Ismael G.
    ·
    ·
  • Avatar of Owen C.
    Owen C.
    ·
    ·

    Ah apologies for the confusion, try switching both the target column and the row value to company domain and retrying. :)

  • Avatar of Ismael G.
    Ismael G.
    ·
    ·

    And this will do what exactly? How will it give me the job description if all I have is the company domain?

  • Avatar of Ismael G.
    Ismael G.
    ·
    ·

    All i put as values are the company domain**

  • Avatar of Ismael G.
    Ismael G.
    ·
    ·

    Got it!! Awesome

  • Avatar of Ismael G.
    Ismael G.
    ·
    ·

    I had to then copy as column

  • Avatar of Ismael G.
    Ismael G.
    ·
    ·

    That’s weird. So in my people list, I got people that aren’t even from the companies

  • Avatar of Ismael G.
    Ismael G.
    ·
    ·

    It’s like the “find people at these companies” feature gave me different people

  • Avatar of Owen C.
    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.

  • Avatar of Owen C.
    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.

  • Avatar of Ismael G.
    Ismael G.
    ·
    ·

    Oh I see, thanks for your help. That is all I needed. Have a great day!

  • Avatar of Owen C.
    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. :)

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Hi Ismael G.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Thank you so much for sharing your feedback Ismael G.!