Icon of Ask AI Function: White question mark inside blue speech bubble

ASK

Ask anything or provide a subject to receive information from ChatGPT directly in your spreadsheet

It can be used to obtain facts, generate creative texts, or receive advice from AI. Utilizing the GPT-4 and the fast gpt-3.5-turbo models by OpenAI enables users to receive the same quality of answers as ChatGPT directly in spreadsheets. Combining OpenAI models with Google Sheets can accommodate a wide range of needs, from writing emails to creating ALT texts for images.

Examples
=ASK_X("What is the capital of France?")

Output: Paris
=ASK_X(A1:B4)

Output Example:
Answer for A1, Answer for B1
Answer for A2, Answer for B2
=ASK_X("What are the key principles of a balanced diet?", {"act_like", "Nutritionist"; "temperature", IFS($C$6="Very Creative",0.8,$C$6="Medium",0.5,$C$6="Very Rational",0)})

Output Example: A well-rounded diet incorporates diverse foods from various categories, such as fruits, veggies, whole grains, lean proteins, and good fats. It's crucial to ingest these foodstuffs in appropriate quantities, ensuring you obtain vital nutrients, manage your weight, and stave off health issues.

=ASK_X("What is the capital of " & B2, {"output_language","Polish";"extra_instructions","Answer in form: City, Main Airport 3 letter code"})

Output Example: Warszawa, WAW
Arguments List
=ASK_X(question, [options])
=ASK_Y(question, [options])
question
Request to OpenAI can be a question or subject. It can be a list or table of questions; in this case, you will get answers for each question.
For example: "Capital of France", A2, A1:A4, A2:B4 or "Capital of " & B2
Options List
Particular object at the end of a formula which contains optional parameters values in the form {"parameter_name",value; "next_parameter_name",value}
For Example: {"output_language","French"; "extra_instructions","Remember this info: " & A1; "act_like","Artist from the 18th century"}
with_kb
When activated, it allows ChatGPT to access and utilize the spreadsheet's Knowledge Base, thereby enriching responses with spreadsheet data and insights that have been pre-configured. This improves the ability to produce answers that are more context-aware and informative. It is recommended to deactivate this feature when the desired outcome depends on general knowledge and the Knowledge Base's information is not sufficient to formulate an answer.
Options: FALSE or TRUE
with_kb2
When activated, Smart Function uses Knowledge Base sources for the answer, but in a later stage, which is beneficial in combination with extra_instructions and activated with_thinking.
Options: FALSE or TRUE
with_web
When activated, it enables the function to fetch data from the internet, adding a layer of real-time information from a Google search. While this feature can provide valuable insights, be aware that it may increase both the cost and the time required for execution, and the quality of results may vary based on the search.
Options: FALSE or TRUE
with_thinking
When activated, it adds an extra thinking step to improve the answer. This makes the execution longer and more expensive.
Options: FALSE or TRUE
with_vision
When activated, ChatGPT can see and analyze images on the publicly available links utilizing GPT-4 Vision by OpenAI.
To ensure that the link is available for Vision, upload the file using the File button on the sidebar.
Options: FALSE or TRUE
output_language
Set output language for ChatGPT; it can differ from argument language. If not set, answer language can vary depending on options and parameter values.
For Example: "EN", "French", or  "Most popular Language in the US"
temperature
Adjusts the scale from deterministic answers (0) to creative and diverse (1). In other words, it's the AI's creativity for the answer.
For Example: 0, 0.4, or 1
act_like
Specify a role, profession, or perspective for the AI to adopt when generating a response; this parameter guides the ChatGPT in providing more context-specific or specialized answers.
For example: "UX Designer", "Nutriologist", or "Chess piece"
extra_instructions
Provide additional information or instructions to get a better answer from ChatGPT.
For example: "Use metric system", "From the business perspective", or "Remember this: " & B2
tags
Tags filter Knowledge Base sources for more specified answers, leading to better outcomes. Start by adding tags to the Knowledge Base sheet. Next, turn on with_kb or with_kb2 to make these tags work.
For example: "employees", "team-wiki", or G2
model
Model affects quality, speed, and tokens count of tokens to use. We choose the optimal model ("default") by default, and here it's gpt-4. Information about models.
Options: "default", "gpt-4, "gpt-3.5-turbo", or "gpt-3.5-turbo-16k"
in_parallel
For each cell: Smart Function makes a separate ChatGPT request for each cell in the range for the question parameter, which maximizes efficiency, answer quality, and execution speed.
None: Aggregates all cells in the spreadsheet range into one request, possibly leading to larger requests but ensuring context consistency for more coherent translations.
Options: "default", "max", or "none"
max_tokens
Limit the number of tokens that can be used for one function run. By default, it's already limited to reasonable value to protect user's balance.
1 token ≈ 4 chars in English
1 token ≈ 3/4 words
100 tokens ≈ 75 words
1-2 sentences ≈ 30 tokens
1 paragraph ≈ 100 tokens
1,500 words ≈ 2048 tokens
For Example: 100, 350, or 2048
generate
When set to TRUE, the formula performs the calculation. If set to FALSE, a warning message will be displayed in place of the answer. To avoid accidental costs, connect this parameter to a Google Sheets cell with a checkbox or a formula that checks the input.
For Example: TRUE, FALSE, or $H$1
generate_warning
This message displays when 'generate' is FALSE. It's recommended to provide guidance on the steps needed to initiate translation.
Adding the codeword [STOP] stops the processing of associated formulas, remaining hidden from the user. Typing "default" triggers a standard warning message.
For Example: "default", "Fill out all inputs", or $A1