Skip to main content
Allows you to call the default model from a cell formula.

Inputs

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.
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.
=PROMPT("Extract keywords")
=PROMPT.TOROW("Extract keywords", A1:D10)