Clay Icon
Join the Community
02 Support

Splitting Long Texts and Handling Empty Columns in AI Generated Sentences

Avatar of Olav B.Olav B.
·
·

I have two problems. Many of my bodytexts are too long. Can you split the text if it exceeds a certain lenght? Second question: I have given AI two columns to use for personalized sentence. It says "Missing output" if one of them are empty. I have tried to comand it to use only one of them if the other is empty. Can anyone help? 🙂

5 comments

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    Hey hey! Can you drop the URL for your table here? (if applicable) 🫶 Don't worry, only admins will be able to open your table 😉

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    Hey Olav!! Take a look.

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    I see now, it looks like in the prompt they're also "required to run" as you can see in the toggle option in the screenshot below. To ensure it runs with whatever is available they can be toggled 'off' so they're optional inputs and the conditional formula you added should also help in the process.

    d5cd6cb0-8fc1-4b99-b90c-0b34dbcdc07d.png(25 kB)
  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    To get around the cell size issue, you can also give chatGPT the Body Text directly, from the nested values in the Scrape Website column.Hope this helps!

    0f41822d-c28b-4e46-9f07-9d1378ef8ed0.png(44 kB)