Desk Survival · Tested on camera

ChatGPT For Google Sheets: What A Free Account Actually Gets

The Juno Desk · 6 min read · Hands-on, July 2026

Every tutorial gives you the same three clicks to install ChatGPT's sidebar in Google Sheets. We did exactly that, on a real free account. Then we finished the job anyway — twice, for free, without an add-on.

TL;DR: Searching the Google Workspace Marketplace for "ChatGPT" from a free personal account returned 154 add-ons and none published by OpenAI. The task still gets done two ways: upload the sheet to ChatGPT and let its Python tool compute the answer, or skip AI entirely and use SUMPRODUCT with TRIM. Both land on the same correct number.

The job, and why it is harder than it looks

Five rows of sales data. Three columns: Region, Status, Amount. The question your manager asked is one sentence long — what did the North region close? — and the formula for it is the first one anybody learns:

=SUMIFS(C2:C6,A2:A6,"North",B2:B6,"Closed")

It returns 300. The correct answer is 600. Nothing is broken, no error appears, and the number looks entirely plausible — which is exactly what makes it dangerous. One of the North rows has "Closed " with a trailing space, invisible in the cell, invisible in the formula bar unless you go looking for it.

300 vs 600
Same sheet, same formula, one invisible character. SUMIFS compares text criteria literally — it does not trim whitespace for you. We measured this in a live Google Sheet, not from memory.
A formula that errors out is a nuisance. A formula that quietly returns half the real number is a career event.

What happened when we installed the sidebar

The published instructions are consistent everywhere: Extensions → Add-ons → Get add-ons, search "ChatGPT", install. So we opened a logged-in free personal Google account and did it on camera.

The search returned 154 results. We went through them. None were published by OpenAI. Searching "OpenAI" instead did not surface an official one either. What the marketplace actually offers is a field of third-party developer add-ons that call an AI model on your behalf — most wanting an API key, a paid tier, or both.

To be precise, because it matters: OpenAI's own documentation does describe a ChatGPT integration for Excel and Google Sheets. We are not claiming it does not exist and we are not calling anything fake. We are reporting one specific, checkable thing: what a normal free account sees when it follows the public install steps. Those are different claims, and the gap between them is the whole story.

Why the gap exists

Feature announcements are written about the product. Tutorials are written about the announcement. Neither is written about your account. Rollouts are staged, integrations are frequently tied to paid or business tiers, and "available" in a launch post rarely means "available to everyone, today, on the free plan."

The practical consequence is not that you were lied to. It is that you can burn twenty minutes installing something, hand your spreadsheet to a stranger's add-on, and still not have the number your manager asked for.

Method 1 — Let ChatGPT run real Python on your file

This is available on the free tier and needs no add-on at all. Rather than trying to put ChatGPT inside Sheets, take the sheet to ChatGPT.

  1. In Google Sheets: File → Download → Microsoft Excel (.xlsx), or connect Google Drive from inside ChatGPT and pick the file directly.
  2. Attach the file to a new chat.
  3. Ask for the total and ask it to account for messy text — the second half of that sentence is the part that saves you.
Using the attached spreadsheet, total the Amount column for rows where Region is North and Status is Closed. Before you total: strip leading and trailing whitespace from the text columns and treat the comparison as case-insensitive. Tell me how many rows matched, which rows you excluded, and whether any cell had hidden whitespace. Show the code you ran.

It does not guess at the answer — it writes and executes Python over the actual file, so the total is computed rather than predicted. The instruction to show the code and the excluded rows is what turns a plausible number into a checkable one.

Method 2 — The formula fix, no upload, no connector

If the data cannot leave the building, or you simply want it fixed inside the sheet, one formula does it:

=SUMPRODUCT((A2:A6="North")*(TRIM(B2:B6)="Closed")*C2:C6)

Each comparison produces TRUE/FALSE, multiplication turns those into 1/0, and SUMPRODUCT adds up only the surviving amounts. The difference from SUMIFS is the single word TRIM: it strips the invisible spaces before the comparison happens. Same sheet, same data — now it returns 600.

TRIM
The entire fix. Wrap the text range being compared, not the amount range. Works in Google Sheets and Excel alike.

The habit that catches both versions of this

Notice what actually separated the method that worked from the method that did not. It was not intelligence, and it was not the tool. In both working methods, something normalized the text before comparing it — ChatGPT because we told it to, the formula because TRIM is doing it explicitly. SUMIFS failed because nothing did.

So the habit is small and boring: when a total comes back lower than you expected, do not re-read the formula first. Check whether the thing being matched is really the string you think it is. =LEN(B2) against the character count you expect will find a trailing space in four seconds.

The two-question checklist for any "new AI feature"
  1. Can I see it in my own account, on my own plan, right now? Not in the announcement, not in a screenshot, not in a tutorial recorded on someone's business tier. If the answer is no, treat it as unavailable until it is.
  2. Can I check the answer by a second, independent route? A number produced by an AI tool and a number produced by a plain formula should agree. When they do, you can ship it. When they do not, you have learned something more valuable than the total.
✓ Verified hands-on, free account

Get the full prompt pack.

Every prompt in this guide plus 13 more office situations — copy, paste, done.

Also in Desk Survival: Clean messy Excel data with AI — without learning a single formula.