\n\n\n\n\n\n\n\n
ChatGPT Spreadsheet Integration<\/h2>\n\n\n\n
ChatGPT is all the rage for many computer users these days, so it\u2019s no surprise that this rapidly developing AI technology has now made its way to helping people create and work with spreadsheets. <\/p>\n\n\n\n
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:<\/p>\n\n\n\n
- \n
- How To Use ChatGPT To Write Excel Formulas<\/a><\/li>\n\n\n\n
- Combining ChatGPT and Excel\/Google Sheets<\/a><\/li>\n\n\n\n
- How To Do Tables In ChatGPT<\/a><\/li>\n<\/ul>\n\n\n\n
The AI chatbot\u2019s parent company, OpenAI<\/a>, 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).<\/p>\n\n\n\n
The third-party application we chose to add on to our Google Sheets is called SheetGPT<\/a>, which can be used with ChatGPT-3, ChatGPT-4, (as well as the DALLE-2 generative language model) \u201cto supercharge your Google Sheets\u201d.<\/p>\n\n\n\n
\n
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) \u201cto supercharge your Google Sheets\u201d<\/em><\/p>\n<\/blockquote>\n\n\n\n
Does this sound too good to be true? <\/p>\n\n\n\n
Well, even better: you don\u2019t need to have any programming knowledge to integrate the ChatGPT technology into your Google Sheets. <\/p>\n\n\n\n
And unlike other ChatGPT extensions that you could <\/em>use, you don\u2019t need to login to OpenAI for an API key to get SheetGPT to do its business.<\/p>\n\n\n\n
\n\n\n\nHow To Add SheetGPT Extension<\/h2>\n\n\n\n
In order to install the SheetGPT Extension to your Google Sheets, you\u2019ll need to open a new spreadsheet on your computer. If you haven\u2019t already logged into your Google Workspace<\/a> account, then now is the time to do so.<\/p>\n\n\n\n
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.<\/p>\n\n\n\n
![\"\"](\"https:\/\/aiforfolks.com\/wp-content\/uploads\/2023\/06\/sheetgpt_1-1024x699.jpg\")
<\/figure>\n\n\n\nIf you can\u2019t 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 \u201cSheetGPT\u201d. <\/p>\n\n\n\n
![\"\"](\"https:\/\/aiforfolks.com\/wp-content\/uploads\/2023\/06\/sheetgpt_2-1024x685.jpg\")
<\/figure>\n\n\n\nThe SheetGPT app looks just like this: <\/p>\n\n\n\n
![\"\"](\"https:\/\/aiforfolks.com\/wp-content\/uploads\/2023\/06\/sheetgpt_3-1024x702.jpg\")
<\/figure>\n\n\n\nOnce you\u2019ve chosen SheetGPT, then click on the Install button. When it is finished (which shouldn\u2019t take more than a couple of minutes) you\u2019ll receive this message: <\/p>\n\n\n\n
![\"\"](\"https:\/\/aiforfolks.com\/wp-content\/uploads\/2023\/06\/sheetgpt_4-1024x698.jpg\")
<\/figure>\n\n\n\nYou 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<\/strong>.<\/p>\n\n\n\n
![\"\"](\"https:\/\/aiforfolks.com\/wp-content\/uploads\/2023\/06\/sheetgpt_5-1024x698.jpg\")
<\/figure>\n\n\n\nAnd 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.<\/p>\n\n\n\n
![\"\"](\"https:\/\/aiforfolks.com\/wp-content\/uploads\/2023\/06\/sheetgpt_5b-1024x699.jpg\")
<\/figure>\n\n\n\nSheetGPT Extension In Action<\/h2>\n\n\n\n
When you\u2019re done with setting up SheetGPT for Google Sheets, the endless possibilities to do all sorts of text tasks are now at your fingertips.<\/p>\n\n\n\n
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:<\/p>\n\n\n\n
=GPT(“list 3 things to do outside on a warm and sunny day\u201d)<\/em><\/p>\n\n\n\n
And this is the list that SheetGPT via ChatGPT provided for us: <\/p>\n\n\n\n
- \n
- Go for a bike ride or hike. Enjoy the fresh air and exercise while exploring your local park or trail.<\/em><\/li>\n\n\n\n
- 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.<\/em><\/li>\n\n\n\n
- Spend time at the beach or a nearby lake. Swimming, sunbathing, and playing water games are great ways to have fun in the sun.<\/em><\/li>\n<\/ol>\n\n\n\n
![\"\"](\"https:\/\/aiforfolks.com\/wp-content\/uploads\/2023\/06\/sheetgpt_6-1024x702.jpg\")
<\/figure>\n\n\n\nFor 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:<\/p>\n\n\n\n
=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\u201d)<\/em><\/p>\n\n\n\n
And the AI chatbot did its best to comply:<\/p>\n\n\n\n
“Vale la pena pasar tiempo en la playa o en un lago cercano. Nadar, tomar sol y jugar juegos acu\u00e1ticos son excelentes maneras de divertirse bajo el sol.\u201d<\/em><\/p>\n\n\n\n
![\"\"](\"https:\/\/aiforfolks.com\/wp-content\/uploads\/2023\/06\/sheetgpt_7-1024x615.jpg\")
<\/figure>\n\n\n\nWe entered our final translation prompt into cell A5 when we asked for to get French from the previous Spanish text: <\/p>\n\n\n\n
=GPT(“translate Vale la pena pasar tiempo en la playa o en un lago cercano. Nadar, tomar sol y jugar juegos acu\u00e1ticos son excelentes maneras de divertirse bajo el sol. into French\u201d)<\/em><\/p>\n\n\n\n
![\"\"](\"https:\/\/aiforfolks.com\/wp-content\/uploads\/2023\/06\/sheetgpt_8-1024x616.jpg\")
<\/figure>\n\n\n\nAnd it answered with the following:<\/p>\n\n\n\n
\u201cIl vaut la peine de passer du temps \u00e0 la plage ou \u00e0 un lac \u00e0 proximit\u00e9. Nager, bronzer et jouer \u00e0 des jeux d’eau sont d’excellentes fa\u00e7ons de s’amuser sous le soleil.\u201d<\/em><\/p>\n\n\n\n
![\"\"](\"https:\/\/aiforfolks.com\/wp-content\/uploads\/2023\/06\/sheetgpt_8b-1024x615.jpg\")
<\/figure>\n\n\n\nWe 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:<\/p>\n\n\n\n
=GPT(“create a table of the 10 most popular Netflix shows, their IMDB rating and five words to describe their theme\u201d)<\/em><\/p>\n\n\n\n
When we ran the function, this is what was generated by the AI:<\/p>\n\n\n\n
![\"\"](\"https:\/\/aiforfolks.com\/wp-content\/uploads\/2023\/06\/sheetgpt_9-1024x615.jpg\")
<\/figure>\n\n\n\nIt’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<\/a>.<\/p>\n\n\n\n
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 \u201cgpt-4″ if you\u2019re a paid subscriber, or \u201cgpt-3.5-turbo\u201d, which is the default).<\/p>\n\n\n\n
- 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.<\/em><\/li>\n\n\n\n
- Combining ChatGPT and Excel\/Google Sheets<\/a><\/li>\n\n\n\n