Ensuring Numerical Output in Generated Prompts

·Jul 18, 2025 10:12 PM·

In the generate prompt, is there a way to really for the resulting value to be a numerical field? I tell it specifically, and it makes a JSON instead.

1 comment

· Sorted by Oldest

Clay
APP
·
·
Yes, you can force the resulting value to be numerical by using Define column outputs in your AI prompt. When setting up column outputs, change the field type to Number - this ensures the AI returns numerical values that can be used for calculations and comparisons. The Number data type allows numerical values to be entered and is ideal for measurements like lead scores or revenue.
Sources: Gemini: Generate text with Google Gemini ChatGPT: Generate text with OpenAI/GPT Mistral integration overview | Documentation | Clay University Table columns | Documentation | Clay University
1

Clay
APP
·
·
Yes, you can force the resulting value to be numerical by using Define column outputs in your AI prompt. When setting up column outputs, change the field type to Number - this ensures the AI returns numerical values that can be used for calculations and comparisons. The Number data type allows numerical values to be entered and is ideal for measurements like lead scores or revenue.
Sources: Gemini: Generate text with Google Gemini ChatGPT: Generate text with OpenAI/GPT Mistral integration overview | Documentation | Clay University Table columns | Documentation | Clay University
1