Now you can use ChatGPT using your google account in excel for free with brilliant features. Here is how to start.
First go to google docs account using this link Google Docs
Login your google account and open Doc / Excel document:
Go to Extensions > Add-ons > Get add-ons
Now Search for GPT for Sheets and Docs and install it.
Once it is installed, you can use it using side bar prompt menu.
to Use in Excel spredsheet write =GPT(“your prompt here:”)
Google Sheets
- Install GPT for Sheets: Go to the Google Workspace Marketplace and install the GPT for Sheets add-on.
- Set Up: Open your Google Sheets document and navigate to the GPT for Sheets tab.
- Enter API Key: If required, enter your OpenAI API key in the add-on settings.
- Use Functions: Use various GPT functions directly in your cells, such as:
=GPT("Create a blog post title for the following topic:", A2)=GPT_TRANSLATE("Good day, how are you?", "French")=GPT_EXTRACT("I worked 5 years at Amazon.com and then 3 years at Apple.", "companies")=GPT_CLASSIFY("I did not like this movie at all...", "positive, neutral, negative")
Google Docs
- Install GPT for Docs: Go to the Google Workspace Marketplace and install the GPT for Docs add-on.
- Set Up: Open your Google Docs document and navigate to the GPT for Docs tab.
- Enter API Key: If required, enter your OpenAI API key in the add-on settings.
- Use Functions: Use various GPT functions directly in your document, such as:
- Generating text, summarizing content, translating text, and more.
These add-ons allow you to integrate ChatGPT into your Google Docs and Sheets, making it easier to automate tasks, generate content, and analyze data.
Would you like more detailed instructions or examples on how to use specific features?