How to use ChatGPT in Sheets

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:

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

Google Documentカテゴリの最新記事