Google added Gemini to Sheets, and it has modified the trajectory of my life…
Wonderful, I am being a little bit dramatic, however do not act like I am the one one who thinks lots of “AI improvements” are a load of what. 🤬
Most “AI improvements” are both overhyped or simply plain ridiculous; taking a look at you, AI toaster. I nonetheless cannot recover from that and refuse to let it go.
However each now and again, one thing helpful comes alongside. Google including AI to Sheets was a type of moments for me.
At present, I am breaking down why Gemini in Sheets issues, how I am utilizing it to avoid wasting hours each week, and why this low-key transfer may be Google’s most good AI play thus far.
For those who’re new to my work, my title is Les. I am a founder and an award-winning efficiency marketer. Lately, I assist on a regular basis individuals make sense of the “AI is altering all the things” chaos. 👉👈
For those who like distinctive advertising and marketing insights and need to keep updated with sensible methods to make use of AI, take a look at my free publication, No Fluff Simply Information.I break down what’s working in advertising and marketing and the AI instruments value taking note of.
However sufficient about me, let’s leap into how Gemini would possibly lastly flip you right into a spreadsheet wizard. 🔮
How Gemini Works with Sheets
As I am positive , Gemini is Google’s reply to ChatGPT, designed to combine seamlessly throughout Google Workspace.
I’ll at all times hold it actual with you: Google swings and misses lots. Half the time, it looks like they’re simply throwing options on the wall to see what sticks. The consequence? Frankenstein-code layers of half-baked concepts stacked on prime of one another, making all the things extra difficult than it must be. You understand precisely what I imply. 🤓
However this time? They obtained it proper.
Gemini in Sheets is not simply one other layer of complexity. It is a seamless improve constructed proper into your workflow. Not like standalone AI instruments that require additional 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 additional tabs, no complicated menus, simply useful AI that matches naturally and helps you get issues accomplished.
Have to crunch a 12 months’s value of gross sales information? Generate a chart? Summarize survey responses? 🤔
Gemini handles all of it immediately, proper the place you are already working, and that is the form of sensible AI I can get behind.
What you are able to do with Gemini in Sheets
- Create tables.
- Create formulation.
- Generate information 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 am not saying you may turn out to be a genius information scientist utilizing Google Sheets and Gemini… however I am additionally not not saying it. 😛
How I am Utilizing Gemini
As I discussed earlier, I am a marketer at my core. A giant a part of my job is not simply crafting campaigns; it is 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 studies – I haven’t got the time, power, or want to do these studies. So, each Monday, I’ve Gemini pull the numbers collectively. I choose the info and ask, “Summarize this information, spotlight the highest performers, and name out something detrimental… fairly please.” (Sure, I say fairly please, simply in case the AI ever revolts.) The consequence? I get what I would like, and I am good to go.
-
Recognizing tendencies – An enormous a part of my job is recognizing tendencies, and lots of our success as an organization comes from performing on tendencies earlier than anybody else. I inform Gemini, “Present me the tendencies and spotlight any uncommon spikes.”
-
Constructing customized dashboards – I really like dashboards. I hate pivot tables. So, as a substitute of manually setting one up, I say, “Create a dashboard exhibiting 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 comparable issues, however not having to change apps? That is a game-changer, particularly for my ADHD. 😅
My two cents
I am genuinely blown away. Google did nicely with this one. And the irony? It isn’t even flashy.
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 fret, I will not inform them how you probably did it.
However remember to inform Gemini “fairly please,” simply in case.
😇 Hope this helps. I am rooting for you.
P.S. If you need less difficult and useful AI suggestions and advertising and marketing insights, join my free publication, No Fluff Simply Information.
