Google added Gemini to Sheets, and it has modified the trajectory of my life…
Nice, I am being a bit of dramatic, however do not act like I am the one one who thinks quite a lot 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 every so often, one thing helpful comes alongside. Google including AI to Sheets was a kind of moments for me.
Right now, I am breaking down why Gemini in Sheets issues, how I am 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 thus far.
In the event you’re new to my work, my identify is Les. I am a founder and an award-winning efficiency marketer. Nowadays, I assist on a regular basis individuals make sense of the “AI is altering all the things” chaos. 👉👈
In the event you like distinctive advertising and marketing insights and wish to keep updated with sensible methods to make use of AI, try my free publication, No Fluff Simply Info.I break down what’s working in advertising and marketing and the AI instruments value taking note of.
However sufficient about me, let’s bounce 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 all the time hold it actual with you: Google swings and misses loads. Half the time, it seems like they’re simply throwing options on the wall to see what sticks. The outcome? Frankenstein-code layers of half-baked concepts stacked on high of one another, making all the things extra difficult than it must be. precisely what I imply. 🤓
However this time? They acquired 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 are not any additional tabs, no complicated menus, simply useful AI that matches naturally and helps you get issues performed.
Must crunch a yr’s value of gross sales knowledge? Generate a chart? Summarize survey responses? 🤔
Gemini handles all of it immediately, proper the place you are already working, and that is 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 am not saying you may change into a genius knowledge 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 reviews – I haven’t got the time, power, or want to do these reviews. So, each Monday, I’ve Gemini pull the numbers collectively. I choose the info and ask, “Summarize this knowledge, spotlight the highest performers, and name out something unfavourable… fairly please.” (Sure, I say fairly please, simply in case the AI ever revolts.) The outcome? I get what I would like, and I am good to go.
-
Recognizing developments – An enormous a part of my job is recognizing developments, and quite a lot of our success as an organization comes from performing on developments earlier than anybody else. I inform Gemini, “Present me the developments 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 modify apps? That is a game-changer, particularly for my ADHD. 😅
My two cents
I am genuinely blown away. Google did effectively with this one. And the irony? It is not 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 might be. Don’t be concerned, 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 would like easier and useful AI suggestions and advertising and marketing insights, join my free publication, No Fluff Simply Info.
