How to Use AI Function in Google Sheets

Google's AI relation brings Gemini-powered connection models close into your spreadsheet cells without immoderate add-ons. With it, you tin make caller text, summarize blocks of data, categorize entries, oregon adjacent conjecture sentiments—all by typing a elemental formula.

The AI() Function Syntax

The AI relation has 2 arguments:

=AI(prompt, [reference_cell_or_range])

Where

• prompt (required): A substance drawstring successful quotes that tells the AI what you want. For example, you tin benignant a elemental punctual similar "Summarize this reappraisal successful 1 sentence" oregon thing other you need.
• reference_cell_or_range (optional): This specifies the compartment (or scope of cells) that contains the information you privation the AI to enactment on.

If you permission retired the reference, the AI volition lone usage the punctual for context, which tin inactive output amazingly utile results portion ignoring each compartment contents. In addition, the relation returns plain text, truthful you tin concatenation it with different formulas (e.g., wrapper it successful LEFT() to drawback conscionable the archetypal fewer words).

How to Use the AI() Function

Open oregon make a Google Sheet, and marque definite you're utilizing an relationship that has entree to Gemini for Workspace. Click into the compartment wherever you privation to usage the AI function. Then, benignant =AI() and commencement typing your prompt. You tin usage earthy language, truthful don't interest excessively overmuch astir syntax. Specify your information scope oregon notation the applicable cells. The AI volition usage this information to make insights.

When you deed Enter, sheets amusement a "Generate and insert" button. Click it, and your AI-crafted effect volition driblet into the compartment attributed to you successful mentation history.

You tin besides resistance the capable grip to use the AI relation crossed aggregate rows oregon columns, allowing batch processing of data. Plus, you tin reappraisal the output, and if you privation a caller take, deed Refresh and insert—it'll rerun the punctual and make a caller answer.

Examples of the AI() Function

You tin usage the AI relation to execute 3 main tasks: generating substance based connected your data, summarizing your sheet, and automatically sorting oregon classifying entries. You tin besides execute elemental calculations connected rows and columns, specified arsenic adding and subtracting, but precocious calculations are not supported.

Not lone that, but you tin adjacent construe the contents of a compartment to find sentiment oregon different feelings, specified arsenic identifying the code of feedback reviews. For example, accidental you person a database afloat of earthy lawsuit feedback from your online store oregon surveys, and you request to find which comments are positive, negative, oregon neutral without speechmaking the afloat feedback to prevention time. You tin participate this elemental punctual with the AI function:

=AI("Is this lawsuit feedback positive, negative, oregon neutral?", A2)

You instantly get a Positive, Negative, oregon Neutral verdict, allowing you to benignant your expanse and respond faster to captious voices. To use this to each the feedback below, simply resistance the capable grip down and property the Generate and insert button.

Another task you tin execute is categorizing your information based connected your instructions by referring to different cells. For example, accidental file C lists miscellaneous disbursal descriptions—airfare, luncheon meetings, bundle subscriptions—and you privation them neatly bucketed into Travel, Office, oregon Other for your concern team. Simply use:

=AI("Classify this disbursal arsenic Travel, Office, oregon Other", D3)

The AI volition effort to tag oregon categorize each entry, but it whitethorn occasionally miss some. However, you tin regenerate the output oregon set the punctual to amended accuracy if needed. Since this relation is inactive experimental, occasional errors are expected—vague prompts and inconsistent information tin confuse the model.

As with immoderate connection model, mistakes specified arsenic misunderstandings, misinterpretations, oregon nonsensical outputs tin occur. Always reappraisal the results carefully, particularly for captious tasks, and verify the output alternatively than relying connected it blindly.

Beyond these tasks, you tin besides make summaries of text, make slogans from text, and execute elemental calculations similar basal summation betwixt cells.

=AI("Add the numbers successful these cells", A1:A5)

Things This Function Can't Do

There are galore things this relation can't do. For example, its scope is constricted to your punctual and referenced data. It doesn't scan your full expanse oregon propulsion successful outer information connected its own. Additionally, it cannot link to the unrecorded net to fetch real-time banal prices, cheque the weather, oregon scrape information from websites.

When you make an analysis, it becomes a static snapshot. If the underlying information changes, you indispensable re-ask the AI to update the result. You tin besides not physique charts, graphs, oregon tables.

The AI relation successful Google Sheets besides has short-term and semipermanent procreation limits; if the semipermanent bounds is reached, procreation pauses for 24 hours. It tin make outputs for up to 200 selected cells astatine a time, allowing further cells to beryllium processed erstwhile the archetypal procreation completes.

AI-Powered Google Workspace

Google's AI relation is portion of a broader inaugural to integrate AI crossed its Workspace tools. Upcoming features similar Help Me Analyze successful Sheets, Audio Overviews successful Docs, and Workspace Flows purpose to simplify information interpretation, contented consumption, and workflow automation. These enhancements are designed to streamline regular tasks, trim manual effort, and boost productivity.

By enabling earthy connection enactment successful Google Sheets, AI is making information investigation much intuitive and accessible—even for non-technical users. As these tools evolve, they are acceptable to alteration however professionals enactment with data, emphasizing ease, speed, and actionable insights.

My advice: If this relation is disposable successful your Google Sheets, springiness it a try! Start with a elemental task and spot however good it helps you automate your workflow.