AI Function
AI Function
To generate columns of data, enter a specific prompt to describe your desired action and add an optional range: =AI(”prompt”, [optional range]).
Details
Generate, categorize, and summarize text at scale using the =AI() or =Gemini() functions.
  • Generate Text: Create content tailored to your data, such as slogans, emails, or keyword lists.
    Example: =AI('Generate slogan for event in 10 words or less', A2)
  • Summarize Information: Extract key takeaways or main themes from cells and ranges.
    Example: =AI('List in bullet points the main themes of the book summary.', D2)
  • Categorize Data: Automatically group information and detect patterns, including sentiment analysis.
    Example: =AI('Categorize the customer inquiry as a compliment, exchange request, or return request.', C2)

Other experiences

  • Gemini Paste
    Organize pasted data with a single click. Gemini automatically transforms non-tabular content—like unstructured text or JSON—into neat spreadsheet tables, saving you manual formatting time. Learn More
    Google Sheets
  • Sheets Gemini Agent
    Gemini in Google Sheets is a collaborative agent that uses natural language to execute multi-step workflows, including building new dashboards from scratch or comprehensively editing existing data by synthesizing your Workspace information. Learn More
    Google Sheets
  • Gemini Fill
    Save time by letting Gemini populate your spreadsheet. Use the new promptless drag-and-drop functionality to magically complete columns, or use the one-click prompt entry to fill cells or write a custom prompt to fit your specific needs. Learn More
    Google Sheets