=GPT_APPLY() — run one instruction over your text
=GPT_APPLY() takes a text and a task and returns the transformed text. Without a task it defaults to fixing grammar and spelling — the fastest proofreading formula in GPT for Sheets. With a task, it becomes a general-purpose rewriter you drag down a column.
Syntax
=GPT_APPLY(text, [task])
| Parameter | Required | Description |
|---|---|---|
text |
yes | The input text — a string or a cell reference. |
task |
no | What to do with the text — one cell or a string. Default: "fix grammar and spelling". |
Examples
Proofread user-submitted content in A2 (the default task):
=GPT_APPLY(A2)
Shorten product titles for an e-commerce feed:
=GPT_APPLY(A2, "shorten to under 60 characters, keep brand and model")
Rewrite support macros in a friendlier tone:
=GPT_APPLY(A2, "rewrite in a warm, apologetic tone, keep it under 50 words")
Keep the task in one cell (D1) so you can change it for the whole column at once:
=GPT_APPLY(A2, $D$1)
Tips
=GPT_APPLY(text, task)is=GPT(prompt, value)with the arguments flipped — handy when you map it over an existing data column.- Be explicit about what must not change: “keep brand names and numbers as is”.
- Drag down for bulk edits — up to 10,000 results per hour — then use Replace all GPT formulas with results in the sidebar.
Related functions
- =GPT() — free-form prompt plus value
- =GPT_TRANSLATE() — language translation
- =GPT_SUMMARIZE() — condense instead of rewrite
Try it
=GPT_APPLY() ships with GPT for Sheets — no API keys needed. Install the add-on from the Google Workspace Marketplace.