How to Handle Empty Cells in AI Enrichment Processes

Brian O. · 2025-03-07T20:47:23.130306+00:00

I'm trying to run an AI enrichment where 5 columns (/column_name) are the user prompt (longer context is in the system message). Some cells in the dataset are empty and triggering an error on those rows when I run. I would want it to run even if some inputs are missing rather than triggering an error. How can I do this.

To run an AI enrichment in Clay without triggering errors for empty cells, you can use the "Required to Run" toggle in the Prompt Editor. Here's how: 1. Open the Prompt Editor for your AI enrichment. 2. Identify the fields that must contain data for the enrichment to run. 3. Toggle "Required to Run" next to these fields. 4. Save your prompt configuration. This ensures the enrichment only runs on rows with the required data, skipping empty cells. Additionally, consider testing your enrichment on a small sample (about 10 rows) before running it on the entire column. This helps identify and fix any errors in advance, saving credits and improving results. If you need further assistance, please request human support by clicking on "Talk to a person."

Sources: AI Formulas + Conditional Runs [Clay 101] - Clay University Guide: Ways to save Clay credits | Documentation | Clay University Referencing dynamic data from other columns | Documentation | Clay University

4 comments