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
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 |
|---|---|---|
| the prompt describing the data you want to generate. (ex: "write a tagline for a waterproof t-shirt brand") | "" |
| The cell you are referring to in your prompt (ex: A1) | null |
| Between 0 (not creative) and 2 (very creative) | 0 |
|
|
|
| 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 |
|---|---|---|
| The prompt describing the data you want to generate. (ex: "write a tagline for a waterproof t-shirt brand") required | "" |
| The cell you are referring to in your prompt (ex: A1) | null |
| Between 0 (not creative) and 2 (very creative) | 0 |
|
|
|
| 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 |
|---|---|---|
| the prompt describing the data you want to generate. (ex: "write a tagline for a waterproof t-shirt brand") required | "" |
| The cell you are referring to in your prompt (ex: A1) | null |
| Between 0 (not creative) and 2 (very creative) | 0 |
|
|
|
| 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 |
|---|---|---|
| the language you want to translate the text into (ex: "french") required | "" |
| The cell you are referring to in your prompt (ex: A1) | null |
| Between 0 (not creative) and 2 (very creative) | 0 |
|
|
|
| Bypass the cache and query openai again. The results will be differents than before. | false |
Last updated
