Preparing a spreadsheet can take more time than actually working through it.
Now that Gemini is integrated with Google Sheets, using it for work has taken some of that work off my hands.
In March 2026, Gemini scored 70.48% on SpreadsheetBench V1 – Full, which is not a soft test. SpreadsheetBench gathers 912 questions from real situations in varied formats.
That’s nearly human-expert level, but it also tells you Gemini may still come up short on about three out of ten tasks.
Still, I was happy with how it worked through my data. Here are six jobs I won’t be taking back.
Building a project’s scaffolding from a single prompt
Starting a sheet from scratch means facing the blank page first, and that’s the worst of it.
There are headers to type, borders to poke at, and fake rows you add to check the layout. Not anymore. Gemini can build the full base from one prompt.
Create a project tracker with columns for client name, project scope, status, due date, and estimated fee.
The side panel hands you a fully formatted table with the headers you wanted, and placeholder data filled in.
Keep an eye on it as Gemini tends to overcomplicate. You may end up with extra columns you never requested.
Also, don’t make too much of this single prompt. You could pull off the same thing for an expense tracker, a tax audit, job hunting, or any project that normally begins with a blank page.
Handing off the data cleanup on a messy dataset
Raw exports are rarely clean. You’ll likely see some mixed casing and a pocket of whitespace. Let Gemini take care of the cleanup.
Standardize these names to Title Case and remove any duplicate entries.
You get back a tidy column with consistent casing and no stray duplicates.
Check the dates carefully, though. Regional formats are sometimes misread, especially the MM/DD and DD/MM.
Building conditional dropdowns and color rules
Data isn’t much use if it’s hard to read, and conditional formatting sits behind nested menus. Gemini can run a chain of formatting from a single prompt.
Add a status dropdown to column D with options for Not Started, In Progress, and Done, and highlight any row in green where the status is Done.
You get a preview showing the rules, and your approval sets the dropdown chips with color rules.
Mind the blank cells, because they may confuse Gemini unless you add a rule to ignore blanks.
Writing formulas by describing what I want
INDEX/MATCH syntax is one less thing I have to Google these days. Gemini takes the logic, hands back a working formula, and walks you through how it does it.
Write a formula to search column A for a matching email address on Sheet2 and return the corresponding value from column B.
You get the lookup syntax written out and ready to paste in.
However, Gemini sometimes drops the dollar signs, and the formula falls apart as you drag it down a column, so lock the range yourself.
Fixing inherited spreadsheet errors in a click
There was a time when inheriting someone else’s spreadsheet came with #REF and #N/A errors.
Thanks to this recent upgrade, a dedicated formula troubleshooter now reads the broken formula and its neighboring cells to spot the point of failure.
Press the Fix button next to the error.
Getting takeaways and visuals in one prompt
The point of a spreadsheet is to let someone else skim it.
Gemini can pull together what’s scattered across the workbook and lay dashboards and visuals over the raw data.
Identify the top three trends in this data and build a summary dashboard.
The payoff is a short list of takeaways next to a stylized interactive dashboard. Don’t forget to double-check any figure headed for a stakeholder.
An eager intern, never an oracle
Where Gemini does miracles in Sheets is removing the first 70% of the friction, so treat it like a very good intern.
It buys back enough time for me that doing it manually isn’t an option anymore.
Still, there’s no substitute for knowing your data. The final answer is still yours.
What Gemini does is get you to the point where you can start thinking about your data faster.
