GPT Workspace
Search
K

GPT for Google Sheets

GPT for Sheets is an AI tool for Google Sheets. With this add-on, Google Sheets can take advantage of the power of OpenAI GPT-3.5 and GPT-4.

Get started

To start using GPT for Google Sheets directly in your spreadsheet, you will need to enable the GPT Function for each sheet
Enable GPT functions for your current sheet

Using the =GPT() Formula

With GPT for Sheets, you can effortlessly craft attention-grabbing ad copy, taglines, and subject lines that perfectly align with your brand, captivating and retaining your customers' interest.
To get started, select a cell and input then use the following formula
=GPT(prompt, value, temperature, model, cache)
Parameter
Description
Default
prompt
the prompt describing the data you want to generate. (ex: "write a tagline for a waterproof t-shirt brand")
""
value
The cell you are referring to in your prompt (ex: A1)
null
temperature
Between 0 (not creative) and 2 (very creative)
0
model
gpt-3.5 or gpt-4
gpt-3.5
cache
Bypass the cache and query openai again. The results will be differents than before.
false

=GPT_LIST

Transforming your data has never been easier with GPT for Sheets. Its user-friendly custom functions enable you to swiftly cleanse and standardize any list or array of data, saving you time and hassle.
=GPT_LIST(prompt, value, temperature, model, cache)
Parameter
Description
Default
prompt
The prompt describing the data you want to generate. (ex: "write a tagline for a waterproof t-shirt brand") required
""
value
The cell you are referring to in your prompt (ex: A1)
null
temperature
Between 0 (not creative) and 2 (very creative)
0
model
gpt-3.5 or gpt-4
gpt-3.5
cache
Bypass the cache and query openai again. The results will be differents than before.
false

Generate a full table of data with =GPT_TABLE

You can generate a full table of data with GPT for Sheets, you can specify the number of columns too!
To get started, select a cell and input then use the following formula
=GPT_TABLE(prompt, value, temperature, model, cache)
Parameter
Description
Default
prompt
the prompt describing the data you want to generate. (ex: "write a tagline for a waterproof t-shirt brand")
required
""
value
The cell you are referring to in your prompt (ex: A1)
null
temperature
Between 0 (not creative) and 2 (very creative)
0
model
gpt-3.5 or gpt-4
gpt-3.5
cache
Bypass the cache and query openai again. The results will be differents than before.
false

Translate cells with =GPT_TRANSLATE

You can translate your Google Sheets cells with GPT for Sheets
=GPT_TRANSLATE(language, value, temperature, model, cache)
Parameter
Description
Default
language
the language you want to translate the text into (ex: "french")
required
""
value
The cell you are referring to in your prompt (ex: A1)
null
temperature
Between 0 (not creative) and 2 (very creative)
0
model
gpt-3.5 or gpt-4
gpt-3.5
cache
Bypass the cache and query openai again. The results will be differents than before.
false