DocGPT.ai Docs

=GPT() — generate text with AI in a cell

=GPT() is the core function of GPT for Sheets. It sends a prompt to the model and returns the answer into the cell. Drag the formula down a column to run the same prompt against every row — that is how bulk generation works.

Syntax

=GPT(prompt, [value])
Parameter Required Description
prompt yes The instruction for the AI. A string or a cell reference.
value no Extra input appended to the prompt — usually a cell with your data.

Examples

Write a product description from a product name in A2:

=GPT("Write a 40-word product description for", A2)

Combine several cells into one prompt:

=GPT("Write a cold-email opening line for "&A2&", who works at "&B2)

Fix grammar in a column:

=GPT("Fix grammar and spelling, return only the corrected text", A2)

Tips

  • Put the instruction in row 1 once and reference it: =GPT($D$1, A2) — change the prompt in one place, refresh the whole column.
  • Be explicit about the output: “return only X, no explanations” keeps cells clean.
  • After generating, use Replace all GPT formulas with results in the sidebar so Sheets does not re-run formulas on refresh.
  • No API key is needed — models are built in. To switch models, use =CLAUDE(), =GEMINI(), =MISTRAL() or =PERPLEXITY() with the same arguments.

Try it

Copy the GPT for Sheets template with ready-made examples, or install the add-on.