Google Sheets Introduces AI-Powered =AI() Formula for Enhanced Productivity

Google has unveiled a groundbreaking feature in Google Sheets: the =AI() formula, powered by its Gemini AI model. This addition allows users

Apr 16, 2025 - 09:05

Google Sheets Introduces AI-Powered =AI() Formula for Enhanced Productivity

Google has unveiled a groundbreaking feature in Google Sheets: the =AI() formula, powered by its Gemini AI model. This addition allows users to input natural language prompts directly into spreadsheet cells, enabling tasks such as data analysis, text summarisation, sentiment evaluation, and categorisation without the need for complex formulas or external tools.

Transforming Spreadsheets with AI

The =AI() function simplifies various tasks:

Categorisation: Automatically classify data entries. For instance:
=AI("Is this a basketball or baseball team?", A2)
Sentiment Analysis: Determine the tone of textual data. Example:
=AI("Classify this sentence as positive or negative.", A2)
Summarisation: Condense lengthy texts into concise summaries. For example:
=AI("Summarise this information in one short sentence.", A2)

These capabilities are particularly beneficial for professionals handling large datasets, such as customer feedback or support tickets, facilitating quicker insights and decision-making.

Accessing the AI Features

To utilise the =AI() formula:

Ensure Gemini is enabled in your Google Sheets via Workspace Labs or a Google One AI Premium subscription.
Open a spreadsheet and click on the "Ask Gemini" icon located at the top right.
Input your prompt directly or use the =AI("your prompt", A2) format within a cell.

This integration eliminates the need for manual formula creation, streamlining workflows and enhancing productivity.

Broader AI Enhancements in Google Workspace

The introduction of the =AI() formula is part of Google's broader initiative to embed AI across its Workspace suite. Other notable features include:

Help Me Analyse: An upcoming tool in Google Sheets designed to assist users in interpreting data trends and generating visualisations.
Audio Overviews in Docs: Transform written documents into audio summaries, allowing users to consume content audibly.
Workspace Flows: Automate multi-step processes across Workspace apps using AI-driven workflows.

These enhancements aim to make AI an integral part of daily tasks, reducing manual efforts and fostering efficiency.

Implications for Users

The integration of AI directly into Google Sheets signifies a shift towards more intuitive and accessible data management tools. By allowing users to interact with spreadsheets using natural language, Google is lowering the barrier to advanced data analysis, making it more approachable for individuals without technical expertise.

As AI continues to evolve, features like the =AI() formula are set to redefine how professionals interact with data, emphasising ease of use and real-time insights.