Opening Gemini in Sheets and asking useful questions
Find the Gemini button, insert a table or apply edits, and try these ready-to-copy prompts. Includes checks for a missing button.
Open it for the first time
These steps follow Google’s official help.
- Open a Google Sheets file. Create or open a spreadsheet at sheets.google.com. For an Excel (.xlsx) file, choose
File → Save as Google Sheets, then work in that copy. Some features do not work fully in Excel files. - Click Ask Gemini (✦) at the top right. The side panel opens.
- Type your request in the box at the bottom and send it. You can copy a prompt from below.
- Put the result into the sheet.
- For a generated table: click
Insertbeneath the response. - For edits such as formatting or organizing: review the action preview card, then click
Apply. The Undo button for a Gemini action is available until you apply further changes, so check the result immediately.
- For a generated table: click
If the button is missing
| What to check | What to do |
|---|---|
| Are you using a free Gmail account? | You need an eligible Google Workspace plan, such as Business Standard or higher, or Google AI Pro or Ultra. Check the exact list in Google’s guidance. |
| Is this a work account? | Your administrator may have disabled Gemini. Ask them to check. |
| Are you still in an Excel file? | Choose File → Save as Google Sheets and open the resulting file. |
| Are Workspace smart features off? | In Gmail, go to Settings → See all settings → General → Google Workspace smart features → Manage Workspace smart feature settings. See Google’s guidance. |
Based on Google’s help as of October 4, 2026. The interface may differ slightly by account and update.
Prompts to copy
Create a table
Create a weekly sales table with sale date, weekday, in-store card sales excluding delivery apps, in-store cash sales excluding delivery apps, delivery-app orders, other sales excluding the preceding categories, and total. Use formulas for totals.Create an inventory table with item, current quantity, minimum quantity and reorder status. Show "Order" when stock is below the minimum.
Clean up
Standardize the product codes in column B to uppercase letters, a hyphen and three digits, like BR-001.The dates in column A use different formats. Change them all to YYYY-MM-DD, like 2026-10-04.Find and highlight duplicate rows. Do not delete them.
Summarize
Summarize average sales by weekday from this table.Create a small table beside the data comparing last month's total with this month's.
Formulas
Explain the formula in cell F2 in plain English.Create conditional formatting to highlight days when card sales fell more than 20% from the previous week.
Check the work
- Independently calculate every total you will use for a decision.
- Ask to highlight data before asking to delete it. Recovering deleted data can take extra work.
Need something like this?
If you have similar repetitive work, I can build it for you. Start by telling me which files you use and how you work today.