Whether you love creating them or hate using them, spreadsheets are a great way to boost your productivity when doing text-based tasks like summarization, translation, and setting straight lots of data.
And now with the help of AI chatbot ChatGPT, you can leave the task of creating complex formulas to its artificial intelligence, leaving you free from the headache of having to do it yourself or reading through extensive documentation.
So, let’s take a look at a how easy it is to set up ChatGPT Spreadsheet Integration simply by adding the new extension to your Google Sheets. In this article we’ll go over exactly how to do it, and how it works!
ChatGPT Spreadsheet Integration
ChatGPT is all the rage for many computer users these days, so it’s no surprise that this rapidly developing AI technology has now made its way to helping people create and work with spreadsheets.
We’ve already talked about it a fair bit on this site, and there’s clearly a lot of interest in harnessing ChatGPT to level up spreadsheet integration. See also:
- How To Use ChatGPT To Write Excel Formulas
- Combining ChatGPT and Excel/Google Sheets
- How To Do Tables In ChatGPT
The AI chatbot’s parent company, OpenAI, has yet to release a spreadsheet app for ChatGPT. But there are several third-party applications that are available as add-on extensions to Google Sheets through the Google Marketplace, which allow you and seamlessly integrate the two using the GPT application program interface (API).
The third-party application we chose to add on to our Google Sheets is called SheetGPT, which can be used with ChatGPT-3, ChatGPT-4, (as well as the DALLE-2 generative language model) “to supercharge your Google Sheets”.
The third-party application we chose to add on to our Google Sheets is called SheetGPT, which can be used with ChatGPT-3, ChatGPT-4, (as well as the DALLE-2 generative language model) “to supercharge your Google Sheets”
Does this sound too good to be true?
Well, even better: you don’t need to have any programming knowledge to integrate the ChatGPT technology into your Google Sheets.
And unlike other ChatGPT extensions that you could use, you don’t need to login to OpenAI for an API key to get SheetGPT to do its business.
How To Add SheetGPT Extension
In order to install the SheetGPT Extension to your Google Sheets, you’ll need to open a new spreadsheet on your computer. If you haven’t already logged into your Google Workspace account, then now is the time to do so.
When you have a new Google Sheet open, simply click on the Extensions tab, and then on Add-ons, to get to the Get Add-ons options. This will take you to the Google Workspace Marketplace.
If you can’t see SheetGPT on the homepage like in the image below, then you can search for it in the search bar, which you can find at the top right of the screen by typing in “SheetGPT”.
The SheetGPT app looks just like this:
Once you’ve chosen SheetGPT, then click on the Install button. When it is finished (which shouldn’t take more than a couple of minutes) you’ll receive this message:
You may need to refresh your Google Sheet page in your browser in order to see the SheetGPT option pop up in your Extensions tab. When you do, simply click on SheetGPT, and then on Enable SheetGPT.
And just like that, you now have the ability to use ChatGPT with your Google Sheets spreadsheets! You can use it for all sorts of tasks, like categorizing, summarizing, classifying, and cleansing large amounts of open-ended text, creating AdWords copy, and content that is based on SEO keywords.
SheetGPT Extension In Action
When you’re done with setting up SheetGPT for Google Sheets, the endless possibilities to do all sorts of text tasks are now at your fingertips.
However, for this blog we wanted to show you something easy to get you started. We asked ChatGPT via SheetGPT to generate text containing a simple list of three things to do on a warm and sunny day. This was the prompt that we entered into cell A1:
=GPT(“list 3 things to do outside on a warm and sunny day”)
And this is the list that SheetGPT via ChatGPT provided for us:
- Go for a bike ride or hike. Enjoy the fresh air and exercise while exploring your local park or trail.
- Have a picnic or BBQ with friends and family. Find a shady spot under a tree or bring a picnic blanket and enjoy a meal outside.
- Spend time at the beach or a nearby lake. Swimming, sunbathing, and playing water games are great ways to have fun in the sun.
For our next experiment, we wanted to see if we could translate part of the listed text into another language, so we entered this prompt into cell A3:
=GPT(“translate ‘Spend time at the beach or a nearby lake. Swimming, sunbathing, and playing water games are great ways to have fun in the sun’ into Spanish”)
And the AI chatbot did its best to comply:
“Vale la pena pasar tiempo en la playa o en un lago cercano. Nadar, tomar sol y jugar juegos acuáticos son excelentes maneras de divertirse bajo el sol.”
We entered our final translation prompt into cell A5 when we asked for to get French from the previous Spanish text:
=GPT(“translate Vale la pena pasar tiempo en la playa o en un lago cercano. Nadar, tomar sol y jugar juegos acuáticos son excelentes maneras de divertirse bajo el sol. into French”)
And it answered with the following:
“Il vaut la peine de passer du temps à la plage ou à un lac à proximité. Nager, bronzer et jouer à des jeux d’eau sont d’excellentes façons de s’amuser sous le soleil.”
We wanted to see if we could create a table with SheetGPT that showed us the 10 most popular Netflix shows, along with their IMDB rating, and five words to describe the theme of the show:
=GPT(“create a table of the 10 most popular Netflix shows, their IMDB rating and five words to describe their theme”)
When we ran the function, this is what was generated by the AI:
It’s not clear where ChatGPT is getting this information from, as standard ChatGPT cannot search the web, and is trained on data from 2021. If you want to dive into web scraping with ChatGPT, see here.
So as you can see, integrating a ChatGPT AI chatbot into your Google Sheets is pretty simple, and you even have the option to change parameters like the chat model (you can choose from “gpt-4″ if you’re a paid subscriber, or “gpt-3.5-turbo”, which is the default).
And if you’re a Microsoft Office user, then do not be discouraged, because there’s also AI chatbot integration via ChatGPT for you to play with via the GPT Excel add-on, which you can find in the Office Store, or by clicking here.
GPT Excel will work with Excel 2016 or later on both Windows and Mac platforms, as well as Excel on the web.
As far as ChatGPT spreadsheets go, SheetGPT is versatile and easy enough to use for those of us who just want to get the job done. And if you’re already a fan of using Google Sheets, then you will find that SheetGPT is going to become a useful addition for completing your spreadsheet tasks.
Best of all, you don’t need to sign up to SheetGPT to use it. Trial plans are free, which give you the equivalent of 100,000 words of input/output.
If you need higher usage limits, or want to add things like image generation, then you can upgrade to one of the paid plans, which start at $29 per month for 3.5 million words of GPT-3.5 inputs and generation, or about 200 images.
Happy spreadsheet creating!