What should you check before starting?

Check the account and file you are using. Google requires an eligible Google Workspace or Google AI plan. Its guidance says to convert an Excel file through File → Save as Google Sheets to use Gemini features. Account and file requirements.

Google Workspace means the Google services package used for work. When reviewing a subscription, look specifically for access inside Sheets. If your company manages the account, ask its administrator to check your access before you purchase anything yourself.

Which plan names are relevant?

Google's May 2025 launch announcement listed Business Standard and Plus, and Enterprise Standard and Plus. Treat that as a dated launch list; the current help page uses the broader eligible-plan requirement. Confirm your own entitlement before buying. Original availability announcement.

If your team also wants help with email, use the separate Gemini in Gmail guide. For this exercise, keep your attention on one spreadsheet and one finished task.

How do you build a spreadsheet that people will actually use?

Describe the job and name the columns. A prompt is simply the instruction you give the assistant. In Sheets, submit that instruction through Ask Gemini, review the proposed table, and use Insert when it is ready. Follow-up instructions can refine it before insertion. Table creation steps.

Hypothetical example: a freelance studio

Create a project tracker for a small design studio. Include client code, project name, owner, deadline, agreed fee, invoiced amount and status. Leave business records blank. Do not invent clients, dates or fees.

Before inserting the table, decide what one row represents. Use one project per row for this example. If you also need individual invoices, plan that separately instead of mixing projects and invoices in the same list.

• Give each column a clear meaning.
• Choose one currency for the practice sheet.
• Decide who will update the status.
• Remove columns that nobody needs to maintain.

Ask a colleague to describe how they would enter the next project. Any hesitation points to a label or rule worth improving. Save the final instruction alongside your working notes so you can reuse the structure.

Choose headings that answer everyday questions: who owns this, when is it due, and what remains unpaid? Avoid adding a field merely because the assistant suggested it. Keep a column only when someone can explain how the team will use it.

How do you get a useful formula instead of a plausible one?

Specify the input cells, destination and business rule. Gemini can generate formulas using references from your sheet; you select the destination cell and use Insert to add the suggestion. Formula instructions.

A formula is an expression that calculates a result from cell values. In the hypothetical studio tracker, suppose agreed fees are in E and invoiced amounts are in F. Request: “Create a formula for G2 showing the amount still to invoice, using E2 and F2.”

Then add the missing rule: “If the agreed fee is blank, leave the result blank. Explain how the formula handles an invoiced amount greater than the agreed fee.” Decide whether that last case should remain visible or be flagged.

Review these cases before extending the formula. For more ways to describe spreadsheet calculations clearly, see the spreadsheet prompt examples. Adapt the wording to your actual column names.

How do you add dropdowns, filters and sorting?

Name the target range and desired options. A dropdown lets someone choose a value from a prepared list. Gemini supports dropdowns, filters and sorting; proposed edits appear for review before you select Apply. Supported editing actions.

Hypothetical example: project status

Add a dropdown to H2:H50 with these options: Not started, In progress, Waiting for client, Complete. Keep the header unchanged. Show the proposed range before applying the change.

Check the range and spelling in the preview. Next, ask to show only projects marked Waiting for client. Use a separate request to sort those projects by deadline, then inspect whether the result matches your intention.

Write a short definition for each status. Does Complete mean the work is delivered, approved or paid? Choose one meaning and give payment its own field if you need it.

For your first attempt, request each change separately. Keep the request small enough that you can explain what should happen before pressing Apply. If the preview includes an unexpected edit, revise the instruction first.

How do you turn rows into a report you can trust?

Ask a specific question and state which records count. Gemini can answer questions about spreadsheet data, create pivot tables and generate charts. You can inspect an analysis through Analysis steps. Analysis and chart guidance.

A pivot table groups rows into a summary, such as sales by product. For a hypothetical online shop, ask: “Summarize completed orders by product, showing quantity sold and total order value. Exclude cancelled orders.”

Define completed before running the request. Also decide how to treat refunds, delivery charges and discounts. Ask the assistant to state its interpretation, then compare one product's summary with the original rows.

Check the chart's data connection

Google says an inserted Gemini chart uses data placed on a new tab. It does not automatically respond to changes in the original dataset. Before reusing the chart next week, check which data it now represents. Chart update limitation.

Keep the report title precise. Use “completed order value” if that is what you calculated. Before moving from a summary to next month's estimate, read the guide to forecasting sales with AI and define what you want the forecast to support.

When is enhanced Smart Fill the right choice?

Use it for text tasks where you can provide examples. Enhanced Smart Fill identifies relationships between partly completed text columns and suggests remaining values. Google documents desktop availability and support for English values only. Enhanced Smart Fill guidance.

The documented trigger requires at least three example rows and two distinct example output values. It works on text columns, not numeric or date columns. You can inspect a suggestion and accept or reject it. Detection requirements.

Hypothetical example: customer feedback

Put English customer comments in one column and topic labels in the next. Manually label examples as Delivery or Product before reviewing a suggested fill. Include an awkward comment that discusses both topics in your review.

Decide whether each comment gets one main label or needs manual handling. Do not approve the whole suggestion just because the easiest examples look reasonable. If you work mainly with Azerbaijani comments, choose another approach instead of assuming the English-only feature supports them.

What should your first working session produce?

Aim for one checked report and a short instruction someone else can follow. Use a practice copy with unnecessary customer identifiers removed. Choose a task whose answer you can independently verify.

1. Write the question the report must answer.
2. Identify the source tab and relevant columns.
3. Request one change at a time.
4. Compare the output with selected original records.
5. Record corrections and the final prompt.
6. Ask another person to repeat the task.

Measure preparation and checking time together. Record where you still needed to explain a business rule. Those notes give you concrete material for training your team to use AI tools.

Once the steps are reliable, consider the next stage through the guide to automating workflows with Google Sheets. First make the manual review clear enough that another person can perform it.