.png){kind=logo}
ChatGPT, the new sensation in the AI world is known for generating ideas. Business houses that use Google sheets most of the time to record ideas perhaps can take a clue or one from the OpenAI's chatbot. To avail of this service, one needs to have access to its API which is not publicly available yet. However, there is a way to integrate the ChatGPT into Google sheets. ChatGPT is built above GPT-3 and fortunately, OpenAI provides its API. Though GPT-3 API needs you to have a limited amount of credits for access, users can send hundreds or even thousands of requests before paying for more credits.
GPT-3 can understand complex prompts and instructions therefore integrating GPT-3 with Google sheets with a built-in function like Google Script shouldn't be a problem. When invoked, the function sets up a custom function that sends a request along with the concerned prompts to the OpenAI API.
Go to Google Sheets and click "Extensions>Add-ons>get add-ons". You will see a Google Workspace Marketplace dialogue box. Type "ChatGPT" in the search bar that is in the top right corner. Select Google Sheets for Windows and Docs. After the installation is complete, you need to enable chatGPT integration into the Google Sheets.
Before that, you need to have an OpenAI account with a valid OpenAI API key. Once you have the key, integrate chatGPT by clicking "Extensions>GPT for Sheets and Docs> Set API Key. Further to enable GPT functions, click "Extensions>GPT for Sheets and Docs>Enable GPT Functions".
Now that integration is complete, implementing it shouldn't be a tough call. ChatGPT offers a huge stack of functions you can call by typing =GPT ().
For example, if you need chatGPT to tell you the average of entries for a certain number of cells, the function can be called in the following way.
=GPT ("write the average of the cells from 101 to 200")
Join our WhatsApp Channel to get the latest news, exclusives and videos on WhatsApp
_____________
Disclaimer: Analytics Insight does not provide financial advice or guidance. Also note that the cryptocurrencies mentioned/listed on the website could potentially be scams, i.e. designed to induce you to invest financial resources that may be lost forever and not be recoverable once investments are made. You are responsible for conducting your own research (DYOR) before making any investments. Read more here.
