How to use ChatGPT with Google Sheets

Introduction

Hi everyone, Michael here. Today we're going to take a look at how you can use AI inside of Google Sheets. Right now, it can do some pretty amazing things like write complex formulas and then have it explain it back to you in simple English. You can also do things like summarize text and analyze sentiment. Let's go take a look.

Today we're going to be using a third-party tool called Numerous.AI in conjunction with Google Sheets. It's free to try out and use, but if you use it a lot, it will cost some money. You can download it up in the top right-hand corner or down below in the description.

Here we are on the NumerousAI home page. There are a lot of tools coming out right now that offer this functionality, but I like Numerous.AI because it handles so many different scenarios very well and for some reason, Google doesn't offer this functionality yet itself. You can scroll down on Numerous.AI's homepage and check out additional scenarios that you can use their tool with, but for now, I'd like us to click install in the top right-hand corner.

Now that we've installed the Numerous.AI add-on, we can use the functionality within Google Sheets. It'll query ChatGPT directly if you want help with the functions, which I usually do when I start using a new add-on. You can go up to the top toolbar here and select extensions, then scroll down to Numerous.AI and select show sidebar.

The Numerous.AI sidebar is really helpful because it gives us prompts to use when we're generating functions. I'm actually going to walk through some of these functions right now to help me get my work done here for the Kevin Cookie Company. The first thing I'm going to do is close the sidebar even though I just said we'd open it. I kind of know what I want to do right now.

I want to create descriptions for cookies off here on the left. My boss has asked me to come up with some body text that includes a description for each of these cookies along with its corresponding price. I don't want to do this manually, and that's probably why you're here in this video too. You don't want to do all this manually. So, I can actually write a formula to do this.

The formula here will be equals write, which is one of the prompts that we saw for a function over here, and I'm telling it to write a description about this cookie, with the cookie being in A8 in this case chocolate chip. I want you to write a description in an enthusiastic tone in one sentence and include the price listed here in B8 which will be 550. You can see that that is exactly what ChatGPT has done for us, and it is pretty good.

And there you can see the function inside of it working as intended, but you could go out and then control copy-paste as values if you want, and that way you won't have the formula anymore. But I'm not done with the formula yet. I actually want to expand this down to the bottom and see if it will do it for all of our cookies. It takes just a second to load, but I promise you it's going to be worth it. And there you have it. Oatmeal raisin Snickerdoodle all covered. And let's double-check to see if the prices are included. It says here row 15, 225. Let's double check that, yup, 225. Everything seems to be matching up nicely.

While our descriptions are pretty helpful, there are a few errors I noticed when reviewing them at first. You can see up here that it says 0.5 and here it says two and then the word dollars. And even down here of the three the dollar sign is behind through three and I want that in front of the three. And this is just a great example of how ChatGPT is really helpful but still imperfect. You're going to want to check your work all the time when you use these kinds of AI assistant features.

You might be wondering why you can't just go directly to ChatGPT and come up with descriptions there. You could, but these would have to be entered in one row at a time and you'd have to specify the price each time. This is helpful because you can do it in bulk, and it is the power of Google Sheets and bulk editing and data management altogether paired with ChatGPT, and it just saves you a lot of time and headache.

And now that we've wrapped up filling in all the descriptions of their prices, I still do have some work left to do for the cookie company. So, we're going to move on to our next example.

My next assignment for my job is to find out the names of our customers who sent us some feedback. I want to parse their names out from their customer email addresses so that we can give them a more proper greeting when we write back to them. To do this, I am going to want to generate a formula and to find out how to do that I will go up to extensions here in the ribbon toolbar, scroll to Numerous.AI, and select show sidebar.

Once it has reappeared, I will go to generate formula and I will describe in plain English the formula I would like this tool to generate. So, I will give that a try. I will say extract everything to the left of the @ symbol in column A. Let's see what it does.

It has produced a formula for us. It says equals left, a colon a. Alright, let me give this a try. Copy it and I will paste it over here, or you could alternatively just hit insert into cell. Maybe I'll try that.

And look at that. It did it! Over here, we have kate@cookiecompany.net and here it populates her first name Kate. It's wonderful that the formula worked, but I don't fully understand what the equals left formula means. So, I'm going to copy it and scroll down to explain formula in the formula here and click explain formula. It says this formula returns the leftmost characters in column A up to the first @ character, and that's actually what we wanted it to do. I find this to be a very helpful and simple basic explanation.

Next, to expand the names down, I will click right here, double click actually, and we can see that the formula has worked. As I mentioned earlier, you can select all of these names and do a control copy and then paste it as values so you can get rid of the formula if you'd like.

My next task is figuring out whether the feedback we received from our Cookie Company customers is positive or negative. First, I will close the sidebar. I'm going to train the model we're going to use next, so I'm going to have to do a couple of manual reviews first. The first piece of feedback says I was disappointed with the size of the cookies I received. Well, I don't know what they were expecting, but I suppose I should jot this down as negative feedback. Just below it says, I recently tried Kevin's chocolate chip cookies, and they were amazing. Okay, what we like to hear: positive feedback.

Next is where the magic is going to happen. I will go back up to extensions, go here, show the sidebar and I'm going to check to see what I want to use, and I want to use infer. This is what we're going to use next. Yep, this is where you can look at sentiments of things, positive or negative, double checking this is what we want. I'm going to write equals infer.

It says to target some example inputs, the example inputs in this scenario are the blocks of feedback, the example outputs will be the negative and positive sentiments here. So, I'll select those two and then it will say the target input which will be this unscanned block of feedback, and then I will put a parenthesis around it and run it.

It says loading, and it has quickly figured out that "I love that the Kevin Cookie Company uses these high-quality ingredients in their cookies" is indeed positive feedback, and now I'm going to fill in the rest of the rows in column D10 by double-clicking right down here.

It's starting to approach the end of the day here at the cookie company and my boss has asked me if there are any standout pieces of feedback that they should be aware of. I've scrolled down and noticed that a user or a customer rather has left a large block of text for me to digest. I want to see if ChatGPT can summarize this for me into some bullet points, so I'm going to use one of their summarize functions.

You can see up here I've asked the AI to summarize this into three bullet points, this being all of the text in cell B15. It has done a pretty good job. It says the cookies arrived stale, the customer service was apathetic, and also a positive experience was not achieved, so I do think ChatGPT did a really good job of summarizing this for me.

There's one last thing I want to touch on before we end here today, and that is that everything we've done here so far has been completely free. But if you want to use Numerous.AI quite frequently or want to use a lot of queries against ChatGPT, they do run on what's called a token system. They start you off with 60 free tokens. Each token is used when you create a new function, and if you want to have more tokens you can always choose to upgrade here, but I want to reiterate you can do a lot of really interesting stuff for free.

Wow, that is pretty groundbreaking stuff. I don't have to remember every Excel formula or Sheets formula I want to use. There are so many assistants now that can help me do it. I really wish these things were around when I was just starting out. In the future, I don't know if we're going to need third-party integrations, as I think Google and Microsoft are going to incorporate these into their products, but for now, this is really useful, and I suggest you try it out.

For more content like this, please consider subscribing, and we'll see you in the next video.

Thank you!

Keywords

• AI
• Google Sheets
• ChatGPT
• Numerous.AI
• Formulas
• Sentiment Analysis
• Summarize Text
• Data Management
• Bulk Editing

FAQ

Q: What is Numerous.AI?

A: Numerous.AI is a third-party tool that integrates with Google Sheets to provide AI functions such as generating formulas, summarizing text, and analyzing sentiment through ChatGPT.

Q: How do I install Numerous.AI?

A: You can install Numerous.AI by going to their website and clicking the install button in the top right-hand corner. It will integrate directly with Google Sheets as an add-on.

Q: Can I use Numerous.AI for free?

A: Yes, Numerous.AI offers 60 free tokens that you can use when you create a new function. If you need more tokens, you will have to upgrade to a paid plan.

Q: Why should I use Numerous.AI with Google Sheets?

A: Using Numerous.AI with Google Sheets allows you to automate tasks such as generating descriptions, parsing email addresses to extract names, and analyzing feedback sentiment. This integration saves a lot of time and effort compared to doing these tasks manually.

Q: Can I go directly to ChatGPT for these functions instead?

A: While you can go directly to ChatGPT, doing so would require you to manually input data and handle each row individually. Numerous.AI allows for bulk processing within Google Sheets, making it much more efficient.