# Create tables & formulas with Gemini in Google Sheets

> Ask Gemini in Google Sheets to build a table, write or fix a formula, analyse data or fill a column with the AI function. Business Standard and up.
>
> Source: https://docs.officeniaga.com/gemini-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](https://sheets.google.com) on your computer.
2. At the top right, click **Ask Gemini**.

   *(Screenshot: Ask Gemini button and the Gemini side panel with suggested prompts and the Ask Gemini box)*

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.

   *(Screenshot: Gemini's suggested plan for a customer order tracker, with the Approve button)*

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

   *(Screenshot: Sample customer order tracker built by Gemini in a new Customer Orders 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**.

   *(Screenshot: Selected cell in a sample sales sheet and the SUMIF formula from Gemini with the Insert button)*

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**.

   *(Screenshot: AI function in the formula bar, sentiment results in the column and the Refresh and fill button)*

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](https://wa.me/60169163324).

## 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.