Function AI.ASK

The AI.ASK function lets you use AI directly in your spreadsheet. Simply type a question or prompt, and AI.ASK will provide a helpful response. Use it to write text, summarize, analyze data, and more—like having a smart helper in Excel!

Examples

Generating a Marketing Tagline:

=AI.ASK("Write a catchy marketing tagline for a new electric bike.")

This prompt asks AI to create an engaging marketing tagline for an electric bike.

Summarizing a Report:

=AI.ASK("Summarize this sales report for the last quarter", A1:P100)

This uses AI to summarize the key points from a sales report in A1:P100 cell range.

Creating a Product Description:

=AI.ASK("Write a detailed product description based on provided list of features for a digital camera.", A1:A10)

This function uses AI to generate a compelling product description based on a list of feature.

Providing Data Insights:

=AI.ASK("What insights can be drawn from the following data set:", A1:P100)

This prompt asks AI to provide key insights from the given data set in A1:P100 cell range.

Syntax

AI.ASK(prompt, [value], [temperature], [maxTokens], [model])

Argument name	Description
prompt	The prompt to submit.
value OPTIONAL	The value to be added to the end of the prompt.
temperature OPTIONAL	Controls the creativity of the response, with 0 being the most predictable and 2 being the most random. The default value is 0.
maxTokens OPTIONAL	The maximum number of tokens that can be generated in the chat completion.
model OPTIONAL	ID of the model to use. See the supported models page for details.