If you’ve ever spent a Friday afternoon wrestling with a pivot table, trying to remember the exact syntax for a VLOOKUP, or copying data from your Gmail into a spreadsheet cell by cell – Google has some good news for you. Gemini in Google Sheets just got a serious upgrade, and it might be the most practical AI update the company has rolled out in a while.

On April 22, 2026, Google officially announced that Gemini can now build and edit entire spreadsheets from scratch using nothing but plain, conversational language. You don’t need to know a single formula. You don’t need to manually configure a pivot table. You just describe what you need, and Gemini handles everything from data retrieval to formatting. That’s a pretty big shift from how spreadsheets have worked for the past few decades.

The headline feature here is what Google calls “End-to-end creation.” Imagine you’re running a small business and need a profit-and-loss dashboard built around your past service incidents and rate cards – something that would traditionally take a finance professional hours to build. With Gemini, you just type that ask into the side panel, and the AI constructs a plan for you to review, then goes ahead and builds the entire formatted spreadsheet – stylized tables, charts, formulas, and all. No back and forth, no manual formatting, no spreadsheet expertise required.

But Google didn’t stop there. Alongside end-to-end creation, the update also brings “Side-by-side editing,” which is equally useful. Say you already have a sales and inventory sheet that’s been your go-to tracker for months, but now you want scorecards and bar charts added above your existing data. You don’t have to rebuild anything. Just open the Gemini side panel, describe the edit you want, and it drops the new elements right into your existing spreadsheet. That kind of flexibility – adding to something rather than replacing it – is what makes this feel like a genuine workflow tool rather than a party trick.

What makes this update particularly interesting is the “Workspace Intelligence” layer underneath it all. Gemini isn’t just working with whatever data happens to be in the open spreadsheet. It can pull context and information from across your entire Google Workspace – your Drive files, Gmail threads, Google Chat messages, and even the web. So if you ask it to build a financial summary, it won’t just generate a blank template. It will actually go find the relevant numbers from your emails and documents, and use them to populate the sheet. That’s something that competing AI tools like Claude and ChatGPT simply can’t do natively, since they don’t have that same pipeline into your Google account.

There’s also a more technical capability that deserves attention: advanced optimization. For tasks that typically require complex manual formulas or third-party tools – think resource allocation, scheduling, logistics planning – Gemini in Sheets can now handle those directly, powered by research from Google DeepMind and Google Research OR-Tools. That’s genuinely impressive, and it puts a level of analytical horsepower into everyday spreadsheet work that previously required dedicated software.

The performance benchmarks back up the hype, too. Google tested Gemini in Sheets on SpreadsheetBench, a publicly available third-party benchmark designed to evaluate how well AI can manipulate real-world spreadsheets. Gemini hit a 70.48% success rate – not only outperforming competitors but nearing human expert-level ability. To be clear, SpreadsheetBench isn’t a Google-created test – it’s an independent, publicly available standard, which makes that result more meaningful than an internal benchmark would be.

Google is rolling this out gradually. For Rapid Release domains, the feature started going live on April 22, 2026, with a rollout period of up to 15 days. Scheduled Release domains will start seeing it from May 6, 2026. In terms of who gets access, it’s available on Business Standard and Plus, Enterprise Standard and Plus, and consumer plans like Google AI Pro and Ultra. There’s also a promotional perk worth knowing about – through July 15, 2026, eligible Workspace users get access to higher usage limits while Google fine-tunes the final per-user caps. After that, standard limits will kick in.

The way Gemini approaches this is also thoughtful from a user experience standpoint. It doesn’t just quietly build something and dump it in your sheet. It presents a plan first, waits for your approval, and then executes. That human-in-the-loop design means you stay in control and can course correct before anything is finalized – a smart call for anyone using AI for anything financially sensitive.

To get started, Workspace admins need to make sure Gemini for Google Sheets is enabled in their admin settings. End users need to have Workspace smart features turned on, and once they do, the Gemini icon will appear in the Sheets side panel. From there, it’s as simple as describing what you want. Whether that’s a budget tracker, a project timeline, or a multi-tab dashboard pulling from your Drive and Gmail – Gemini will take it from there.