A few months ago, everyone was amazed by the ability of a chatbot to have answers to nearly every question you ask. Now, OpenAI allows you to integrate ChatGPT with other products we use in our daily lives! In this article, we want to show you how to use ChatGPT with Google Sheets and maximize the potential of an already feature-rich Google product.
This works by generating an API key from OpenAI and adding it to the Google Sheets extension. Yes, that sounds complicated and you can assume that there is a lot of technique involved, but trust us – the process is very easy.
After you install the GPT for Sheets extension, we’ll show you the capabilities it brings to Google Sheets. Follow up.
Also read: 20 best free online AI tools for your business or personal use
How to connect ChatGPT with Google Sheets
There are two steps you need to follow to use ChatGPT with Google Sheets.
- Generate API key from OpenAI.
- Download and set up the GPT for the Sheets Extension.
Now let’s start with generating API key from Open AI.
1. Generate OpenAI API key
OpenAI has made it possible to connect ChatGPT with other products and applications using API keys. An application programming interface key – or API key is a tool used by developers that allows them to connect and integrate different services for users.
Once you’ve downloaded the API key, you’ll be able to allow the Google Sheets extension to use ChatGPT. Here’s how to download the API key from OpenAI.
Step 1: Visit OpenAI’s website.
Step 2: Sign in with your OpenAI account or create one if you don’t have one.
Step 3: Click on your profile picture in the top right corner and select ‘View API Key’.
Step 4: Click the ‘Generate New Secret Key’ button. This will generate an API Key.
Step 5: You will have an option to name the API key and once it is previewed for you click on the copy button.
That’s it – the API key is now generated and you can use it to integrate ChatGPT and Google Sheets. Let us see how to do it in the next section.
2. Download and set up GPT for Sheets extension
Step 1: Open Google Sheets on your web browser.
Step 2: Now click on Extensions -> Add Extensions -> Get Add-ons.
Step 3: Using the search bar, search for the ‘GPT for Sheets’ extension.
Step 4: Select the extension.
Step 5: Install the Extension. Click the Install button.
Step 6: Select the Google Account you want to link and click Allow to grant permission so the extension can help you use ChatGPT on spreadsheets.
Step 7: Click Next.
Step 8: Click Done to complete the installation process.
Step 9: Now, go back to your spreadsheet. Click on Extensions -> GPT for Sheets and Document -> ‘Launch & Enable Functions’.
Step 10: Paste the API key you copied and click Next.
You will get a response stating that your OpenAI API key is valid.
Step 11: Finally, click on Extensions again from the toolbar. Click GPT for Sheets and Document -> Launch & Enable Functions.
That’s it – that’s all you need to do to install and activate the extension. In the next section, we’ll see how to get the best out of it.
Get the best out of ChatGPT with Google Sheets
ChatGPT is definitely one of the most capable tools at our disposal. And with the extension you just installed, you can also use ChatGPT’s capabilities on your Google Sheets spreadsheet.
All you need to do is use the ‘GPT_()’ function and enter your instructions in parentheses. However, there are also some predefined functions such as GPT_LIST (which provides a list of items based on your command) and GPT_TABLE (which tabulates the results of your ChatGPT command).
Let’s look at all the functions together with an example prompt or command.
10 Functions Using GPT for Sheets on Google Sheets
Here are some functions you can use with ChatGPT on Google Sheets :
| FUNCTION NAME | FUNCTION FEATURES | FUNCTION FEATURES |
| GPT | This function only allows you to use the results of the ChatGPT prompt in a cell. | GPT(“Writing a preamble to a financial statement”) |
| GPT_LIST | Export the results of ChatGPT prompts as a list in consecutive cells of a column. | GPT_LIST(“List of top ten countries with highest GDP”) |
| GPT_TABLE | Export the results of ChatGPT prompts as a table. | GPT_TABLE(“world top ten currencies and their conversion rates to USD”) |
| GPT_EDIT | Helps you correct typographical and grammatical errors in a given text. | GPT_EDIT(“total accounts for 2021”)Fixed the use of the word ‘acount’ and grammatical errors in the sentence. |
| GPT_EXTRACT | Helps you extract data from text and output it as comma separated values. | GPT_EXTRACT(“My name is Supreeth, I work at Guiding Tech”, “name”, “companies”) |
| GPT_SUMMARIZE | Summarize the text in a cell or a range of cells. | GPT_SUMMARIZE(cell address) |
| GPT_TRANSLATE | Translate text in a cell. Works better when the source language is specified. | GPT_TRANSLATE(“Hello, Good Morning”, “French”) |
| GPT_CONVERT | Convert from one format to another. Example – xml to json. | GPT_CONVERT(“
“json”) |
| GPT_CODE | Helps you generate the code according to the details in the prompt. | GPT_CODE(“concatenate two strings”, “Python”) |
| GPT_CREATE_PROMPT | Helps you join cells and create reminders from discrete data. | GPT_CREATE_PROMPT(cell range) |
That’s it – that’s everything you need to know about using ChatGPT with Google Sheets. However, if you have any further questions, check out the FAQ section below.
ChatGPT and Google Sheets FAQ
1. GPT extension for Sheets not working for me. What do I do?
Make sure you have enough credit on your OpenAI account. You can check it in the Usage preferences in your account. However, the shortcut also depends on ChatGPT’s server. So if it is corrupted, you need to wait until it is restored.
2. I got a warning saying ‘Your API key is not working’ on GPT for Sheets on Google Sheets. What do I do?
Try generating another OpenAI API key and paste it in the extension. Or you can wait a while until the API key is activated.
Use Google Sheets like a pro
We hope this article helped you use Google Sheets and ChatGPT and maximize the capabilities of Google’s free spreadsheet tool. The AI revolution seems to have arrived, and if there’s one thing we all need to be good at, it’s writing reminders! Therefore, check out our two comprehensive guides that will help you write better reminders for Dall-E 2 and ChatGPT:
- Top 7 tips for creating stunning photos with Dall-E 2.
- 7 tips for writing effective ChatGPT reminders for best results.
Categories: How to
Source: thpttranhungdao.edu.vn/en/
