GPT
The GPT()
function generates a single AI-powered response in a single cell.
It’s ideal for summaries, messages, explanations, short answers, or any quick one-off prompt.
Formula Syntax
=GPT(prompt, [input], [model])
- prompt(required) : The instruction or question you want the AI to respond to. (e.g., "Create a weekly workout schedule" or "Summarise the benefits of meditation.")
- input(optional): A cell or range used to provide extra context.
- model(optional) : AI model like
gpt-4o
,gpt-3.5-turbo
, orgemini-1.5-pro
. Defaults to your settings if not provided.
Example(s)
Summarise a concept
=GPT("Summarise the benefits of meditation.")
Personalised email using input cell
=GPT("Write a thank you note for the customer below.", A2)
Custom model with dynamic input
=GPT("Suggest a motivational quote based on the theme below.", B2, "gpt-4o")
tip
Perfect for short-form generation tasks like emails, answers, and summaries. For lists or tables, use GPTLIST() or GPTTABLE() instead.