SheetAI reference
This is a reference of all available functions in SheetAI App. If you are looking for usage examples, click here.
SHEETAI function
The simplest function to start using SheetAI App. Outputs the result in a single cell.
How to use
syntax | =SHEETAI(prompt, maxTokens, temperature, model, cache) |
copy/paste example | =SHEETAI("write a tagline for salon") |
⚠️ localization | in some locales, you might need to use ";" to separate parameters instead of "," |
Parameters
Parameter | Definition |
prompt (cannot be empty) | Text, cell or range containing the prompt. Examples:
• "Write a tagline for an ice cream shop."
• A1 |
(optional) maxTokens | Maximum number of token for response. Defaults to 200 |
(optional) temperature, modal, cache |
SHEETAI_LIST function
Like GPT, but outputs the results in a column. Very practical when the output is a list.
How to use
syntax | =SHEETAI_LIST(prompt, value, temperature, maxTokens, model, cache) |
copy/paste example | =SHEETAI_LIST("Give me 5 good short ads about spreadsheets.") |
⚠️ localization | in some locales, you might need to use ";" to separate parameters instead of "," |
Parameters
Parameter | Definition |
prompt
(cannot be empty) | Text, cell or range containing the prompt. Examples:
• "Write a tagline for an ice cream shop."
• A1
• A1:C3 |
(optional) value | Text, cell or range you want your prompt to apply to |
(optional) temperature, maxTokens, model, cache |
SHEETAI_FILL function
Magically fill or clean a range from a few examples.
How to use
syntax | =SHEETAI_FILL(examples, partial, temperature, maxTokens, model, cache) |
⚠️ localization | in some locales, you might need to use ";" to separate parameters instead of "," |
Parameters
Parameter | Definition |
examples | Range containing complete examples that GPT should learn from |
(optional) partial | Range containing incomplete data that GPT should complete from the examples |
(optional) temperature, maxTokens, model, cache |
SHEETAI_TABLE function
Like GPT, but outputs the results in a table. Very practical when the output is a table.
How to use
syntax | =SHEETAI_TABLE(prompt, temperature, maxTokens, model, cache) |
copy/paste example | =SHEETAI_TABLE("top 10 most eaten fruits and their nutrition data") |
⚠️ localization | in some locales, you might need to use ";" to separate parameters instead of "," |
Parameters
Parameter | Definition |
prompt
(cannot be empty) | Text, cell or range containing the prompt. Examples:
• "top 10 most eaten fruits and their nutrition data"
• A1 |
(optional) headers | Comma-separated column headers to use, or range containing such headers.
If left empty, headers will be generated automatically. |
(optional) temperature, maxTokens, model, cache |
SHEETAI_EDIT function
Applies the given task to the given text. The default ask is to fix grammar and spelling.
How to use
syntax | =SHEETAI_EDIT(text, task, temperature, maxTokens, model) |
copy/paste example | =SHEETAI_EDIT("For sum reezon thoose nunsberz arnt addin up") |
⚠️ localization | in some locales, you might need to use ";" to separate parameters instead of "," |
Parameters
Parameter | Definition |
text
(cannot be empty) | Text, cell or range to be edited. Examples:
• "For sum reezon thoose nunsberz arnt addin up"
• A1 |
(optional)
task | Text, cell or range specifying how the text should be edited.
Defaults to fixing grammar and spelling. Other examples:
• “Make it funnier”
• “Make it shorter”
• “Make it sound formal”
• “Add an ending” |
(optional) temperature, maxTokens, model, cache |
SHEETAI_TAG function
Applies user-defined tags to a given text.
How to use
syntax | =SHEETAI_TAG(text, tags, temperature, maxTokens, model, cache) |
copy/paste example | =SHEETAI_TAG("I love chocolate", "food, positive, negative") |
⚠️ localization | in some locales, you might need to use ";" to separate parameters instead of "," |
Parameters
Parameter | Definition |
text (cannot be empty) | Text, cell or range. Examples:
• "I love chocolate"
• A1
• A1:C3 |
tags (cannot be empty) | Comma-separated tags or range of tags applicable to the text. |
(optional) temperature, maxTokens, model, cache |
SHEETAI_CLASSIFY function
Classifies a given text into a single category.
How to use
syntax | =SHEETAI_CLASSIFY(text, categories, temperature, maxTokens, model, cache) |
copy/paste example | =SHEETAI_CLASSIFY("banana", "fruit, vegetable") |
⚠️ localization | in some locales, you might need to use ";" to separate parameters instead of "," |
Parameters
Parameter | Definition |
text
(cannot be empty) | Text, cell or range. Examples:
• "banana"
• A1
• A1:C3 |
categories(cannot be empty) | Comma-separated categories or range of categories to choose from. Only the most relevant category will be returned. |
(optional) temperature, maxTokens, model |
SHEETAI_EXTRACT function
Extracts data (like email addresses or company names) from a text. Outputs as comma-separated values.
How to use
syntax | =SHEETAI_EXTRACT(text, to_extract, temperature, maxTokens, model, cache) |
copy/paste example | =SHEETAI_EXTRACT("I worked 12 years at Amazon.com at Apple", "companies") |
⚠️ localization | in some locales, you might need to use ";" to separate parameters instead of "," |
Parameters
Parameter | Definition |
text
(cannot be empty) | Text, cell or range to extract data from. Examples:
• "I worked 5 years at Amazon.com and then 3 years at Apple"
• A1
• A1:C3 |
to_extract(cannot be empty) | What you want to extract. Examples:
• "email addresses"
• "company names" |
(optional) temperature, maxTokens, model |
SHEETAI_TRANSLATE function
Translates text from one language into another. Works better if you specify the source language.
How to use
syntax | =SHEETAI_TRANSLATE(text, target_language, source_language, temperature, maxTokens, model, cache) |
copy/paste example | =SHEETAI_TRANSLATE("Cool off with our delicious treats!", "spanish") |
⚠️ localization | in some locales, you might need to use ";" to separate parameters instead of "," |
Parameters
Parameter | Definition |
text
(cannot be empty) | Text, cell or range to translate. Examples:
• "Cool off with our delicious treats!"
• A1 |
target_language(cannot be empty) | Language of the output. Examples: “spanish”, “chinese”, “french” |
(optional)source_language | Language of the input. Example: “english” |
(optional) temperature, maxTokens, model |
temperature, maxTokens and model
These parameters are the same for all GPT functions. They are always optional.
Temperature and maxTokens are useful to learn and know about.
Parameter | Definition |
(optional) temperature | Number between 0 and 1 that governs the creativity of GPT:
• 0 makes GPT strictly follow the prompt (default)
• 0.5 makes GPT slightly creative
• 1 makes GPT very creative
in some locales, you might need to use "0,5" instead of "0.5" |
(optional) maxTokens | The maximum number of tokens to generate in the completion.
Must be a round number greater than 0.
Defaults to 250.
It is advised to use values lower or equal to 500 in the GPT functions or you risk a timeout. If you want to generate long-form content, we advise to use our Google Docs integration.
Learn more tokens here |
(optional) model | • text-davinci-003: (default) Most capable GPT-3 model. Can do any task the other models can do, often with higher quality, longer output and better instruction-following. Also supports inserting completions within text.
• text-curie-001: Less capable, but faster and lower cost than Davinci.
• text-babbage-001: Less capable, but faster and lower cost than Curie.
• text-ada-001: Least capable, but fastest and lowest cost of all.
• text-davinci-edit-001: rewrite a text with a new style (beta)
you can also pass “d”,”c”,”b” and “a” for the respective models. |
(optional) cache | true/false by default true, helps save OpenAI Credits consumed for same prompt. To generate different response from the same prompt set it false check this video |
Â