How to Generate and Insert Images with Gemini in Google Sheets

You can generate an illustrative image from the Gemini side panel in Google Sheets and insert a result into the spreadsheet. This is useful for a cover sheet, product mockup or visual label. It is not a substitute for a chart that accurately represents the numbers in your cells.

Generate an image in Sheets

1. Open a native Google Sheets file on a computer and select Ask Gemini at the top right. Access depends on your Google Workspace plan and account settings; an Excel-format file may need to be saved as Google Sheets first.
2. In the side panel, write a specific image request. For example: “Create a simple flat illustration of a reusable water bottle on a pale background, with no text, suitable for a product inventory sheet.”
3. Review the suggested images. Hover over one to select Insert, or use Generate more or Edit prompt if it does not fit.
4. After insertion, position and size the image so it does not obscure data or controls. Add a descriptive label or nearby text for readers who need context.

These screenshots show a Tools > Create Images route in an earlier interface. Google's current Sheets help describes prompting directly in the Gemini side panel; follow the controls your account displays. If Gemini is missing, check eligibility and whether an administrator has enabled it. Our Gemini in Sheets overview covers other supported tasks.

Choose the right visual for the job

A generated image can establish a theme or illustrate an object, but it may contain inaccurate details or garbled text. Do not use it to imply a product feature, measurement or finding that you have not verified. For sales trends or budget comparisons, build a chart from the sheet's data instead; see our Gemini chart guide. Review data ranges and axes when using an AI-generated chart.

Keep the prompt focused on subject, style, framing and intended use. Check any organization's image-use policy and the result's suitability before sharing a report externally.