Create tables & formulas with Gemini in Google Sheets

Gemini in Google Sheets can build a table from a description, write and fix formulas, and explain your data. It is included with Business Standard, Business Plus and Enterprise plans, but not Business Starter.

Open Gemini in Sheets

All the tasks below start from the Gemini side panel.

1. Open a spreadsheet in Google Sheets on your computer.

2. At the top right, click Ask Gemini.

   

3. Pick a suggested prompt, or type your own at the bottom and press Enter.

If Gemini makes a change you do not want, click Undo.

Create a table

Describe the table and Gemini plans it, then builds it for you.

1. In the Gemini panel, type a prompt such as “Create a table to track customer orders with columns for date, customer, item, quantity, amount in RM and status.”

2. Press Enter. Gemini shows a suggested plan with the steps it will take.

   

3. Check the plan, then click Approve. Gemini builds the table straight away in a new tab.

   

4. To change it, add a follow-up prompt, for example “Add a column for payment due date”.

Write or fix a formula

Gemini can write a formula from plain words, or explain why one fails.

1. In the Gemini panel, describe the result you want, using your column names. For example: “Create a formula that adds up the amount column where status is Paid.”

2. Click the cell where the formula should go, then click Insert.

   

3. If a cell shows a formula error, hover over it and click Fix to let Gemini check it.

You can also type = in a cell and press Ctrl + Alt + G (Windows) or ⌘ + Ctrl + G (Mac) to open the formula prompt.

Analyse data & make charts

In the Gemini panel, ask a question about your data, such as “Which month had the highest sales?” or “Make a line chart of sales by month.” Click Insert to add a chart. It goes into a new tab with its own copy of the data, so it will not update if you change the original rows.

Fill a column with the AI function

The =AI() function writes text, summarises entries or sorts them into categories, straight into your cells.

1. In a cell, type a formula such as =AI("Classify this customer comment as positive, negative or neutral", B2).

2. Press Enter. The result fills in straight away. Copy the formula down the column for the other rows.

3. To get fresh results later, select the cells and click Refresh and fill.

   

Give it the cells it needs in the range; it cannot see anything else in the file. Only the first 350 selected cells are generated at a time.

Still stuck

WhatsApp our support team at +60 16-916 3324.

Common issues

Gemini does not work on my Excel file. Why?

Gemini works best with Google Sheets files. Open the Excel file, then choose File > Save as Google Sheets and use Gemini on the new copy.

I get "AI function not available". What does it mean?

Your plan may not include the AI function (it needs Business Standard or higher), your admin may have turned it off, or you have hit a usage limit. If it is a limit, wait 24 hours and try again.

Can Gemini see all my Drive files when I use =AI()?

No. The AI function only sees the cells you give it in the range. It cannot read the rest of your spreadsheet or your other files.

Related articles

• What Gemini in Google Workspace does & which plans have it
• Write & refine documents with Gemini in Google Docs
• How Gemini handles your company data
• Add licences, upgrade your plan or renew Google Workspace