ChatGPT for Google Sheets: OpenAI's add-on, what it costs, and the shared tracker

Riellvriany Indriawan
Written by

Riellvriany Indriawan

Katelin Teen
Reviewed by

Katelin Teen

Last edited November 17, 2026

Expert Verified
ChatGPT for Google Sheets banner, showing ChatGPT working alongside a team's shared spreadsheets
TL;DR

ChatGPT for Google Sheets is OpenAI's own add-on: install "ChatGPT" from the Google Workspace Marketplace, open it from Extensions, and a ChatGPT sidebar builds, edits and explains the spreadsheet you have open. It's free to install on every plan, Free and Go get limited use, and Business and Enterprise pay in credits (OpenAI's rate card puts a typical task at 5 to 20 credits a message).

It's very good at one person's spreadsheet work: a budget from scratch, a broken formula in B145, a messy export cleaned up. It keeps its own chat history, has no memory, and works from the sidebar of the sheet you open.

The spreadsheet a team cares about most is usually the shared one, the tracker everyone asks about in Slack and the numbers someone has to summarise every Monday. That job wants a teammate, not a sidebar. eesel reads the sheets you pick, answers anyone in Slack or Microsoft Teams with the sheet linked, runs the Monday report on a schedule, and what it shares depends on who is asking. If you live in a terminal, Codex or Claude Code can do the setup through the eesel CLI, then ask the agent a test question about your tracker before anyone else does.

What is ChatGPT for Google Sheets?

ChatGPT for Google Sheets is a sidebar inside Google Sheets where you chat with ChatGPT about the spreadsheet you have open, and it reads and changes that sheet for you. OpenAI's help article calls it "a spreadsheet-native AI experience" for "large, multi-tab files with formulas, references, and assumptions".

OpenAI's ChatGPT for Excel and Google Sheets product page, with Install ChatGPT for Excel and Install ChatGPT for Google Sheets buttons beside a spreadsheet and a ChatGPT sidebar explaining a financial model
One product page, two add-ons, as taken from OpenAI

It's newer than most people assume. OpenAI launched ChatGPT for Excel in March, added the Google Sheets version as a beta on 22 April 2026, and made both generally available on 5 May 2026 (OpenAI). The Marketplace listing is published by OpenAI, priced "Free of charge with paid features", and shows over 3 million installs with a 4.7 average from 58 reviews.

Older third-party add-ons with GPT in the name still turn up in Marketplace searches, some asking for your own OpenAI API key. The official one says "By: OpenAI" under the name.

How do you install ChatGPT in Google Sheets?

You install it once from the Marketplace and it appears under the Extensions menu in every sheet. OpenAI's steps:

  1. Install ChatGPT from the Google Workspace Marketplace.
  2. Open a new or existing Google Sheet.
  3. Go to Extensions, then ChatGPT, then Open. The sidebar appears on the right.
  4. Sign in with the ChatGPT account that has your plan.

Google's permission screen asks to "View and manage spreadsheets that this application has been installed in", which is narrower than a full Drive connection.

On a Business or Enterprise workspace there's one more switch. If your workspace uses role-based access control, an admin goes to Workspace settings, Permissions & roles, ChatGPT for Excel and Google Sheets and turns it on, and that one setting covers Excel too. OpenAI notes that on Enterprise the feature is disabled by default until an admin enables it (OpenAI). If your Google Workspace admin restricts Marketplace apps, they'll need to allow it on their side as well.

What can ChatGPT do in a Google Sheet?

It builds sheets from a description, edits existing ones, and answers questions about the data across tabs. OpenAI says it "links answers to the cells it references and updates, preserves your formulas and formatting, and asks for permission before making changes" (OpenAI). The example prompts give you the flavour:

  • "Build a project tracker with owners, deadlines, and status."
  • "Why am I getting an error in cell B145? Explain the formula chain and propose a fix."
  • "Clean up this sheet: standardize formatting, fix inconsistent labels, and remove duplicates."
  • "Group these survey responses by theme and summarize key insights."

Three extras make it more than a formula helper. You can @mention specific tabs to focus it, and it can search the web to pull information in. Skills are reusable playbooks for repeat work; the defaults cover financial modeling and corporate finance formatting, and you can build and upload your own (skills help). And ChatGPT apps from your account carry over, so the listing's own example is bringing in context "from Apps like Gmail, Stripe, Sharepoint, and others", subject to what your admin has enabled.

My favourite tip from OpenAI is the boring one: ask "Before editing, outline exactly which tabs/ranges you'll modify."

OpenAI Help Center article titled ChatGPT for Excel and Google Sheets, noting availability to Business, Enterprise, Edu and K-12 users and to Free, Go, Pro and Plus users, with a table of contents covering install, limitations and pricing
Every plan gets it, with very different usage, as taken from OpenAI Help Center

The three ways ChatGPT reaches Google Sheets

The add-on is one of three OpenAI routes into your spreadsheets, and the other two get mixed up with it constantly.

RouteWhere you workWhat it can do with a sheetWho gets it
ChatGPT for Google Sheets (add-on)Sidebar inside the sheetBuilds, edits and explains the open sheetEvery plan; Free and Go limited
Google Drive app in ChatGPTA normal ChatGPT chatFinds, reads, compares and, where allowed, updates Drive filesDepends on plan, location and workspace settings
Workspace agentsChatGPT, Slack, a schedule or an API callUses Google Drive through the agent's connectionBusiness and Enterprise

Use the Drive app when the question spans files, like OpenAI's example "Compare the two budget spreadsheets I shared last week." My ChatGPT for Google Docs guide covers its admin settings. Use the add-on inside a single sheet. The two don't share history.

Claude has its own routes: a Sheets sidebar (see Claude for Google Docs) and Claude Sheets, a spreadsheet of its own.

And Gemini, which is already in your Sheets

If you pay for Google Workspace, you may not need an add-on. Gemini in Sheets opens from Ask Gemini and creates tables, formulas and charts, and takes actions such as pivot tables, filters and dropdowns. It needs an eligible Google Workspace or Google AI plan (Google Docs Editors Help). My Gemini for Google Workspace post covers which plans include it.

Google Docs Editors Help page titled Collaborate with Gemini in Google Sheets, listing creating tables, formulas, charts, summarising Drive and Gmail files and actions such as pivot tables and conditional formatting
Google's built-in option, as taken from Google Docs Editors Help

Google warns that Gemini's conversation is lost when you reload or close the sheet. As for which is better, one Hacker News reader in May was blunt:

Hacker News

"It's incredible how far behind Gemini has gotten, both the product and the model. Even the ChatGPT plugin for Google Sheets blows away the native Gemini integration."

That's one person's view. If Gemini is already paid for, try it on your real sheet first.

How much does ChatGPT for Google Sheets cost?

The add-on itself is free; what you pay for is ChatGPT usage. OpenAI's pricing page lists the "Excel, Word, PowerPoint, and Google Sheets extensions" on every plan, with different allowances:

PlanPriceSheets add-on
Free$0Limited
Go$8/monthLimited
Plus$20/monthYes, within your agentic usage limit
ProFrom $100/monthExpanded
Business, Standard seat$25/user/month, or $20 billed annuallyCredits, typically 5 to 20 per message
Business, Premium seat$125/user/month, or $100 billed annuallyHigher usage limits, same credit pool
EnterpriseContact salesOff until an admin enables it

Business prices are from OpenAI's Business overview. For Business and Enterprise, the ChatGPT rate card bills Excel and Sheets at token-based API model rates and says "A typical ChatGPT for Excel/Sheets task may use 5–20 credits per message." OpenAI says the spreadsheet add-ins share agentic usage and credits with ChatGPT Work, workspace agents, Codex and the Word and PowerPoint add-ins, so a busy finance team draws on the same allowance as the engineers. My ChatGPT pricing breakdown and ChatGPT Team review cover seats in more depth.

What are the limits of ChatGPT for Google Sheets?

OpenAI lists four in its help article, and they're worth knowing before you hand it a real workbook:

  • Separate chats. Sheet conversations don't sync with your main ChatGPT history.
  • No memory. ChatGPT memory isn't available in the sidebar, so your preferences don't follow you in.
  • Advanced features. Things like macros may not be fully supported. In Google Sheets terms, that's the Apps Script side.
  • It can be wrong. OpenAI's advice is to review changed cells and, "For important work, duplicate the file first so you can revert if needed."

The listing adds a data note: chats, attachments and workbook content "may be shared with Google and OpenAI to enable reading and updating your spreadsheets", and you can delete or download your data from the add-on's Settings.

The Apps Script point has history. In late May, a security write-up titled "ChatGPT for Google Sheets exfiltrates workbooks" was posted to Hacker News, describing untrusted data in a sheet steering ChatGPT into running an attacker's script. OpenAI's security team replied in the thread and closed the door:

Hacker News

"We've taken immediate steps to protect users against potential attacks in this area by removing the model's ability to generate Apps Script code, which should eliminate the risk to users of ChatGPT for Google Sheets."

Credit to OpenAI for a fast, plain fix. The lesson holds for any AI that edits files: text in the sheet can steer it, so be careful with imported data you didn't write.

Can ChatGPT update a Google Sheet on a schedule?

Sometimes, and this is where people with a recurring report get stuck. The add-on works inside a sheet you have open, from its sidebar. For anything on a clock you need ChatGPT's scheduled tasks or a workspace agent, working through the Google Drive connection.

The forum history is bumpy. In June, OpenAI Support said "Scheduled Tasks currently can't read from or act on connected services when they run" (forum thread). By autumn, tasks could reach Sheets but writes were getting stopped by a safety check:

"The task runs, reasons correctly, reaches the intended write action, but the write is blocked by an internal OpenAI safety check."

That thread has 1.8k views and 20 people in it. OpenAI Support suggested moving the job to ChatGPT Work, then on 26 October said it had "shipped a change to scheduled actions last week" and saw Sheets updates succeeding. At least one user still reported blocks on "small, authorized writes to Google Sheets and Docs" afterwards. If a weekly sheet update is the whole point of your workflow, test it for a few weeks before you rely on it.

Workspace agents on Business and Enterprise are OpenAI's sturdier answer: they run on a schedule, take API triggers, work in a Slack channel, and their write actions default to "Always ask" (workspace agents). To work in Slack, every app connection on the agent must use shared authentication, and OpenAI warns that a personal account here "can inadvertently allow access to your app's data to users who invoke the agent". Everyone in the channel gets the same access to the Drive behind it.

The spreadsheet the whole team asks about

Every company has one: the launch tracker, the hiring pipeline, the renewals list. One person owns it, and everyone else asks about it in Slack. "Is the Acme renewal signed?" "Can someone post this week's numbers?"

The add-on helps the owner keep the sheet tidy. The other twenty people would each need the add-on, a ChatGPT plan and the link. And some of them shouldn't see every column: the sales rep can know the renewal status, the contractor in your shared channel shouldn't see the discount column.

ChatGPT for Google SheetsChatGPT workspace agenteesel
Works forThe person with the sidebar openEveryone who can reach the agentThe whole team, in front of anyone
Who can askYouPeople in the agent's channelsAnyone in Slack, Teams, Google Chat or email
What it does with the sheetBuilds, edits and explains it, after askingReads and updates it where write actions allowReads the sheets you pick and answers from them, sheet linked
What decides what it may doYour plan and your admin's settingsAdmin settings, set once per agentEach action and file, by who is asking
Runs with nobody at a keyboardNoSchedules and API triggersSchedules, app events and webhooks
CostFree add-on; ChatGPT plan or creditsBusiness or Enterprise creditsFrom $299/month for 500 credits, unlimited seats

Sources: OpenAI Help Center, workspace agents, eesel pricing.

How eesel works with your Google Sheets

I build eesel's agents, and eesel has spent years letting an AI act inside teams' own tools. Reading a spreadsheet was never the hard part. Deciding what the AI may say and do for each person who asks was.

eesel is an AI teammate for the whole team. Connect Google Drive, pick the sheets and folders it should read (Shared Drives included), and it reads "Spreadsheet data, across every tab in the sheet" without changing anything in your Drive (eesel docs). The same connection covers Google Docs, Slides and PDFs.

Then the team asks where it already talks. Someone @mentions eesel in Slack or Microsoft Teams, and it answers in the thread with the sheet linked. Think internal knowledge base, where the knowledge is your tracker.

Ask in the thread, get the answer and the sheet it came from

What eesel shares depends on who is asking

ChatGPT works for whoever is typing. eesel works for the company, in front of anyone, and you decide what it does for each kind of person: someone on your team, specific people you name, a verified customer, or an anonymous visitor.

For files, every sheet and folder is On, Team only or Off (actions and approvals). On means eesel can use it to answer anyone, though it never sends the file or its link outside your team. Team only means it's used only when someone on your team asks. "Your team" is your Team page plus full members of your connected Slack, users in your Microsoft Teams or Google Workspace, and anyone writing an internal note in your helpdesk.

Actions are On, Ask first or Off per agent and per action, and you can set them in chat: "answer from the trackers on your own, but ask me before you post in #general." Ask first shows the exact action with Approve and Deny, as a card in the Slack thread, in the dashboard or by email, and only editors approve. A renewals tracker might play out like this:

Who asksSheet settingWhat eesel does
A sales rep in #deals: "Is the Acme renewal signed?"Renewals tracker: Team onlyAnswers in the thread and links the sheet
A contractor in a shared Slack Connect channel asks the sameRenewals tracker: Team onlyLeaves the tracker out; not a full member of your Slack
A named finance lead: "Post the overdue renewals in #finance"Posting set to Ask firstSends an approval card with the exact message first
A visitor in your website chat asks about pricingPrice list: OnAnswers from it, never sends the sheet or a link

Even with an action On, eesel's safety check can still hold a risky call.

The Monday report runs itself

The other half of the shared-sheet job is the report nobody wants to write. eesel's automations start work from a schedule, an event in a connected app, or a webhook. Ask in chat for "every Monday at 9, re-sync the launch tracker and post what's overdue in #launch" and it sets up the schedule and confirms the time zone.

That's close to how Cape Coffee Beans uses it. A second agent, called Oversight, watches a daily team form that syncs in from Google Sheets, refreshed by a weekday sync, and across both agents eesel ran 160 scheduled Zendesk and Google Drive checks in a month, most ending in a short email to the founder.

eesel's New Scheduled Job form with a title, a prompt box for what the agent should do each run, Hourly, Daily, Weekly, Monthly and Custom schedule options, a 9:00 AM time and a time zone picker
Set the time once, and the summary shows up every week

Corrections stick: say "always group overdue items by owner" once and it saves a standing rule you can edit (instructions and memory).

Can you keep ChatGPT and use eesel too?

Yes, and I'd keep both. ChatGPT for Google Sheets is a great personal tool for building and fixing sheets. eesel handles the team side, and you can reach it from ChatGPT: eesel's apps are being listed in ChatGPT's app directory, and Codex can set eesel up through the CLI (use eesel from ChatGPT). If your team also uses Claude, your eesel workspace works as an MCP server you add as a custom connector, so you can ask "what did eesel post in #launch this week?" from Claude, with editors able to change things and approvals still applying (eesel docs).

My ChatGPT at work guide and roundup of AI teammates go further.

Try eesel as your team's Google Sheets teammate

If your tracker lives in Sheets and the questions about it arrive in Slack or Teams, eesel connects the two. Pick the sheets it should read, mark the sensitive ones Team only, schedule the Monday summary, and let anyone ask. It's free for 7 days with 100 credits and no card, then from $299 a month for 500 credits with unlimited seats (pricing).

The eesel dashboard chat with a greeting, suggested prompts and a message box, beside the agent's integrations, files and skills
Tell it what to read and when to report, in plain words

Try eesel

Frequently Asked Questions

Is there an official ChatGPT add-on for Google Sheets?
Yes. OpenAI publishes ChatGPT for Google Sheets in the Google Workspace Marketplace. It opens as a sidebar from the Extensions menu and builds, edits and explains your spreadsheet. The ChatGPT for Excel add-in is its sibling.
Is ChatGPT for Google Sheets free?
The add-on is free to install and works on the Free plan, but Free and Go get limited usage. Plus and Pro use their agentic limits, and Business and Enterprise pay in credits, typically 5 to 20 per message. My ChatGPT pricing guide covers the plans.
How do I add ChatGPT to Google Sheets?
Install ChatGPT from the Google Workspace Marketplace, open a sheet, go to Extensions, then ChatGPT, then Open, and sign in with your ChatGPT account. On a Business or Enterprise workspace an admin may need to enable it first. For answering the team from a sheet instead, see eesel for Google Drive.
Can ChatGPT edit Google Sheets directly?
Yes. The add-on changes cells, formulas and formatting in the open sheet and asks permission before it makes changes. ChatGPT's Google Drive app can also update a sheet from a normal chat where your workspace allows it. The ChatGPT for Google Docs guide covers the Drive app.
Is ChatGPT for Google Sheets better than Gemini in Sheets?
They suit different people. Gemini in Sheets comes with eligible Google Workspace plans and can make pivot tables, filters and formatting changes, while the ChatGPT add-on suits people who already pay for ChatGPT and want its skills and apps in the sheet. My ChatGPT vs Gemini post compares the two assistants.
Can ChatGPT answer my team's questions from a Google Sheet in Slack?
A ChatGPT workspace agent can, on Business and Enterprise, through one shared Google connection for everyone in the channel. eesel reads the sheets you pick and answers in Slack or Teams, and what it shares depends on who is asking.

Share this article