Episode Categories:
Resources:
Join the discussion: Got something to say? Let us know on LinkedIn and network with other AI leaders
Upcoming Episodes: Check out the upcoming Everyday AI Livestream lineup
Connect with Jordan Wilson: LinkedIn Profile
Making Smarter Use of AI in Google Sheets: Pinpoint Ways Gemini AI Delivers Business Value
Recent advancements in AI are frequently headlined by splashy releases. However, a quietly launched feature—Gemini AI’s integration into Google Sheets—offers highly practical benefits that have gone largely unnoticed. For business leaders, operations directors, and decision-makers, understanding the granular utility of this integration can deliver immediate process improvements.
Google Sheets AI Integration: Access, Capabilities, and Practical Deployment
Gemini AI is now available within Google Sheets for paid Google Workspace accounts, providing users with natural language-driven automation and analysis tools previously reserved for technical experts. This feature is accessible via the Gemini sidebar and directly through new AI-powered spreadsheet functions. The business impact is clear: core spreadsheet tasks like formula generation, dashboard creation, and contextual analysis now require only basic prompts, not advanced formula knowledge.
Key specifics include:
Instantly summarizing and structuring spreadsheet data using conversational inputs.
Formula generation by describing outcomes (e.g., “Calculate commission at 15% for sales in column C”) rather than manual coding.
Visual data presentation via automatic chart, graph, and table creation.
Data Organization Using Natural Language Prompts in Google Sheets
For organizations, structuring operational, sales, and HR data has traditionally relied on meticulous manual input. With Gemini AI, users describe organizational goals in plain language—such as “Create a project tracker with columns for task, owner, and due date”—and the system builds the underlying structure immediately. This enables:
Faster project kickoff with standardized templates.
Easier cross-department coordination when collecting structured datasets.
Automated Data Analysis and Insight Extraction
Instead of time-consuming data filtration and formula-searching, Gemini AI allows business teams to ask for insights directly. For instance:
“Identify the top three selling products this month” generates answers from unsorted or messy datasets, even when complexity would typically require scripting or advanced filtering.
Automated analysis can pinpoint trends in sales, performance, or inventory, without manual data wrangling.
AI-Powered Formula Generation and Cell Actions
Gemini AI’s formula-writing capability eliminates common bottlenecks. Employees can request complex calculations with natural language prompts. Beyond formula generation, the AI enables actions such as conditional formatting—“Highlight all rows where status is overdue in red”—directly from conversational instructions. This translates into:
Reduced support tickets for spreadsheet troubleshooting.
Lower training overhead as non-technical staff become self-sufficient in Sheets.
Sentiment Analysis and Data Categorization at Scale
In customer success and marketing, Gemini AI can run sentiment analysis across large batches of feedback, such as hundreds of reviews. By applying commands like “Categorize feedback into key value themes,” businesses can instantly reveal emerging patterns in customer perception, competitive advantage, and product strengths. The practical implication:
Real-time feedback on product, service, or campaign efficacy.
Rapid, low-cost analysis previously reserved for specialized consultants or software.
Dashboard Creation and Visualization of Key Metrics
Operational leaders can request entire dashboards by simply asking Gemini AI to “Generate a dashboard for this spreadsheet that highlights the most important findings.” This results in instant production of bar charts, bullet points, and trend visualizations—all tailored to the existing data. The feature is particularly effective in monitoring:
Download or engagement metrics for content platforms.
Sales or inventory cycles for retail and B2B companies.
Discovering Under-the-Radar Trends and Insights
Gemini AI’s reasoning engine can be tasked to surface non-obvious trends—e.g., “Find me ten non-obvious trends that impact downloads,” or instructing the AI to avoid “low-hanging fruit” and focus on sophisticated connections. For decision makers:
AI can reveal relationships between variables that seasoned analysts might miss, like long-tail impacts of publishing time or title structure in KPIs.
The transcript demonstration identifies practical, actionable recommendations rather than general observations—critical in competitive or high-volume industries.
Content Generation, Research, and External Data Sourcing
Google Sheets with Gemini AI is not restricted to analysis. It can actively build content (e.g., “Generate an email subject line for product titles in column A2”), produce formatted response templates, and pull external data (e.g., restaurant popularity rankings) faster than manual research or copy-pasting. This supports:
Marketing scale-ups for campaigns and outreach.
Automated research for product listings, geographical analysis, and comparison tables.
Takeaway: Quietly Powerful, Immediate Business Impact
While major AI releases dominate industry headlines, Gemini AI’s integration with Google Sheets equips business leaders with a practical toolkit to refine operational efficiency and unlock new analytical capabilities. Those managing budgets, teams, or client results can leverage these features for immediate, measurable improvements by using natural language to accomplish traditionally complex tasks—drastically reducing time-to-value and dependence on technical staff.
For those evaluating AI adoption, Gemini in Google Sheets stands out for its tangible, context-aware impact across daily business processes.
Topics Covered in This Episode:
- Gemini AI Integration with Google Sheets
- Core Functions: Formulas, Tables, Data Visualization
- Natural Language Prompts in Sheets
- Contextual Analysis from Gmail and Drive
- Instant Dashboard and Chart Generation
- AI-Powered Sentiment Analysis in Spreadsheets
- Content Creation and Automation at Scale
- Spotting Non-Obvious Data Trends with Gemini
Episode Transcript
Jordan Wilson [00:00:15]:
Somehow, one of the most useful and practical AI features of the year has slipped between the cracks with all the recent AI buzz. It's a small but huge release from Google that should be grabbing headlines, but it isn't. What is it? It's Gemini in Sheets, but it kinda makes sense that no one's really talking about it. I mean, look at the last few days alone in the AI world. Chad GPT Pulse and Chad GPT Shopping, Claude 4.5, Sora two, Microsoft agents. Why would anyone be talking about an AI feature in a spreadsheet? Well, don't we all spend so much time in spreadsheets? And aren't we all trying to save time with AI? Wait. This makes perfect sense to tackle on today's putting AI to work on Wednesdays. I'm excited to talk about, new and very overlooked feature in Gemini Gemini AI in Google Sheets.
Jordan Wilson [00:01:19]:
I'm gonna tell you what's new in five daily tasks you didn't know that you could do a little bit better and faster with Gemini AI. Let's get into it. What's going on y'all? If you're new here, welcome to Everyday AI. This is your daily live stream podcast and free daily newsletter helping everyday business leaders like you and me not just keep up with all these AI developments because they do slip between the cracks, but how we can make sense of them to grow our companies and our careers. If that's what you're trying to do, awesome. Starts here with the unedited, unscripted livestream podcast. But if you wanna be the smartest person in AI in your department, our website, that's where it's hap that's where it happens. Youreverydayai.com.
Jordan Wilson [00:01:58]:
Go sign up for our free daily newsletter. As we do every day, we recap the highlights from our livestream podcast as well as keeping you up to date with all the other AI news that matters. So, speaking of stuff that matters, well, we put a pull out in our newsletter. So if you listen to the podcast, make sure you go sign up for our newsletter because we often just ask you, well, what should we cover? We do this new, weekly segment on Wednesdays showing you all ways that we're using AI and ways that you should too. Very easy, very practical. So if this is one of those things where you wanna, bust out, you know, your your second computer or second screen and follow along as we do it, Let's get after it. But you all said you wanted AI and Google Sheets more than anything else, so that's what we're diving into today. And also, stick around at the end.
Jordan Wilson [00:02:45]:
I mentioned that Sora two thing. You can't get access to it unless you have an invite code. I got some invite codes, so I'm gonna tell you how to get access to that at the end. But let's talk about Gemini in sheets. It's really good. So today, we're gonna go through how Gemini in sheets works and the manual tasks that it can help replace. I'm gonna give example use cases for routine tasks that you'd normally do in spreadsheets, but now Google Gemini can do for you and do faster. And I'm gonna highlight five of my favorite time saving, Gemini AI kind of tips and tricks that you can automate.
Jordan Wilson [00:03:24]:
Alright. So what the heck is Gemini in Google Sheets? Let me be honest. The rollout of Gemini in Google workspace has been rocky to say the least. And I wrote it off for a long time and rightfully so because it was bad. Right. I did multiple, you know, videos on my YouTube channel where some of the earlier iterations of Google rolling out Gemini in their workspace. So in, Gmail, in Google Docs, in Google Sheets, It was bad. Didn't work.
Jordan Wilson [00:04:00]:
Couldn't write a formula. It couldn't change the content in there. It was almost like, what is Gemini doing in these different workspace? It's not like that anymore. It is really freaking good. And the newest, feature is kind of this new AI function, that you can just literally type, you know, a simple formula. I'll show you how to do it. You don't have to be technical. You don't have to know coding.
Jordan Wilson [00:04:25]:
You You don't even have to be a spreadsheet whiz. If you can type, you know, three or four letters, you can start making, taking advantage of it right away. But Google, Gemini in Google Sheets, so this is how Google describes it. They say do more, with your spreadsheets in less time with help from AI. Gemini makes it easy to create tables, analyze your data and more. Yeah. The and more is an understatement because I think there's so many capabilities, in Gemini in Google Sheets that people just don't think about, but I think we should start thinking about it. So let's go over some of the basics here.
Jordan Wilson [00:05:01]:
And yes, we're gonna be, doing a couple things live. I'm gonna be, fumbling around a little bit inside Google Sheets. So some of the core functionality while Gemini can generate spreadsheet elements such as formulas, tables, charts, graphs, and provide analysis and insights, who can get access to it? Well, you have to have a paid Google account. So that's one of the downsides, but if your organization right? So if your business uses Gmail for your email provider, right, essentially people either use Microsoft Outlook or they are a Google, workspace organization. So if you're a Google workspace organization, you probably have access to, Google Gemini, so just check with your, system admins. So here's what you can do. There's a couple different ways that you can interact, with Google Gemini and I'm gonna show you each, but essentially, you can just prompt. So on the sidebar, you can pop out the, the Gemini sidebar and you can just prompt in natural language.
Jordan Wilson [00:05:53]:
You can have it write formulas, you can have it visualize data, create tables, all that good stuff, but you can also type in, certain cells as well. Contextual integration is big, so it can summarize spreadsheet content and reference emails plus drive and Gmail files to inform responses. That's huge. I'm not really gonna be demoing that, because, you know, blindly pulling in context from certain emails that align with certain spreadsheets. I I don't know how it's gonna work. Right? Like, as an example, I talked to a lot of our, you know, partners and sponsors about certain stats on certain podcasts. So I don't wanna accidentally pull in email content, but that's extremely helpful. Right? And that's one of the big powers of AI in general is bringing over and carrying over context from different places where you work.
Jordan Wilson [00:06:40]:
So Gemini AI in Google Sheets has that as well. And well, why is no one talking about this? Well, talk about bad timing. So the AI function, and that's really what's new and what I think makes, this really good. It just became generally available about two weeks ago. So in September, 2025, it's obviously been very crazy time for AI updates, and this didn't get a lot of play. Didn't get a lot of love. So actually, if you, watched, our episode, it was episode, six nineteen a couple of days ago. It was with Paige Bailey, from Google.
Jordan Wilson [00:07:16]:
The episode was about nano banana, but she actually, walked us through some, some cool, AI Gemini tricks inside Google sheets. But it's a brand new brand new feature. So if you used, Google Gemini in Sheets maybe a couple of months ago or a year ago and you were kind of like me, you were unimpressed and you're like, this thing doesn't work, try it now. It is extremely impressive and I hope to show you at least a little bit of that. Alright. So, let's look live, shall we? Alright. I'm trying something new here. Normally, you know, if you follow along on the, on the live stream, video side, you know, I usually just have my little Canvas slides.
Jordan Wilson [00:07:54]:
I'm starting to do more of these in, Gemini Canvas. It's just really good. It's really easy. So I don't know. Hopefully, this works. But, if you are listening on the podcast, keep in mind, this might be one of those, shows. It's a little more visual. I'm gonna try to do my best to, describe what's going on, but you can always watch the video recap of this podcast, the exact same thing except the video version on our website at youreverydayai.com.
Jordan Wilson [00:08:20]:
Just click episodes, and it's there. You know, within ten minutes, after the episode is done debuting live, it's essentially on our website, the video. So go check it out. Alright. So let's first go over a little bit. Let's see here. That's fine. We'll go ahead and do this.
Jordan Wilson [00:08:40]:
Yeah, we have our, hopefully my, my, Chrome here isn't isn't too distracting. So, going over some of the benefits here. All right. Let's talk about some use cases first, before we get into those five, ways to save time, with different tasks that I like. So first, just talking about some of the core use cases a little bit more. I mean, data organization, huge, right? Just being able to provide structure, with natural language is extremely important. You know, it's, I love spreadsheets. Some people do, some people don't, right.
Jordan Wilson [00:09:17]:
But being able to create, little widgets, little dashboards with natural language is such, I think, an untapped level up for everyday nontechnical people. Right. Being able to pull your spreadsheet into Google Sheets and saying something like create a project tracker with columns for task owner and due date. Right? It's, Gemini can just understand your natural language. So, number one, being able to organize your data. Number two, obviously getting better analysis and insights. So not having to look for ten, fifteen, twenty minutes, you know, for a single data point or to find a relationship between two different data points. Right? I've done this so many times in the past.
Jordan Wilson [00:10:03]:
Right? So as an example, saying something like, what are the top three selling products this month? Well, what if you work, at a large, you know, manufacturing company and you have thousands of products. Right? Yeah. You might be able to, you know, sort it. Right? Go in and maybe apply some filters, but what if your data is not super clean? Or what if it's, spread across many different skews? Right? So, yeah, you might be able to, you know, create some tables and charts, some formulas, some filters or well, you can just use natural language, and surface those key insights instantly. Formula generation. This is one all the time. Pre AI, I would spend so much time like Googling things, trying to find the right formula. Right.
Jordan Wilson [00:10:51]:
So both in Google sheets and Excel, because sometimes if you like are one character off or if you put a space after a comma or something like that, it just doesn't work. Or you're like, well, does a formula exist? This is one of those things I demoed early on, when, Google Gemini first came to sheets and just didn't work. And I'm like, this thing stinks. Now it's really good. Right? So you can just say in natural language, you know, write a formula to calculate the commission, 15% for sales in column c. Right? So you don't have to know the exact formula. That's a very simple example, but that's what I wanted. And then you can apply it obviously to your entire dataset.
Jordan Wilson [00:11:33]:
Formatting and actions, kind of the next big use case category. So that's how you can just make important data stand out visually without having to figure out like, oh, how do I do that in the menu? How do I apply, you know, a formula first and then go in, put some conditional formatting in. You can just say something to, Gemini and be like highlight all rows, highlight all the rows where the status is overdue in red. Right? Or, you know, putting things in, you know, red, yellow, green according to where they fall at on a certain scale. Simple. Just talk to Gemini in natural language. Say, hey, I'm trying to visualize, you know, what's good, okay, and bad. Good, here's an example.
Jordan Wilson [00:12:19]:
You know, if if if I look at column c, a good would be a 20, an okay would be a 10, and a bad would be a five. Go ahead and make these colors accordingly and do it all for you. Right? Normally, might take two, five, ten, thirty minutes. If you're not very good at sheets, now you can do it in a single prompt. Very, very useful. Alright, let's go and talk about some time saving tasks. So this is where I'm gonna be jumping around, between my little, Gemini Canvas here, going over some of my notes and then going into some actual spreadsheets here, and we're gonna be, running some of these examples live. So number one is just, well, discovering what's possible.
Jordan Wilson [00:13:06]:
This is something that I think most people overlook when it comes to AI. We always think, oh, well, AI is only going to be able to produce something that I tell it to. Right? Maybe there's a certain skill or a certain insight I know I need to pull. So I'm gonna ask an AI to do that. Well, what about just discovering what's possible? I don't care, you know, and I'm not just talking about this and the, the lens of Google Sheets. I'm just saying in general, large language models are smarter than us all. Alright? If you still think you're smarter than a large language model like Gemini 2.5 or, you know, any day now when Gemini three drops or, GPT five thinking, yeah, you can always, you know, throw one or two prompts in there intentionally and it'll get it wrong, but it's going to get 99.999% of things, correct, way better, way faster, way more consistently than the smartest humans out there. So discovering what's possible is actually a big unlock that people aren't thinking about.
Jordan Wilson [00:14:12]:
You know, you might look at this, you know, a spreadsheet in Google Sheets and, oh, okay. Well, well, I just need to find the difference between column c and column d, and that's gonna tell us our profit. What are those things in there that might you might be missing? Alright. So discovering what poss what's possible is huge. So, you know, doing something like summarizing column B and three bullet points. Okay. Simple. Creating a pivot table, but I'd like to just say like, what is possible? So I'm going to go ahead and I'm going to open up, Yeah, I'm going to open up this.
Jordan Wilson [00:14:44]:
Yeah, we're good here. So I have a spreadsheet and this is reviews that people have given us, for everyday AI. So, there's a couple 100, maybe six or 700 reviews in here. No emails, you know, all of this stuff is public on our website anyways, but it's in a spreadsheet form now. So there's a date, the, the person's name, their title, who they work for, and then their actual review text. Okay? So all I'm gonna do is I'm just gonna go and now click the Gemini icon in the upper right hand corner. So if you're in Google Sheets, if you are on a paid plan, which many people are, look for that Gemini icon in the upper right hand corner. It's gonna be by your profile icon.
Jordan Wilson [00:15:27]:
And then I'm just gonna, there's you can chat with Gemini like you would on any sidebar chat. Okay. So you don't have to be inside of a certain cell or highlight anything. So I'm just gonna put a simple prompt. I'm saying, please give me five AI commands I could run on this spreadsheet to either save time or to build or create something of value. Alright. And we are using Gemini 2.5. So it is a thinking model, and I always encourage people, go see exactly how the model is thinking about your question, but we'll save that for another day.
Jordan Wilson [00:16:02]:
So here we go. Here's, five AI commands it's telling me. So maybe I'm looking at this and I'm like, well, there's not a ton of data. There's a rating and that's just well, everything's five stars. There's dates. So it's like, what am I gonna do with this? Right? I can't draw, you know, really strong connections between two different data points. What am I gonna do? Well, here's what I can do. I can summarize the review text column, for common themes and sentiment.
Jordan Wilson [00:16:28]:
That would take a long time. I can categorize the review text into predefined topics. That would be awesome. I can identify key phrases and keywords in the review text that indicate customer satisfaction or dissatisfaction. I can predict the rating for new reviews based on the review text. That would be kinda cool. I don't know how useful it'd be, but it'd be kinda cool to do it. And then the other one said generate personalized response templates.
Jordan Wilson [00:16:52]:
Yeah. Obviously, I would just email these people back and say, Hey, thanks. But you know, if I wanted to save some time, I could say, Hey, you know, something about this part of your review, you know, and use Gemini to pull out, you know, something that I personally liked. Alright. So there's use case, number one is just or time saving task. Number one is just discovering what's possible with AI in spreadsheets beyond just connecting the dots between two different columns. Number two, generate instant dashboards. So a lot of people know, obviously, in whether you're talking about Google Sheets or Microsoft Excel, that you can create line graphs, you can create pivot tables, you can create bar charts.
Jordan Wilson [00:17:42]:
Right? But you can instantly just create different dashboards of value. So I'm gonna do the same thing. So I'm gonna copy this. I'm gonna say generate a dashboard for this spreadsheet that highlights the most important findings. For this one, I'm gonna go into a different spreadsheet. Okay. So I'm now in a spreadsheet that this is all of our podcast data. Alright.
Jordan Wilson [00:18:04]:
So it is, 620 episodes. There's an episode ID, a publish date, a publish status, and then you have downloads over the last seven days, last thirty days, last ninety days, and all time. Alright. So, here's what I'm going to do. I'm gonna toy it around with some things there, so I'm gonna get rid of it. Alright. So now, all I'm gonna do is I'm just going to go in the sidebar of Gemini again, and I'm gonna put in a simple prompt. I'm just gonna say generate a dashboard for this spreadsheet that highlight some of the most important findings.
Jordan Wilson [00:18:41]:
Right? I'm not saying, you know, give me the, you know, podcast with the most downloads because, again, a large language model that could think and reason, and make connections, especially with structured data, it's probably gonna find some things that maybe I didn't. Okay. So with the side the Gemini sidebar, I can toggle it. I can make it bigger or smaller. So I'm just gonna toggle it, make it a little bit bigger here. And it instantly built me out a couple of really helpful bar charts. So nothing, you know, fantastic here in terms of visuals that I maybe wouldn't have been able to build otherwise, but it saved me a ton of time. And I didn't even have to tell, you know, give me the top 10 episodes by last ninety days, you know, versus all time.
Jordan Wilson [00:19:26]:
It just decided, oh, this is probably gonna be helpful. So I can hover over. I can see the, the number of downloads over the last ninety days for some of the top 10, episodes. I can also insert this into the actual spreadsheet. I can preview it or I can copy the chart. So if I click preview, it's going to just pop out a little preview box. Same thing. Give me top 10 episodes by last thirty days, by last seven days, by all time downloads, all time downloads over time, total all time downloads by published stats.
Jordan Wilson [00:20:00]:
And then it broke out some, some bullet points as well. So pretty good. All right. I'm actually going to try a follow-up prompt just for fun. I'm going to say, you know, find me, five more interesting trends that you can graph and make them visual. Alright. I don't know how well that's gonna work, but let's give it a try. I actually haven't really pushed, the new AI mode, in Google Sheets in terms of what it can actually produce visually.
Jordan Wilson [00:20:40]:
So I've seen, you know, the basic charts, tables, graphs, things like that. So I'm actually seeing if I can, you know, push it push it a little bit more. Okay. So, on my second iteration here, let's see what it did. I'm trying to find my prompt. Now I'm lost. Okay. Okay.
Jordan Wilson [00:20:59]:
So just give me some more, bar charts, things like that. So nothing mind bogglingly good, but some pretty helpful stuff like, okay, September, we had our most downloads. I knew that already, but, you know, it's nice to be able to pull those together. I could first, use, AI mode to categorize all my episodes and then I could create new visualizations, with, data that I didn't have before. That's the thing with large language models creating, essentially structured data from unstructured data. Right? So obviously in the spreadsheet, I have a little bit of both. Something like download numbers, that's very structured. Right? Episode titles, not structured.
Jordan Wilson [00:21:44]:
Right? So I could go in and, categorize them, by different topics, by different trends, and then from there, I could create even more and probably better visualizations inside Gemini. Alright. Let's go to our time saving task number three. Well, running sentiment analysis. This is huge, and this is actually a two pronged thing because I'm gonna do this using a gem. So you can save so much time, you know, and if you've never done sentiment analysis before, it's extremely helpful. This is something in one of my old businesses, that I owned. We used to do this a lot for clients, and we charge a lot of money because it took a lot of time and expensive software, and clients obviously found a ton of value for it.
Jordan Wilson [00:22:29]:
So now you can literally just do it inside Google Sheets, and it takes no time at all. So, let's do an example. So now I'm gonna go back into my, my reviews data. Okay? So I'm gonna click the ask Gemini in the upper right hand corner. I'm actually going to click, clear history. All right. So we can get a clean, start here. And now you can see, there's always some suggestions.
Jordan Wilson [00:22:55]:
There's a summary of content in the sidebar. I didn't really go over that, but one thing I want to call out is gems. Okay? So I have all my gems. Gems are essentially, like if you've used chat g b t, these are like GPTs. These are custom versions of Google Gemini, that mainly you would think, oh, I'm just gonna use them in Gemini, but you can actually use them inside Google Sheets. That's huge. So this is actually like a two, you know, number three here is two pronged. So it's using gems, but in this case, I'm using a gem to run a sentiment analysis because there is a pre built Google gem for sent, a sentiment, analyzer.
Jordan Wilson [00:23:35]:
And all I have to do is click this and, I can just click any of these or I can, I'm actually for this one, I'm gonna do the new AI function. Alright. So same thing, I could go in and, and use a gem. I actually, because the gems are prebuilt, I want a little bit more fine tuned control over exactly what we're extracting. And again, think of how long it would take me, to pull certain sentiment, not just like positive, negative, you know, things like that, but to actually pull useful and helpful sentiment from 600 reviews. Right? And some of these reviews are, you know, ten, fifteen sentences long. They're they're they're longer reviews. Right? So, now what I'm gonna do is I'm gonna use the new AI function.
Jordan Wilson [00:24:22]:
So I'm gonna click the, kind of just the next cell over some, typing this into an empty cell. So, I just pasted it in, but the new, function is equals a I bracket. Okay? We'll put it in our newsletter. If if if you're, you know, on the podcast, you're like, what the heck? What does that look like? Don't worry. We'll put it in there. It's all over the Internet. But essentially, you just type in in an empty cell equals a I bracket, and then in parentheses, you just type a natural language prompt. So I'm saying categorize the customer feedback into the biggest value they received.
Jordan Wilson [00:25:01]:
And then I put a, a cell to start with. So in this case, it's cell E two and that's all I do. I'm gonna click enter. Alright. I'm not gonna apply it to everything because it's gonna take a long time. So just like that in three seconds, this person, Carlos, thank you for the review, Carlos. So what Carlos got the most out of it was, practical knowledge and enjoyable delivery. Okay.
Jordan Wilson [00:25:29]:
So now I can, drag this cell and I'm just gonna go ahead and do, we'll just do like, five more. So, I didn't wanna do this through the whole sheet. It was gonna take forever. I didn't know if the first one would generate or if it would take that long, but alright. It's done. Alright. So now I know, Michael, what he got most out of everyday AI was staying up to date with AI changes. Tyler, was career, acceleration and impact.
Jordan Wilson [00:25:55]:
Andrew was actionable insights, and, Ritesh was staying up to date on AI. This is so helpful for me. Right? I obviously read all these reviews when they come in, but some are from years ago. Right? And maybe I'm seeing, oh, maybe two years ago, people were saying that, you know, they were getting much more practical value and maybe now it's helping them think about work better. Right? So even reading these, testimonials, I would not be able to pull the same kind of insights that now I can get in literally seconds with Gemini in sheets. Alright. Let's go to our time saving task number four, and that is creating content at scale. Yeah.
Jordan Wilson [00:26:35]:
This is a content machine. The other thing, I'm not even demoing this, because Paige actually did a great, job of this, on our episode, that we did, last week. So go listen to episode six nineteen. If you wanted to do that do that, but anything that you would normally like Google, you can all also pull that in. Right? So the example I think she did was pulling in, like, addresses for soccer stadiums in an instant. Right? So versus having to Google them all and then copy and paste and format the addresses correctly, Anything that you would normally query on Google, you can pull that in instantly. Right? One other thing to, keep in mind and maybe I'll demo this first. Here, this is just a a bonus one, I guess.
Jordan Wilson [00:27:17]:
Wait. Let's, let's do the right thing here. So when you do go into, Google Sheets now, there is a new thing that just says help me create a table. So, I can just click that and then I can just talk in natural language. So it says create a table that and I'm gonna say I'm gonna say, shows me the, 10 of most popular Chicago, restaurants. I can't type live. So fun. By, you know, I don't know, popularity.
Jordan Wilson [00:27:51]:
Alright. So then I can just click enter, and I'm guessing it's going to put the restaurant oh, it's done. Yeah. This these are good. These are all pretty, pretty popular, pretty popular restaurants. So what it did is it pulled information. So, let's see if any of these are some of my favorites. Okay.
Jordan Wilson [00:28:09]:
I like I like Piccolo's, I like Piccolo Sonio. Right? So, it not only pulled in these restaurants, but it pulled in the, the category. So that's Italian, and then had the average rating which was a 4.4. And then the number of reviews, 19,000 popularity ranked much must try dish. Right? So it created a really good looking spreadsheet just like that. So, I should have put that on my list, but, yeah, you don't even have to start with a spreadsheet. So if you're doing, competitive analysis, market research, anything like that, it can be very niche, and Gemini does a great job at pulling in, up to date and relevant information. So really really good.
Jordan Wilson [00:28:50]:
So that was just, I guess a little bonus there for you. But let's get back to creating content at scale. Right? So that was another way I wanted to demonstrate that you don't even have to start with content, that you can just create content from scratch. But in this case, I'm gonna go back to I'm gonna go back to my stats, in my downloads. Okay? So I'm gonna do the same thing. I'm gonna do a AI function. So I'm just going over to an empty cell, and I'm putting in equals AI bracket, and then in parenthesis, generate an email subject line based on the episode title in, cell a two. Alright.
Jordan Wilson [00:29:29]:
So, pretty simple there. I'm gonna hit enter. And what it's doing is it's reading, the title of the podcast, and then it's thinking, well, maybe I should rearrange this a little for an for an email headline. Alright? Did a really good job. Again, same thing. I can, you know, go apply this to the next, you know, five or six, different, different, different episodes there. And then I could keep going. Right? And then I could play off of what I just created, and maybe I wanted to write an intro.
Jordan Wilson [00:30:04]:
Right? I didn't play for this one, so let's see how this goes. I'm gonna do the same thing. I'm gonna change this to I two. Let's see if this works. And I'm gonna say generate an intro subject line for an email based on the, email, subject line in, I, so let's see if that works. Bam. Okay. Perfect.
Jordan Wilson [00:30:36]:
Yep. Did a pretty good job there. Yeah. Okay. Sorry. I'm rearranging my, my, my sheets here. Yeah. So not the best, but I probably could have given it a little bit more, direction.
Jordan Wilson [00:30:51]:
So, you know, you have to think, you can keep building. Right? So let's say, I don't know, you have, a spreadsheet with products and you don't have descriptions. Yeah. You can use Google Gemini to create descriptions, but then from that description, you could, you know, create in quick email or a bullet point of, you know, why someone might wanna buy that thing based on the AI description. So, you know, you can keep building off of what you use Gemini AI to build. All right. Let's go to our last use case, which is to spot non obvious trends. This one might take a little while, so let's just get straight into it.
Jordan Wilson [00:31:28]:
All right. So I'm going to go ahead and delete this column. I am back into, I'm back into my stats and this one is might take a while. So I'm gonna pull out, I'm gonna clear my history here and I'm pulling out the sidebar, in Google Gemini. So what I'm doing is I'm saying, find me 10 non obvious trends that have the biggest episode, the biggest impact on episode downloads. Alright. Okay. So what's interesting is I did run this earlier, and I got a much better results, so I'm not sure why.
Jordan Wilson [00:32:10]:
So I'm going to try it again. I'm going to say, find me 10 non obvious trends that had the biggest, the biggest impact on episode downloads. I'm gonna say, don't, don't state, low hanging fruit instead, think carefully, spotting and unearthing trends that even a seasoned data analyst might miss. That would be, immensely helpful. Alright. So, yeah, just typed out a little bit more, of a prompt there. There we go. I wanted to take a little bit more time, to go through and really think a little bit.
Jordan Wilson [00:32:57]:
So, unfortunately, you know, you don't have like a model selector like you would in Gemini. Right? Oh, I can't say, oh, use Gemini 2.5 pro or like an AI studio where I can set a thinking budget. But here we go. Now it's taking a good, thirty thirty plus seconds here, to go through. I'm looking at it, think about my data, which is good. So now what I would do is I would go back and I would read this summarized chain of thought and, you know, see how it kind of came to its conclusion. Sometimes, you will get more out of seeing how a model like this thinks through your spreadsheet than maybe the, you know, 10 trends or 10 pieces of advice or, you know, 10, KPIs that are maybe off target. Sometimes you're gonna get more by seeing how it came to those conclusions versus just, how it came or versus just the answer.
Jordan Wilson [00:33:48]:
Right? So I'll read a couple of these. I'm not gonna read all 10. So it said number one, it said hyper niche, timely, deep dives, outperform general news aggregations. Two, the early bird advantage for weekday releases. So looks like, the earlier I publish the podcast, the better it does. Let's see. Google and Gemini, are stronger download drivers than Microsoft or Chad GPT and titles. Oh, interesting.
Jordan Wilson [00:34:15]:
Alright. It also says that the longer, more descriptive title sweet spots for niche topics. So it's actually drawing multiple conclusions. So it's looking at the number. It looks like it was categorizing, you know, niche versus broad topics, and then also coupling that, with the length of an episode. So it found out that, well, if I'm doing something niche, it's better to have a longer, more descriptive title versus if I'm doing something niche, having a short episode title. So, some pretty good stuff in here, but, you know, I highly especially if you are someone that spends whether it's an hour a week or an hour a day, in spreadsheets, you can't afford to not use this. Right? If you checked out our episode yesterday, I did go over, Microsoft's new agent mode.
Jordan Wilson [00:35:12]:
So I did go over a couple of things you can do similarly in Excel, and I think that's really powerful. It's much more agentic, but it's a little slower. Right? So one thing that I like about using Gemini in sheets is it is, it is fast. It is fast. It is powerful. It is robust. And hope, hopefully you saw I'm using it almost like a brainstorming partner, in spreadsheets, right? I'm okay at spreadsheets, you know, writing formulas, doing filters, things like that, but it's really looking beyond and beneath, kind of the actual stats in your spreadsheet. Alright.
Jordan Wilson [00:35:47]:
I hope this one was helpful. Y'all, you know, putting AI to work, and we all work in spreadsheets. So, do you like this? Should we do more of these, you know, spreadsheet, PowerPoint, right? Sometimes you look at it and you're like, oh, this is a little boring, but I don't know. Is saving time boring? Maybe. But I hope it's useful and I think this is going to be practical for a lot of people out there. So, thank you for listening. And I did say at the beginning, hey, we have this Sora, some Sora codes. So, Chat GPT did release Sora two, extremely powerful.
Jordan Wilson [00:36:26]:
It's mind bogglingly crazy good. If you didn't see it, we shared about it in our newsletter yesterday. We're probably gonna share about it again today, but we do have some invite codes. So even if you're on the $200 paid plan, you can't just get in. You gotta have an invite code. So, go repost this show on LinkedIn, and I'm going to randomly choose one person. Put it in a little, you know, random name generator of all the people that, reposted the show. Okay.
Jordan Wilson [00:36:55]:
So if you're listening here live, it's for LinkedIn only. Just go find this post and then click repost. Also, if you're listening on the podcast, I always put the link, to the LinkedIn post in the show notes. So you don't gotta go looking. You just gotta click it, click the repost. It takes five seconds. So if you do want access to Sora two, I got a code with, well, maybe your name on it. So I'm not gonna, let this one last for long.
Jordan Wilson [00:37:24]:
I'll announce it in Thursday's newsletter, so you also gotta be signed up for the newsletter. Alright. And you can do that at youreverydayai.com. Alright. Thank you all for tuning in. Hope to see you back tomorrow and everyday for more everyday AI. Thanks, y'all.