I’ve never been good at spreadsheets. Still, like practically everyone else, I’ve found myself stuck in situations where I have no choice but to use them. Whether it was building a finance dashboard to track my chaotic spending, creating an assignment and work deadline tracker to stay on top of everything, or analyzing a massive dataset for a course I’m taking, spreadsheets have always been something I’ve had to deal with.

In most cases, especially when I’m building something to speed up my own workflow, I’ve relied on guides and YouTube tutorials, which often involve following steps blindly without fully understanding what I’m doing. With AI in the game now, a lot of that friction has started to slowly disappear. I recently got Google’s AI Pro plan (thanks to the student offer), and one of its perks is Gemini within the Google tools I rely on daily, like Gmail, Slides, Meet, Maps, and of course, Sheets.

Gemini now lives directly inside Sheets

No more switching tabs

Like every other tech giant, Google’s also gone all-in on AI, and is constantly looking for ways to integrate its chatbot, Gemini, into the apps we use every day. Their current approach is adding a Gemini button to Workspace apps to allow users to get help without ever leaving the app.

This includes Gemini in Gmail, Docs, Sheets, Slides, Vids, Drive, Meet, and Chat. While the standard, free personal Google account doesn't currently include integrated Gemini features within Workspace apps, it's available with certain paid plans. If you'd like to check whether your plan includes it, simply head to Sheets and look for the Ask Gemini button (denoted by Gemini's star icon) in the top-right corner of the toolbar, next to your profile picture.

Similarly, you'll also find a Gemini button in the toolbar. When you click it, the following options will appear: Analyze data, Generate charts, Generate a pivot table, Generate a table, Generate an image, Generate a formula, Summarize text, Categorize text, Analyze sentiment of text, Generate text, and Ask something else.

You'll also see Gemini appear when doing things like typing the equals sign to start a formula. Gemini will often automatically suggest a complete formula based on the content of your data, and a Generate formula button will also appear.

Formula syntax used to slow me down

This has never been easier

Given that I'm not the best at spreadsheets, the formulas and the syntax you need to use have always been the part that's slowed me down. I've spent hours looking up formula syntax, keeping guides open in separate tabs, and double-checking whether I typed everything correctly. With AI in the game now, the endless Google syntax searches have turned into frustrating back-and-forth with ChatGPT. However, that requires switching back to Sheets, pasting the formulas ChatGPT gives you, and hoping they work correctly.

That's where Gemini changes the game completely. Instead of hopping between tabs or, let's face it, copying formulas from ChatGPT, you can now ask Gemini directly within Sheets to generate formulas in completely natural language. For instance, you can say something like, "I need a formula that sums up all the sales from column B for this month, but only for products in the category 'Electronics' and only if the quantity sold is greater than 5," and Gemini will generate it instantly. This makes more complex formulas like nested IF statements, conditional sums, VLOOKUP, or multi-criteria lookups feel effortless.

Another solid example of how this integration has been useful for me is when I was trying to figure out how curve-based grading works. Since I'm a college student and it's grades season for me, I needed to calculate adjusted grades for an entire class based on a curve. While I eventually ended up creating a web application for this using NotebookLM and Antigravity, I first tried to do some analysis in Google Sheets, and Gemini helped me get everything done a lot quicker.

For example, the spreadsheet my professor provided was incomplete and missing the Total marks for each student. Rather than just adding all the raw numbers, I needed to take the weightage of each component into account (assignments, quizzes, exams, participation) and calculate each student’s total accordingly. Since the data was extremely messy, I first had to figure out the weighted scores for each component, then sum them up correctly.

Normally, this would have involved multiple nested formulas and a lot of cross-checking, but Gemini made it much easier by generating the correct formulas on the fly and letting me focus on analyzing the results instead of getting lost in syntax. The best part is that Gemini includes step-by-step explanations of how the formulas work, which makes it easier to understand the logic behind each calculation. This not only helps me trust the results but also lets me learn more about spreadsheet formulas as I go, instead of just blindly relying on the AI.

Gemini catches insights you’d normally miss

It highlights what I usually overlook

One task I lean on AI tools for a lot nowadays is spotting trends in data. Given that AI is a machine and is trained to recognize patterns in large datasets, it often ends up spotting trends a human would normally miss. Before I started using Gemini in Sheets directly, I'd constantly save my spreadsheets and drop them into a new NotebookLM notebook.

I'd then have the spreadsheet open in a separate Sheets tab, and NotebookLM in another, and would prompt NotebookLM to analyze the data, summarize key trends, and point out any anomalies or patterns worth noting. It worked, but juggling multiple tabs and switching between apps was cumbersome and slowed me down.

With Gemini built directly into Sheets, I can get the same insights immediately. For instance, something I do every week is analyze how each of my articles performed. In addition to the manual analysis I do to spot patterns and figure out why something underperformed while another performed exceptionally well, I also ask Gemini to analyze the trends. It gives me a fresh perspective, and more often than not, it highlights insights I might have skipped over.

Ignoring these features is only going to cost you time

AI's going nowhere, and it's time we accept that. For monotonous tasks like the ones above, that used to take hours of manual work or juggling multiple tools, AI (and Gemini in particular) can handle them in seconds, letting us focus on analysis and decision-making instead of syntax and formatting.