AI function
AI function
The AI function in Google Sheets helps you generate, summarize, and categorize text or access real-time information on the web.
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

  • Convert to table
    Transform unorganized text into clean structured tables with a single click using Gemini in Google Sheets, saving you manual formatting time. Learn More
    Google Sheets
  • Build and edit spreadsheets
    Describe what you need in natural language, and Gemini in Google Sheets orchestrates the complex, multi-step construction of a spreadsheet from start to finish, synthesizing data across your files, emails, and chat, and the web. Learn More
    Google Sheets
  • Fill with Gemini
    Use Fill with Gemini to auto-populate your tables with summarized, categorized, or brand-new data from your existing sheet or the web. Learn More
    Google Sheets