I’ve always been a proponent of using Gemini in Google Sheets to help me generate new sheets, clean and organize data, analyze and visualize information, pull in context from Gmail and Drive, and explain trends for my report. It’s been awesome having that assistance readily available, but I still had to spend a few minutes prompting Gemini and running each of these tasks individually.
Well, that extra time isn’t as necessary because Gemini can now handle multistep jobs in Google Sheets. With a single prompt, I can generate a sheet, organize my data, analyze it, visualize key insights, and pull in relevant context all at once. If you haven’t tried Gemini in Google Sheets recently, now’s a good time to take another look.
Gemini can now handle your entire to-do list in one go
Just tell it once
For a while, AI assistants in productivity apps were essentially single-task helpers. You’d ask them to do one thing, check the result, and then prompt them again for the next thing. However, Gemini in Google Sheets now understands compound, multistep instructions and can execute an entire sequence of actions from a single prompt. You just describe what you want in plain language and Gemini will work through each step on its own.
To see what this looks like in practice, I tested it on a 100-row sales dataset with columns covering categorical data (Region, Item Type, Sales Channel), temporal data (Order Date, Ship Date), and numerical data (Units Sold, Total Profit) in one sheet. This was the prompt I used:
Convert range A1:N100 to a table, format the ‘Total Revenue’ and ‘Total Profit’ columns as currency, and add a conditional formatting rule to highlight ‘High’ priority orders in light red. Then, add a new column at the end called ‘Unit Profit’ that subtracts ‘Unit Cost’ from ‘Unit Price’. Then, create a pivot table on a new sheet summarizing the ‘Total Profit’ by ‘Region’. After that, delete all rows where the ‘Item Type’ is ‘Office Supplies’ and then sort the remaining data by ‘Units Sold’ from highest to lowest.
With a single prompt, Gemini handled the full sequence of operations for me—from converting the range into a formatted table and applying currency and conditional formatting, to adding a calculated column, building a pivot table on a new sheet, removing unneeded rows, and sorting what was left. In a normal session, I’d expect to spend many minutes clicking through menus for that kind of cleanup, but here it all ran as one chained command that I just reviewed and applied.
I ran this prompt on data in one sheet, but Gemini can also pull in context from other sources in your Google ecosystem. For example, I can ask it to reference meeting notes stored in Google Drive or summarize an email thread from Gmail and incorporate that information directly into the sheet. After clicking the Ask Gemini button in Sheets (the spark icon), select the dropdown in the bottom-left corner of the prompt box and choose which sheet in the workbook Gemini should focus on. From the same menu, you can also connect to Google Drive, Gmail, or the Google web to provide additional context.
These advanced editing capabilities are currently available to you if you subscribe to Business Standard or Plus, Enterprise Standard or Plus, Google AI Pro for Education, and certain Gemini add-on plans. If you’re part of Google’s Workspace Labs, as I am, you’ll also have access.
Related
Gemini isn’t as useless as it was when you tried it two years ago
AI that I first despised is now my Google Assistant replacement.
All the things Gemini can do in your sheets
It’s more than you’d expect
Screenshot by Ada
The reason a prompt like the one above works is that Gemini’s supported action library in Google Sheets has expanded significantly. Knowing what tools Gemini has available makes a difference in how you write your prompts, because the more you know, the easier it becomes to ask for several steps at once.
On the formatting side, Gemini can apply conditional formatting rules based on values or text, such as highlighting high-priority orders in light red. It can also set number formats for things like currency or dates, convert a range into a structured table, and freeze rows or columns, so headers remain visible while you scroll through large datasets.
For data entry and manipulation, Gemini can add checkboxes, convert cells into dropdown lists, run find-and-replace operations across an entire sheet, and write formulas using the correct cell references. That last one is particularly useful when you’re building a lot of formulas in a large dataset. Also, instead of clicking through tabs for something like replacing every instance of “Office Supplies” with “Stationery” across your sheet, you can just write a simple instruction.
Gemini also helps with structure and organization. It can insert or delete rows and columns, sort data by any column in ascending or descending order, and generate pivot tables that summarize large datasets by the category you choose.
When it comes to analysis, Gemini can summarize what’s in a spreadsheet, identify trends in the data, and create charts to visualize those insights. Depending on the dataset, that might mean a line chart showing performance over time, an expense breakdown, or another chart that best represents the patterns in your data.
Think bigger with your prompts
The biggest barrier to getting value out of Gemini in Sheets is the instinct to keep your prompts cautious and bite-sized. That habit made sense before, when the tool struggled with complex instructions. Now, it’s worth unlearning that approach.
Instead of asking Gemini to complete one small task at a time, describe what you want the final result to look like and outline the steps in order. As long as you’re clear about the range or table and the sequence of operations, Gemini usually produces a clean result. And if something doesn’t come out quite right, the Undo button is always there.
