How to use ChatGPT in G Sheets 101

How to use ChatGPT in G Sheets 101

Like ChatGPT? Use it in Google Sheets!
No need to mess with apps script. Just a free add-on.
You get one super simple function: =GPT() and many others

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

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

You also get:
– GPT_LIST to get one answer per cell
– GPT_FILL to fill holes in a range thanks to examples of what you want

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カテゴリの最新記事