Skip to main content
Allows you to call a model from a cell formula and specify the model as the first argument. This overrides the default model.

​
Arguments

​
providerAndModel
string
required
A string on the form “provider/model” (e.g., “openai/gpt-4o-mini”).The default model is determined by your configuration settings.
​
instructions
string
required
Your prompt - the instructions for the model to follow.Can be a string, a cell reference, or a range of cells.
​
cells
cell reference(s)
One or more cell references or ranges as context for your prompt (e.g., A1, B2:C3, D4).You can provide multiple separate cell references that will all be included as context.

​
Returns

​
response
string
The model’s response as plain text.
Temperature is configured via the ribbon UI. Use the Temperature dropdown in the Model section. This can be either:
  • A number between 0.0 and 1.0
  • A preset string:
    • "Consistent" (0.0) - Deterministic output, same result each time
    • "Neutral" (0.3) - Balanced between consistency and variety
    • "Creative" (0.7) - More varied and creative outputs
Lower values (closer to 0) produce consistent, deterministic responses. Higher values (closer to 1) produce more varied, creative responses.
=PROMPTMODEL("openai/gpt-4o-mini", "Extract keywords")

=PROMPTMODEL.TOROW("openai/gpt-4o-mini", "Extract keywords", A1:D10)