Google Sheets AI (What Can You Do with Google Sheets Gemini) 2025

Have you ever wished you could create powerful spreadsheets in seconds without having to muck around with complicated formulas, tables, and graphs?

Well, now you can! Say hello to Gemini AI, Google’s impressive AI (artificial intelligence) tool that's shaking up how we work online.

Gemini AI can be integrated with all your favorite collaboration and productivity Google Apps.

And by using Gemini in Google Sheets, specifically, you’ll completely transform how you create, manage, and interpret data.

Thanks to the ‘Ask Gemini’ function in Google Sheets, you can type specific prompts that instantly:

Generate tables and formulas.

Create insights and analysis of spreadsheet data.

Build charts and graphs.

Create images.

Perform Google Sheets actions.

Summarize Google Drive and Gmail files.

Basically, by leveraging the power of Google Sheets and Gemini AI, you no longer have to waste hours wrestling with formulas or table formatting!

From tracking inventory and managing task lists to building CRMs, project timelines, staff timesheets, and beyond, Gemini AI can seriously help you build anything effortlessly.

Let’s take a closer look at everything you can do with Gemini AI in Google Sheets.

Check out this step-by-step video guide on how you can create anything with Google Sheets and Gemini AI.

Want to build a professional table with specific columns and rows, but simply don’t have the time? Or maybe you want to write a formula to calculate a value and don’t know how?

Well, Gemini AI can help you do both in a matter of seconds!

To create a table and formulas in Google Sheets using Gemini AI:

Open a new Google Sheets spreadsheet.

At the very top right of the sheet, select ‘Ask Gemini’ (star icon next to your Google Workspace profile photo).

In the right-hand side panel, select ‘Create a Table’ and type in the rest of the prompt to describe the kind of table you want to create.

Select Enter.

Click ‘Insert’ to add the generated table into your spreadsheet.

Gemini AI will then analyze the spreadsheet and provide formula suggestions that you can also add to your spreadsheet by clicking 'Insert'.

Alternatively, you can add AI-generated formulas into your spreadsheet by following these steps:

Click on any cell within your spreadsheet.

Type ‘=’, then ‘Generate formula with Gemini’ to bring up the right-hand sidebar.

Type a prompt explaining what kind of formula you want to create.

If you’re looking to better understand your data, Gemini AI can help take the guesswork out for you by building clear, compelling visual charts and graphs.

To generate charts and graphs using Gemini AI:

Open an existing Google Sheets spreadsheet.

Click ‘Ask Gemini’ in the top right corner of the spreadsheet.

Create your own prompt within the right-hand sidebar. For example, ‘Make a line chart’, or ‘Build a chart with date on the x-axis and total on the y-axis’.

Select Enter.

Once generated, you can then easily send these AI-powered charts and graphs to others.

Once you’ve created your spreadsheet table, you can leverage Gemini to answer questions about information within your sheet.

Basically, Gemini AI can analyze and deeply understand your data.

It can identify hidden trends, highlight patterns, and flag outliers that you may have missed, helping you make smarter decisions more quickly.

To use Gemini AI for spreadsheet data analysis and insights:

• Open an existing data spreadsheet in Google Sheets.
• At the top right corner, select ‘Ask Gemini’.
• Within the side panel, type your own prompt, for example, ‘Identify trends in this table’, or ‘What analysis can you help me perform with this sheet?’
• Click Enter.

Additionally, Gemini AI can simply summarize your spreadsheet data. To activate this function:

• Open an existing Google Sheets spreadsheet.
• Click ‘Ask Gemini’.
• Gemini AI will then automatically provide you with a short summary of your spreadsheet data in the right-hand sidebar.
• To show the entire summary of the content, select ‘View more’.

If you’re looking to jazz up your data, the good news is that Gemini AI can easily create and enter AI-generated images into your spreadsheet! To do this:

Open up your existing (or new) Google Sheets spreadsheet.

Select ‘Ask Gemini’ at the top right.

Within the right-hand sidebar, type in a prompt describing the image you want to create, for example, ‘Create an image of a business woman looking stressed’.

From the various images created, click the one you like to enlarge it.

Click ‘Insert’.

And if you’re not satisfied with the generated images, don’t worry! Simply click 'Generate more' to create additional images.

With Gemini AI, you can easily summarize your files from Google Drive or emails within Gmail inside Google Sheets!

Basically, Gemini AI can easily reference files from your Google Drive or emails you’ve sent from Gmail to generate responses in Google Sheets.

This feature can help you quickly extract key points and deadlines, or transform messy files and email threads into structured summaries.

To summarize your Google Drive files and Gmail emails with Google Sheets AI:

• Open a new Google Sheets spreadsheet.
• At the top right corner, select ‘Ask Gemini’.
• In the right-hand sidebar, type in a prompt and use the ‘@’ function to reference a particular Drive file. For example, ‘What are the main points of @ (then choose the correct file from the search list).
• Alternatively, simply add the Google Drive file name into the prompt if you can’t find it from the drop-down list.
• Gemini AI will then summarize the file within the right-hand sidebar for you.
• Click ‘Insert’ to add the summarized text to your spreadsheet.

Additionally, you can follow the same steps above to summarize your Gmail emails using Google Sheets AI, simply changing the prompt to reference Gmail emails.

For example, your prompt could be ‘Please catch me up on the latest weekly review emails within Gmail’. 

Gemini AI can also assist with spreadsheet tasks (actions) like sorting and filtering data, creating pivot tables and dropdowns, and applying conditional formatting.

To perform actions in Google Sheets with Gemini AI:

Open an existing Google Sheets spreadsheet.

Click ‘Ask Gemini’ in the top right-hand corner.

In the right-hand sidebar, type a prompt that describes the action you want Gemini AI to perform.

You can ask Gemini AI to:

Apply conditional formatting based on specific rules, like highlighting values below a certain number or identifying duplicates.

Create new dropdown lists in selected ranges or convert existing data into dropdown options.

Generate a pivot table to summarize your data, either in a new sheet or a defined range.

Apply filters to the table to narrow down visible data.

Sort the data in your spreadsheet according to your preferred criteria.

Once you’re happy with your prompt, Gemini will generate an ‘Action preview card’.

Click ‘Apply’ on the Action preview card to insert the proposed action into your spreadsheet.

Did you know Gemini AI is now included in all Google Workspace Business paid plans? 

That’s right, you can unlock the full power of Google’s dynamic AI assistant (and other impressive AI tools such as NotebookLM Plus) in the ‘Business Standard’ plan.

This plan costs just $14 per user per month.

Additionally, Gemini AI offers a 14-day trial period, allowing you to experience its features before committing.

So, if you’re ready to transform your Google Sheets spreadsheets in the blink of an eye, get started with Gemini AI now!