Splitting Long Texts and Handling Empty Columns in AI Generated Sentences

·

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

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 😉
Olav B.
·
·
https://app.clay.com/workspaces/184504/tables/t_nTkxVTwv8BjZ/views/gv_lIRWZIchGnv7##
Clay Team
APP
·
·
Hey Olav!! Take a look.
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)
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)