=GPT_SUMMARIZE() — condense long text in a cell
=GPT_SUMMARIZE() turns long text — reviews, call notes, article drafts — into a short summary, in the format you choose. By default it returns three sentences. Part of GPT for Sheets.
Syntax
=GPT_SUMMARIZE(text, [format])
| Parameter | Required | Description |
|---|---|---|
text |
yes | The text to summarize — a string or a cell reference. |
format |
no | The shape of the summary, e.g. "two sentences", "up to 100 words". Default: "three sentences". |
Examples
Boil each customer review in A2 down to one line for a report:
=GPT_SUMMARIZE(A2, "one sentence")
Summarize sales-call notes for a CRM field with a word budget:
=GPT_SUMMARIZE(A2, "up to 50 words")
Turn a long article draft into bullet points:
=GPT_SUMMARIZE(A2, "3 bullet points")
Default format — three sentences:
=GPT_SUMMARIZE(A2)
Tips
- The
formatargument is free text — “one tweet”, “TL;DR in plain English”, “an executive summary” all work. - Summarize first, then run =GPT_CLASSIFY() on the summary column — shorter inputs classify more consistently.
- Drag the formula down to summarize a whole column of feedback, then use Replace all GPT formulas with results in the sidebar so the summaries stop re-running.
Related functions
- =GPT_EXTRACT() — pull specific values instead of a summary
- =GPT_APPLY() — rewrite text with any instruction
- =GPT_CLASSIFY() — sort summaries into categories
Try it
=GPT_SUMMARIZE() ships with GPT for Sheets — no API keys needed. Install the add-on from the Google Workspace Marketplace.