Everyday AI Podcast – An AI and ChatGPT Podcast - Ep 622: Gemini AI in Google Sheets: What’s new and 5 daily tasks you didn’t know you could do

Episode Date: October 1, 2025

You definitely missed this AI drop 👇AI functions are live inside of Google Sheets thanks to Gemini. I know what you're saying... AI functions? I can barely spread the sheets! That's the beauty of it. With a simple =AI of your keyboard, you can talk to your spreadsheets in natural language and tap into the full power of Google Gemini. Don't worry.... we're gonna put it to Work this Wednesday together. Gemini AI in Google Sheets: What’s new and 5 daily tasks you didn’t know you could do -- An Everyday AI Chat with Jordan WilsonNewsletter: Sign up for our free daily newsletterMore on this Episode: Episode PageJoin the discussion on LinkedIn: Thoughts on this? Join the convo on LinkedIn and connect with other AI leaders.Upcoming Episodes: Check out the upcoming Everyday AI Livestream lineupWebsite: YourEverydayAI.comEmail The Show: [e-mail] with Jordan on LinkedInTopics Covered in This Episode:Gemini AI in Google Sheets OverviewNew AI Function for Formula GenerationNatural Language Data Organization in SheetsDashboard Creation with Google GeminiSentiment Analysis Using Gemini AIAutomating Content Creation at ScaleUsing Gems and Custom Commands in SheetsSpotting Non-Obvious Trends with GeminiTimestamps:00:00 Gemini in Sheets: Gamechanger you didn't catch 05:01 "Google Gemini: Access and Features"07:15 "AI Gemini in Google Sheets"10:03 Instant Insights with Natural Language13:06 "AI's Overlooked Potential"18:07 Creating Podcast Analytics Dashboard21:56 "Efficient Sentiment Analysis Guide"23:22 "Sentiment Analysis with Google Gems"26:35 Content Machine Demo and Tips32:53 Analyzing AI Model Processes34:13 Niche Titles: Longer is Better36:55 "Link and Repost for Access"Keywords:Gemini in Google Sheets, Gemini AI, Google Sheets AI integration, AI in spreadsheets, Google Workspace, AI function in Sheets, spreadsheet automation, natural language prompts, formula generation, data analysis, AI-powered dashboards, sentiment analysis in spreadsheets, generate tables with AI, AI chart creation, visualize data with AI, data organization with AI, contextual integration, summarize spreadsheet content, pull data from Gmail and Drive, AI for business productivity, GSend Everyday AI and Jordan a text message. (We can't reply back unless you leave contact info) Start Here ▶️Not sure where to start when it comes to AI? Start with our Start Here Series. You can listen to the first drop -- Episode 691 -- or get free access to our Inner Cricle community and all episodes: StartHereSeries.com Also, here's a link to the entire series on a Spotify playlist. 

This is the Everyday AI Show, the everyday podcast where we simplify AI and bring its power to your fingertips. Listen daily for practical advice to boost your career, business, and everyday life. Meet Firefly AI Assistant, now live in Adobe Firefly, the All In One Creative AI Studio. Just describe what you want to create and the assistant handles the rest, orchestrating multi-step workflows across Photoshop, Premiere Express, and more in one conversational interface. You direct the outcome, the assistant accelerates execution. 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 kind of makes sense that no one's really talking to them. about it. I mean, look at the last few days alone in the AI world. ChadGPT pulse and chat GPT shopping, Claw and 4.5, SORA 2 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 a new and very overlooked feature in Gemini AI in Google Sheets. I'm going to tell you what's new and 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 news that are 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 live stream podcast. But if you want to be the smartest person in AI in your department, our website, that's where it's happened. That's where it happens. Your EverydayAI.com. Go sign up for our free daily newsletter. As we do every day, we recap the highlights from our live stream 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 poll 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 want to bust out, you know, 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. 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 going to 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 going to go through how Gemini in Sheets works. And the manual task that it can can help replace. I'm going to 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. I'm going to highlight five of my favorite time-saving Gemini AI kind of tips and tricks that you can automate.

All right. So what the heck is Gemini in Google Sheets? Let me be honest. The rollout of Gemini in Google Workspace has been rocked. 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. 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, of simple formula. I'll show you how to do it. You don't have to be technical. You don't have to know coding. You don't even have to be a spreadsheet whiz. If you can type, you know, three or four letters, you can start 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 end 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. And yes, we're going to be doing a couple things live. I'm going to be fumbling around a little bit inside Google sheets. So some of the core functionality, well, 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

of 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 going to show you each. But essentially, you can just prompt. So on the sidebar, you can pop out the Gemini sidebar, and you can just prompt in natural language.

You can have it write formulas. You can have it visualized 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 in Gmail files to inform responses. That's huge. I'm not really going to be demoing that because, you know, blindly pulling in context from certain emails that align with certain spreadsheets. I don't know how it's going to work, right? Like as an example, I talk to a lot of our, you know, partners and sponsors about certain stats on certain podcasts. So I don't want to

accidentally pull in email content. But that's, if you know, 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. 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 619 a couple of days ago. It was with Paige Bailey from Google. The episode was about nanobanana, but she actually walked us through 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. All right, so let's look live, shall we? All right, I'm trying something new here. Normally, you know, if you follow along

on the live stream video side, you know, I usually just had my little canvas slides. 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 going to 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 your EverydayAI.com. Just click episodes and it's there. You know, within 10 minutes after the episode is done debuting live, it's essentially on our website, the video.

So go check it out. All right. So let's first go over a little bit. Let's see here. That's fine. We'll go ahead and do this. Yeah, we have our, hopefully my Chrome here 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, I love spreadsheets. Some people do. Some people don't. Right.

But being able to create little widgets, little dashboards with natural language is such, I think, an untapped level up for everyday non-technical 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, uh, Gemini can just understand your natural language. So, uh, number one, being able to organize your data. Number two, obviously getting better analysis and insights. So not having to look for 10, 15, 20 minutes, uh, 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. So as an example, saying something like, what are the top three selling products this month? Well, what if you work at a large manufacturing company and you have thousands of products, right? Yeah, you might be able to 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 schools? use, right? So yeah, you might be able to, you know, create some tables, some 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-A.I, I would spend so much

time, like Googling things, trying to find the right formula, right? 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 data set. 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. 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. You know, if I look at column C, a good would be a 20 and 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, it might take two, five, ten, 30 minutes. If you're not very good at sheets, now you can do it in a single prompt. Very, very useful. All right. Let's go and talk about some

time saving tasks. So this is where I'm going to 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 going to be running some of these examples live. So number one is just, well, discovering what's possible. 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 going to ask in AI to do that. Well, what about just discovering what's possible? I don't care. And I'm not just talking about this and the lens of Google sheets. I'm just saying in general, large language models are smarter than us all. All right. If you still think you're smarter than a large language model like Gemini 2.5 or any day now when Gemini 3 drops or GPD5 thinking, yeah, you can always, you know, throw one or two prompts in there intentionally. 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. 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 going to tell us our profit. What are there's things in there that might you might be missing. All right. So discovering what possible is huge. So, you know, doing something like summarizing column B and three bullet points. Okay, simple, creating pivot table, but I'd like to just say like what is possible. So I'm going to go ahead. Now I'm going to open up. Yeah, I'm going to open up this. Yeah, we're good here. So I have a spreadsheet and this

reviews that people have given us for everyday AI. So there's a couple hundred, maybe six or seven hundred reviews in here. No emails. You know, all this stuff is public on our website anyways. But it's in a spreadsheet form now. So there's a date, the person's name, their title, who they work for, and then their actual review text. Okay.

So all I'm going to do is I'm just going to go and now click the Gemini icon in the upper right hand corner. So if you're in Google Sheets, if you all. are on a paid plan, which many people are. Look for that Gemini icon in the upper right hand corner. It's going to be by your profile icon. And then I'm just going to, 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 going to 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. All right. 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. 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 going to do with this? Right? I can't draw. you know, really strong connections between two different data points. What am I going to do? Well, here's what I can do. I can summarize the review text column for common themes and sentiment. 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 kind of cool. I don't know how useful it would be, but it'd be kind of cool to do it. And then the other one said generate personalized response templates. Yeah. Obviously, I would just email these people back and say, hey, thanks. But 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.

All right. 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,

right? But you can instantly just create different dashboards of value. So I'm going to do the same thing. So I'm going to copy this. I'm going to say generate a dashboard for this spreadsheet that highlights the most important findings. For this one, I'm going to go into a different spreadsheet. Okay, so I'm now in a spreadsheet that this is all of our podcast data. All right.

So it is 620 episodes. There's an episode ID, a published date, a published status. Then you have downloads over the last seven days, last 30 days, last 90 days, and all time. All right. So here's what I'm going to do. I'm going to toyed around with some things there. So I'm going to get rid of it. All right. So now all I'm going to do is I'm just going to go in the sidebar of Gemini again.

And I'm going to put into some prompt. I'm just going to say generate a dashboard for this spreadsheet that highlight some of the most important findings. Right. I'm not saying, you know, give me the, you know, podcast for the most downloads. because again, a large language model that could think and reason and make connections, especially with structured data, it's probably going to find some things that maybe I did it. Okay. So with the Gemini sidebar, I can toggle it.

I can make it bigger or smaller. So I'm just going to 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 90 days, you know,

versus all time. It just decided, oh, this is probably going to be helpful. So I can hover over. I can see the, the number of downloads over the last 90 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 30 days, by last seven days, by all-time downloads, all-time downloads over time, total all-time downloads by publish stats, and then it broke out 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.

All right. I don't know how well that's going to work, but let's give it a try. Adobe just introduced an entirely new way to create, bringing the power and precision of its creative suite into one conversational experience. Meet Firefly AI Assistant. now live in the Adobe Firefly app, the all-in-one creative AI studio. Powered by Adobe's creative agent, Firefly AI assistant lets you start with your vision, just describe what you want, and shape the outcome as it takes form with the assistant. The assistant orchestrates multi-step workflows, drawing on 60 plus pro-grade tools across Adobe

Creative Cloud apps, including Photoshop, Illustrator, Premiere, Lightroom Express, and more to help bring your ideas to life. You can also get started with creative skills, a growing library of pre-built workflows for common creative tasks, like batch editing photos, creating mood boards, portrait retouching, and creating social variations. Every step the assistant takes is visible so you can refine, redirect, or take over at any time. You stay in the driver's seat as the creative director. Adobe Firefly AI assistant now in public beta. See it today at Firefly.adop.com. I actually haven't really pushed the new AI mode in Google Sheets in terms of what it can actually produce visually.

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.

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, 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. All right, let's go to our time-saving task number three, while running sentiment analysis. This is huge. And this is actually a two-pronged thing because I'm going to do this using a gem. So you can save so much time. 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. So now you can literally just do it in,

side Google sheets and it takes no time at all. So let's do an example. So now I'm going to go back into my, my reviews data. Okay. So I'm going to 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. 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 GBT, these are like GPT's.

These are custom versions of Google Gemini. That mainly you would think, oh, I'm just going to 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 prong. So it's using gems. But in this case, I'm using a gem to run its sentiment analysis because there is a pre-built Google Gem for a sentiment analyzer

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 going to do the new AI function. So same thing I could go in and use a gem. I actually because the gems are pre-built

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, 10, 15 sentences long. They're longer reviews, right? So now what I'm going to do is I'm going to use the new

AI function. So I'm going to click the kind of just the next cell over. So I'm typing this into an empty cell. So I just pay. it in, but the new function is equals AI bracket. Okay. We'll put in our newsletter. If you're 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 an empty cell equals AI 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. and then I put a a cell to start with. So in this case it's cell E2.

And that's all I do. I'm going to click Enter. All right. I'm not going to apply it to everything because it's going to 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. So now I can drag this cell. And I'm just going to go ahead and do, we'll just do like five more.

So I didn't want to do this through the whole sheet. It was going to take forever. I didn't know if the first one would generate or if it would take that long. But all right, it's done. All right. 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. Andrew was actionable insights. And Ratesh was 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 Jevonai in

sheets. All right, let's go to our time saving task number four. And that is creating content at scale. Yeah, this is a content machine. The other thing, I'm not even demoing this, because Page actually did a great job of this on our episode that we did last week. So go listed to episode 619. If you wanted to do that, do that. But anything that you would normally like Google, you can 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 base 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 bonus one, I guess. Wait, 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 going to say I'm going to say shows me the 10 most popular Chicago restaurants. I can't type live. So fun by, you know, I don't know, popularity. All right.

So then I can just click enter. And I'm guessing it's going to put the restaurant. Oh, it's done. Yeah, 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. I like, I like picolos. I like picolosoneo, right? So it not only pulled in these restaurants, but it pulled in the category. So that's Italian. And then it 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. 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 going to go back to, I'm going to go back to my stats in my downloads. Okay. So I'm going to do the same thing. I'm going to do an AI function.

So I'm just going over to an empty cell. And I'm putting in equals AI bracket. And then in parentheses, generate an email subject line based on the episode title in, sell a two. All right. So pretty simple there. I'm going to hit enter. And what is 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 email for an email headline. All right. 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 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 in intro, right? I didn't play for this one. So let's see how this goes. I'm going to do the same thing. I'm going to change this to I to. Let's see if this works.

And I'm going to 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. 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. 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, uh, you know, create in quick email or a bullet point of, you know, why someone might want to 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. All right. So I'm going to go ahead and delete this column. I'm back into I'm back into my stats. And this one is might take a while.

So I'm going to pull out, I'm going to clear my history here. And I'm pulling out the sidebar. Um, in Google Gemini. So what I'm doing is I'm saying, find me 10 non-obvious trends that have the biggest episode, uh, the biggest impact on episode downloads. All right. Um, okay. So what's interesting is I did run this.

earlier. And I got a much better results. So I'm not sure why. So I'm going to try it again. I'm going to say, find me 10 non-obvious trends that had the biggest impact on episode downloads. I'm going to say, don't state low hanging fruit. Instead, think carefully, spotting. unearthing trends that even a seasoned data analyst might miss that would be immensely helpful. All right. 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.

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 30 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 conclusions.

Sometimes you will get more out of seeing how a model like this thinks through your spreadsheet then maybe the, you know, 10 trends or 10 pieces of advice or, you know, 10 KPIs that are maybe off target, sometimes you're going to get more by seeing how it came to those conclusions versus just how it came or versus just the answer, right? So I'll read a couple of these. I'm not going to read all 10. So it said number one. It's said hyper niche timely deep dives outperform general news aggregations to the early bird advantage for weekday releases. So it 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

chatGBT in titles. Ooh, interesting. All right. 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 I highly, especially if you are someone that spends, whether it's an hour of 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. 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 fast. It is fast.

It is powerful. It is robust and 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. All right. I hope this one was helpful, y'all, you know, put an 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, ah, 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 some SORA codes. So Chachybt did release SORA too extremely powerful. It's mind-bogglingly crazy good. If you didn't see it, we shared about it in our newsletter yesterday. We're probably going to 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 got to 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. 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 got to go looking. You just got to click it, click the repost. It takes five seconds. So if you do want access to SORA 2, I got a code with, well, maybe your name on it. So I'm not going to let this one last for long. I'll announce it in Thursday's newsletter. So you also got to be signed up for the news.

newsletter. All right. And you can do that at your everydaya.com. All right. Thank you all for tuning in. Hope to see you back tomorrow and every day for more everyday AI. Thanks y'all. Meet Firefly AI assistant. Now live in Adobe Firefly, the Allman One Creative AI studio. Just describe what you want to create in your own words and the assistant handles the rest, orchestrating multi-step workflows across Adobe Creative Cloud apps, including Photoshop, Premiere Express, and more in one conversational interface. You direct the outcome while the assistant accelerates execution. Stand control with the ability to step in and refine at any time.

See it today at firefly.adobie.com. And that's a wrap for today's edition of Everyday AI. Thanks for joining us. If you enjoyed this episode, please subscribe and leave us a rating. It helps keep us going. For a little more AI magic, visit Your EverydayAI.com and sign up to our daily newsletter so you don't get left behind. Go break some barriers and we'll see you next time.

Thank you.