GPT functions for Google Sheets
Links:
- Install the GPT for Sheets, Docs, Slides, Forms add-on
- Upgrade to Premium
- Optional -> RECOMMENDATION: The best way to ensure optimal performance with Google Add-Ons is by using the Google Chrome browser. This helps bypass any potential issues that may arise from compatibility with other browsers.
Example of use
-
Here you can find a Google Sheet Template with examples Google Sheet Template. The file is accessible in read-only mode. To make modifications, please create a copy using File > Make a copy, or you can simply copy functions/examples into your own sheet.
Important!
After getting a final result, please click on ‘Replace All GPTs’ or ‘Replace Selected’ button to replace the formula with the result. If to don’t do this - Google Sheets re-execution all formulas on refreshing page and every 1–2 minutes. (could affect your credits on Open AI or Internal credits, depends on plan)
GPT
The most straightforward function to initiate GPT in Google Sheets. Generates the outcome within a single cell.
| Function | =GPT(prompt, [value]) |
|---|---|
| Description | Tell the AI what to generate in one cell. |
| Localization | In some locales, use “;” to separate parameters instead of “,” |
| Example | =GPT("Write a tagline for a car") |
| Example 2 | =GPT(A1, "my site") |
| Example 3 | =GPT(A1, B1) |
| Output (one cell) | Unleash the power of motion |
Parameters
| Parameter | Definition |
|---|---|
prompt (required) |
Instruction given to the AI to generate a result. - It can be a string - a cell reference (e.g., B1), - range of cells (e.g., B1:E4). |
(optional) value |
Additional input or context to influence the output. It can be text, a cell, or a range. |
GPT_TRANSLATE
| Function | =GPT_TRANSLATE(text, target, [source]) |
|---|---|
| Description | Translates input text into another language using GPT. |
| Localization | In some locales, use “;” to separate parameters instead of “,” |
| Example | =GPT_TRANSLATE("I love ice cream", "spanish", "english") |
Parameters
| Parameter | Definition |
|---|---|
text (required) |
Instruction given to the AI to generate a result. - It can be a string - a cell reference (e.g., B1), - range of cells (e.g., B1:E4). |
target (required) |
Specify the desired language |
source (optional) |
Specify the source language |
GPT_FORMAT
| Function | =GPT_FORMAT(text, target_format) |
|---|---|
| Description | Converts between formats. |
| Localization | In some locales, use “;” to separate parameters instead of “,” |
| Example | =GPT_FORMAT("<ul><li><p>Name: Joe</p><p>Age: 27</p></li><li><p>Name: Jane</p><p>Age: 28</p></li></ul>", "json") |
Parameters
| Parameter | Definition |
|---|---|
prompt (required) |
Instruction given to the AI to generate a result. - It can be a string - a cell reference (e.g., B1), - range of cells (e.g., B1:E4). |
target_format (required) |
Specify the desired conversion format: JSON, HTML, YAML, Markdown, programming languages, etc. |
GPT_TAG
| Function | =GPT_TAG(text, [tags]) |
|---|---|
| Description | Applies user-defined tags to a given text |
| Localization | In some locales, use “;” to separate parameters instead of “,” |
| Example | =GPT_TAG("I love chocolate", "food, positive, negative") |
Parameters
| Parameter | Definition |
|---|---|
text (required) |
Instruction given to the AI to generate a result. - It can be a string - a cell reference (e.g., B1), - range of cells (e.g., B1:E4). |
tags (optional) |
Specify the desired tags |
GPT_CLASSIFY
| Function | =GPT_CLASSIFY(text, categories) |
|---|---|
| Description | Classifies the input into one of the given categories. Make sentiment analysis for comments, feedbacks, text |
| Localization | In some locales, use “;” to separate parameters instead of “,” |
| Example | =GPT_CLASSIFY("banana", "fruit, vegetable") |
Parameters
| Parameter | Definition |
|---|---|
text (required) |
Instruction given to the AI to generate a result. - It can be a string - a cell reference (e.g., B1), - range of cells (e.g., B1:E4). |
categories (optional) |
Specify the desired categories |
GPT_EXTRACT
| Function | =GPT_EXTRACT(text, to_extract) |
|---|---|
| Description | Extracts data (like email addresses or company names) from a text. Outputs as comma-separated values. |
| Localization | In some locales, use “;” to separate parameters instead of “,” |
| Example | =GPT_EXTRACT("I worked 12 years at Amazon.com at Apple", "companies") |
Parameters
| Parameter | Definition |
|---|---|
text (required) |
Instruction given to the AI to generate a result. - It can be a string - a cell reference (e.g., B1), - range of cells (e.g., B1:E4). |
to_extract (optional) |
Specify the desired extraction: emails, first name, last name, countries… |
GPT_SUMMARIZE
| Function | =GPT_SUMMARIZE(text, [format]) |
|---|---|
| Description | Summarizes the input text using GPT and returns the summary. |
| Localization | In some locales, use “;” to separate parameters instead of “,” |
| Example | =GPT_SUMMARIZE("This is a long text. It contains a lot of information. We need to summarize it.") |
| Example 2 | =GPT_SUMMARIZE("This is a long text. It contains a lot of information. We need to summarize it.", "two sentences") |
Parameters
| Parameter | Definition |
|---|---|
text (required) |
Instruction given to the AI to generate a result. - It can be a string - a cell reference (e.g., B1), - range of cells (e.g., B1:E4). |
format (optional) |
Specify the summarization format like: two sentences, up to 100 words, etc |
GPT_TABLE
| Function | =GPT_TABLE(prompt, headers) |
|---|---|
| Description | Generates a table from a prompt. |
| Localization | In some locales, use “;” to separate parameters instead of “,” |
| Example | =GPT_TABLE("top 10 most eaten fruits and their nutrition data", "name, calories") |
Parameters
| Parameter | Definition |
|---|---|
prompt (required) |
Instruction given to the AI to generate a result. - It can be a string - a cell reference (e.g., B1), - range of cells (e.g., B1:E4). |
headers (required) |
Additional input or context to influence the output. It can be text, a cell, or a range. |