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])
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"}
Sidebar Options
Because of Google Sheets constraints, these options are not usable within Smart Formulas, yet they're accessible when calling a Smart Function from the Websheet AI sidebar.