Google added Gemini to Sheets, and it has modified the trajectory of my life…
Advantageous, I'm being slightly dramatic, however don't act like I'm the one one who thinks lots of "AI improvements" are a load of you realize what. 🤬
Most "AI improvements" are both overhyped or simply plain ridiculous; you, AI toaster. I nonetheless can't recover from that and refuse to let it go.
Additionally: Why I just added Gemini 2.5 Pro to the very short list of AI tools I pay for
However each every now and then, one thing helpful comes alongside. Google including AI to Sheets was a kind of moments for me.
In the present day, I'm breaking down why Gemini in Sheets issues, how I'm utilizing it to save lots of hours each week, and why this low-key transfer is likely to be Google's most sensible AI play up to now.
In case you're new to my work, my name is Les. I'm a founder and an award-winning efficiency marketer. As of late, I assist on a regular basis individuals make sense of the "AI is altering all the things" chaos. 👉👈
Additionally: Solely 8% of Individuals would pay further for AI, in line with ZDNET-Aberdeen analysis
In case you like distinctive advertising and marketing insights and need to keep updated with sensible methods to make use of AI, check out my free newsletter, No Fluff Just Facts.I break down what's working in advertising and marketing and the AI instruments price taking note of.
However sufficient about me, let's soar into how Gemini would possibly lastly flip you right into a spreadsheet wizard. 🔮
How Gemini Works with Sheets
As I'm positive you realize, Gemini is Google's reply to ChatGPT, designed to combine seamlessly throughout Google Workspace.
I’ll at all times maintain it actual with you: Google swings and misses so much. Half the time, it appears like they're simply throwing options on the wall to see what sticks. The end result? Frankenstein-code layers of half-baked concepts stacked on high of one another, making all the things extra difficult than it must be. You realize precisely what I imply. 🤓
However this time? They acquired it proper.
Additionally: I attempted Microsoft's free AI abilities coaching, and you may too – for an additional few weeks
Gemini in Sheets isn't simply one other layer of complexity. It's a seamless improve constructed proper into your workflow. In contrast to standalone AI instruments that require further logins or fixed app switching, this one lives the place you already work. Open your spreadsheet, click on the Gemini icon, and provides directions in plain English.
There aren’t any further tabs, no complicated menus, simply useful AI that matches naturally and helps you get issues performed.
Have to crunch a 12 months's price of gross sales knowledge? Generate a chart? Summarize survey responses? 🤔
Gemini handles all of it immediately, proper the place you're already working, and that's the sort of sensible AI I can get behind.
What you are able to do with Gemini in Sheets
- Create tables.
- Create formulation.
- Generate knowledge evaluation and insights.
- Construct charts and graphs.
- Summarize your recordsdata from Drive and emails from Gmail.
- Carry out actions like making use of conditional formatting, creating a brand new pivot desk, creating new dropdowns, sorting, or filtering your desk.
I'm not saying you'll grow to be a genius knowledge scientist utilizing Google Sheets and Gemini… however I'm additionally not not saying it. 😛
How I'm Utilizing Gemini
As I discussed earlier, I'm a marketer at my core. A giant a part of my job isn't simply crafting campaigns; it's digging into the numbers. Reporting used to eat up far more of my time than it ought to have, however Gemini makes that a part of my job a lot simpler. 🤗
-
Automating my weekly stories – I don't have the time, power, or need to do these stories. So, each Monday, I’ve Gemini pull the numbers collectively. I choose the information and ask, "Summarize this knowledge, spotlight the highest performers, and name out something destructive… fairly please." (Sure, I say fairly please, simply in case the AI ever revolts.) The end result? I get what I would like, and I'm good to go.
-
Recognizing traits – An enormous a part of my job is recognizing traits, and lots of our success as an organization comes from appearing on traits earlier than anybody else. I inform Gemini, "Present me the traits and spotlight any uncommon spikes."
-
Constructing customized dashboards – I really like dashboards. I hate pivot tables. So, as an alternative of manually setting one up, I say, "Create a dashboard displaying month-to-month income, bills, and revenue margin."
These are the duties that matter most to me, however I like to recommend you attempt Gemini your self to see the way it works greatest along with your workflow.
Positive, different instruments can do related issues, however not having to change apps? That's a game-changer, particularly for my ADHD. 😅
My two cents
I'm genuinely blown away. Google did properly with this one. And the irony? It's not even flashy.
Additionally: The telltale signal that you simply used ChatGPT – and a trick to keep away from it
All I can say at this level is: create a report, ship it to your boss, and allow them to see how good you’re. Don't fear, I received't inform them how you probably did it.
However don't neglect to inform Gemini "fairly please," simply in case.
😇 Hope this helps. I'm rooting for you.
P.S. If you need less difficult and useful AI ideas and advertising and marketing insights, join my free e-newsletter, No Fluff Just Facts.