Google has introduced a powerful new feature in Google Sheets: the =AI() formula, powered by its Gemini AI model. This tool allows users to input natural language prompts directly into spreadsheet cells, enabling advanced functions such as data analysis, sentiment evaluation, text summarization, and categorization—without needing complex formulas or additional software. With this formula, users can perform tasks like categorizing data (e.g., “Is this a basketball or baseball team?”), analyzing sentiment (“Classify this sentence as positive or negative”), or summarizing long text into concise points.

Gemini-Powered =AI() Formula Brings Natural Language to Google Sheets

These AI-driven capabilities are especially useful for professionals dealing with large datasetssuch as customer reviews or support queries, offering faster insights and improved decision-making. The =AI() function simplifies the process by allowing users to write prompts in plain language, thus lowering the technical barrier and enhancing productivity.

To access this feature, users must enable Gemini through Workspace Labs or a Google One AI Premium subscription. Once activated, users can either click the “Ask Gemini” icon in the top right of their sheet or use the =AI("your prompt", A2) format within a cell to generate results instantly.

Google Expands AI in Workspace for Smarter, User-Friendly Productivity

This innovation is part of Google’s broader strategy to embed AI across its Workspace suite. Other upcoming features include “Help Me Analyse” in Sheets, which assists with data trends and visualizations; “Audio Overviews” in Docs, turning written content into audio summaries; and “Workspace Flows,” which automate multi-step processes across apps using AI.

Overall, Google’s AI integration marks a shift toward more accessible and intelligent productivity tools. By enabling users to interact with data through natural language, Google is democratizing data analysis, making it easier for non-technical users to extract meaningful insights. The =AI() formula represents a step forward in real-time, AI-powered work environments where simplicity and efficiency go hand in hand.

Summary: Google’s new =AI() formula in Sheets, powered by Gemini, lets users perform tasks like data analysis, sentiment checks, and summarization using plain language. It simplifies workflows and boosts productivity. Part of a broader AI push across Workspace, it brings powerful, user-friendly tools to non-technical users for smarter data handling.