ASK
Ask anything or provide subject to get information from Artificial Intelligence.
It can be used to get some facts, generate creative texts, or get professional-level advice from AI.  This powerful function covers most cases, from email writing to solving logical problems.
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", 0.6})

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";"context","Answer in form: City, Main Airport 3 letter code"})

Output Example: Warszawa, WAW
Arguments List
=ASK_X(question, [optional_parameters])
=ASK_Y(question, [optional_parameters])
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", "Capital of " & B2, A2, A1:A4, or A2:B4
Optional Parameters 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"; "context","Remember this info: " & A1; "act_like","Artist from the 18th century"}
output_language
Set output language for the function result; 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
Adjust the deviation from deterministic answers from 0 (default, high-confidence) to 1 (greater diversity). 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 AI in providing more context-specific or specialized answers.
For example: "UX Designer", "Nutriologist", or "Chess piece"
context
Provide additional information or instructions to get a better answer.
For example: "Use metric system", "From the business perspective", or "Remember this: " & B2
model
Model affects quality, speed, and tokens count of tokens to use. We choose the optimal model ("best") by default, and here it's gpt-3.5-turbo. Information about models.
Selected Options: "best", "gpt-4, "gpt-3.5-turbo", "davinci", "text-curie-001", "text-babbage-001", or "text-ada-001"
max_tokens
Limit the number of tokens that can be used for one function run. By default, it's limited only by the model.
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
cache
When TRUE, save the result for 6 hours and show the same result for the same arguments and parameters. When FALSE, make a new request to API in each function run; results can differ. TRUE by default.
For Example: TRUE or FALSE
Websheet AI is designed to empower you in crafting the perfect website effortlessly. Discover the myriad of options and bring your vision to life.