GPT for Google Sheets: how to use ChatGPT in Sheets (no script)

To use GPT in Google Sheets without writing a script, install an AI add-on that exposes a =GPT() style formula or a sidebar, write your prompt once, reference columns by header (for example {{Company}}), and run it across your rows. You do not need Apps Script and, with managed tools, you do not even need an OpenAI API key. The add-on calls the model and writes the result back into a column. For bulk work across thousands of rows, a server-side add-on is the reliable choice, because in-cell custom functions hit the Apps Script six-minute limit and recalculate on every edit. Here is how to set it up, what it costs, and the trade-offs.

What "GPT for Google Sheets" means

It means calling OpenAI's GPT models (or other models) from inside a spreadsheet to generate, classify, extract, or clean text, without leaving Sheets and without copy-pasting into a chatbot. There are two common shapes:

• In-cell formula. Something like =GPT("summarise", A2) typed into a cell. Convenient for a few rows.
• Sidebar or agent add-on. You write one prompt in a panel, map it to your columns, and it runs server-side across the whole range.

Both use the same underlying mechanic: take the row's values, drop them into your prompt, send to the model, write the answer back. The difference is where the call runs and how it scales.

How to use GPT in Google Sheets without a script

1. Install an AI add-on from Extensions, Get add-ons (ReplyLabs, GPT for Work, and similar all install this way).
2. Open it with Extensions, [add-on name], Open sidebar.
3. Select the range you want to process.
4. Write your prompt and reference columns by header, for example "Summarise {{Notes}} in one sentence."
5. Check the cost preview, then click Run. Output lands in a new column.

No Apps Script, no UrlFetchApp, no key management if you use a managed catalogue. ReplyLabs includes OpenAI's GPT models alongside Anthropic, Google and Mistral, so you can pick the model per task. For the formula-specific walkthrough, see how to write an AI formula in Google Sheets.

Do you need an OpenAI API key?

It depends on the tool. Managed add-ons (including ReplyLabs) include access to GPT models, so you can run prompts immediately with no key, paying the tool's per-row rate. Bring-your-own-key (BYOK) tools route the call through your own OpenAI account, so you pay the provider's raw rate plus, on some tools, a small platform fee per million tokens.

• No key (managed): fastest to start, predictable per-row pricing, no provider account needed.
• BYOK: cheaper at high volume, but you manage the key and your own provider billing.

ReplyLabs supports both: a managed catalogue out of the box, and BYOK on higher tiers so the AI step runs at your provider's raw rate. Compare approaches at GPT for Sheets alternatives.

Why an in-cell =GPT() formula stalls at scale

An in-cell =GPT() works for a handful of cells, then hits three walls on larger ranges:

• The six-minute limit. Apps Script kills any execution that runs longer, so a few hundred rows can fail mid-run.
• External-call quota. UrlFetchApp is rate-limited per day, which a real list exhausts quickly.
• Recalculation storms. Sheets re-runs custom functions on edit, so the model is called again and you are billed again.

A server-side add-on dispatches rows in parallel outside the spreadsheet, so none of these apply. That is why, past a few dozen rows, a sidebar that batches the work beats an in-cell formula. For the bulk mechanics, see bulk AI in Google Sheets.

How to write GPT prompts that work across a column

A prompt that nails one row in ChatGPT often breaks across a thousand rows in a sheet, because the data is messier than your test. Four habits help:

• Reference columns by header. Use {{Company}} or {{First name}} so the right value is substituted per row.
• Handle blanks. Add "If {{Notes}} is empty, write a short generic summary" so the model never invents data.
• Lock the format. Ask for "one sentence" or "exactly one of: Yes, No" so output is easy to filter.
• Show one example. A single worked example anchors tone and length better than adjectives.

These hold for any model, GPT included. They matter more in a sheet because you cannot read every output, so the prompt must be right before you run.

What GPT in Google Sheets costs

Cost depends on the model and your row count. Managed tools mark up the provider's raw rate; BYOK pays the raw rate plus any platform fee. ReplyLabs prices AI at the provider's raw cost times 1.25, plus a $0.0025 base fee per succeeded row, and only succeeded rows are charged. A 1,000-row run on a small GPT model lands in low single-digit dollars, and the exact figure shows in the cost preview before you commit. New accounts start with $20 in free credit. To model a run, use the AI cost calculator.

A worked example: classify 500 inbound replies

Say you have 500 inbound email replies in a column and want each tagged as Interested, Not now, or Unsubscribe.

1. Select the column of reply text.
2. Write the prompt. "Read this reply: {{Reply}}. Classify the sender's intent. Reply with exactly one of: Interested, Not now, Unsubscribe. No other text."
3. Sample the first twenty rows and confirm the labels are right.
4. Run the full 500. Labels stream into a new column.
5. Filter by label and act on the Interested rows first.

Because the output is a clean column, everything you would normally do to a column still works: filtering, conditional formatting, or a pivot to count each label.

Common questions

Can I use ChatGPT in Google Sheets without coding?

Yes. Install an AI add-on, write your prompt in the sidebar, and run it across your rows. No Apps Script, and with a managed tool no API key. ReplyLabs includes GPT models in its managed catalogue.

Is there a real =GPT() formula in Google Sheets?

Several add-ons expose one, and it works for small ranges. For bulk work it is less reliable than a server-side sidebar, because in-cell custom functions recalculate on edits and hit the Apps Script six-minute limit. ReplyLabs runs from the sidebar on purpose to avoid both.

Will GPT formulas time out on large sheets?

In-cell ones can, because Apps Script kills executions over six minutes. Server-side add-ons run the model outside the spreadsheet, so thousands of rows are normal.

Do I have to pay OpenAI separately?

Not with a managed tool, which bundles model access into its per-row price. With BYOK you pay OpenAI directly at the raw rate. ReplyLabs supports both. See how AI prompts work.

What is an AI prompt in this context?

It is the instruction template you write once and the add-on applies to every row, with column values substituted in. See the AI prompt definition.