How to use ChatGPT in Sheets

Discover how to use the GPT for Sheets add-on, which brings the power of OpenAI directly into Google Sheets, without requiring you to mess with apps script.

0:00 Intro
0:25 Install GPT for Sheets
1:38 How to use GPT for Sheets
4:52 Use concatenation to create many prompt variations
8:27 Make it remember prior context like ChatGPT

The possibilities of OpenAI GPT-3 are almost endless. This add-on enables a simple custom function =GPT() will help you achieve some tasks such as:
– generating blogposts or subject lines ideas
– writing whole emails or documents
– cleaning up lists of names, adresses, emails or companies
– classifying lists of reviews with sentiment analysis or feature categorization
– summarizing
– writing responses to online comments
– trying different versions of a prompt quickly

In addition, this add-on will let you experiment easily with hyperparameters:
– temperature
– model
– maxTokens

—————————————————————————————————————————

Install the add-on: https://workspace.google.com/marketplace/app/gpt_for_sheets_and_docs/677318054654
Website: https://gptforwork.com/

This add-on is completely free to use. You only need to pay OpenAI’s API cost.