<div class="statcounter"><a title="Web Analytics" href="https://statcounter.com/" target="_blank"><img class="statcounter" src="https://c.statcounter.com/12795394/0/d64e9537/1/" alt="Web Analytics" referrerPolicy="no-referrer-when-downgrade">

AI Quick Tips 320: Have you tried the Gemini function in Sheets?

A graphic title card on a dark blue background. On the left is an orange robot head with a speech bubble containing the text 'AI'. To the right is a light blue circle containing the words 'Quick Tips'.

Well, it might be called the =AI function. It’s not clear.

Either way, you can use Gemini at the cell level within a spreadsheet with the =AI function. Just go to the cell where you want to start and type “=AI”

 

You’ll get back instructions on how to structure your function, examples of how you could use it, etc.

A screenshot of a Google Sheets cell with an active formula window for a new "=AI(" function. The help dialogue explains the syntax as "AI(prompt, [range])" and provides examples of using it to write personalized thank-you emails based on data in specific cells. An "About" section notes that the feature uses Gemini to summarize, categorize, or generate text tailored to spreadsheet data, and explicitly labels the feature as "experimental".

 

It looks like Google’s answer to Microsoft’s =Copilot function.

 

I haven’t really found a reason to use this over the normal Gemini within Sheets. It might just be a preference thing. Either way, you’ll have to specify the cell or range that you want to use and write out instructions for what to do.

 

This could also just be phase 1 of this feature. By the time you read this, they might have changed it drastically or gotten rid of it. Hopefully not though, people seem to like it.

 

 

 
NotebookLM Weekend Masterclass - Cohort 2 no Dates

Use NotebookLM Like You Meant To

Clear steps, real use cases, and zero fluff—just workflows that hold up after the weekend. 

Comments

Related posts