Generate Images Directly in Google Sheets Using Gemini

Google Sheets now includes a built-in AI image generation tool that transforms your spreadsheet data into custom illustrations—no need to manually describe or recreate your information elsewhere. This is a game-changer for anyone tired of bouncing between apps just to visualize data.
Previously, the only way to generate images from your sheet data was through Gemini's sidebar chat feature, which meant manually writing prompts or copying-and-pasting your spreadsheet content into the chat window. Now with this integrated tool, Gemini reads your selected data directly and produces relevant visual representations. This guide walks you through the entire process of creating AI images in Google Sheets.
Generating AI Illustrations in Google Sheets
Before you start, make sure your Google Sheets interface is set to English—this feature currently requires it.
Here's the example data we'll be working with:

Step 1:
Start by selecting the data range you want to visualize, then click Gemini > Generate an image to create imagery based on that selection.

Step 2:
Enter a detailed prompt describing how you want Gemini to transform your data, then hit send. Here's an example:
Create a professional infographic based only on the selected data. Keep all shop names, product names, and revenue figures exactly as shown in the spreadsheet. Do not add, remove, or modify any data. Present the revenue information clearly and visually in an easy-to-read layout.
Gemini will then display follow-up questions on the right panel—asking how you'd like the graphic styled, what the primary purpose is, and whether you have any additional requirements. These suggestions vary depending on your data. Once you've configured your preferences, tap Next at the bottom.
Step 3:
Give Gemini a moment to generate the image based on your selections. If no insert option appears in Google Sheets automatically, you can save the image through the right-click context menu.
Important Note on Text in Generated Images
While Gemini produces visually stunning and engaging illustrations, the text within those images can sometimes have spelling or accuracy issues—especially with non-English languages. The tool occasionally alters product names or changes data slightly compared to your source material. For images containing critical figures or important content, always double-check the results before using them in presentations or reports.
Step-by-Step Process for Creating Images with Gemini in Google Sheets
Ready to harness AI's capabilities? Follow these straightforward steps:
Step 1: Open Your Sheet and Launch Gemini
Go to your Google Sheets document. In the top-right corner (next to your profile picture), click the Gemini icon.

Step 2: Access the Tools Menu
A side panel will open on the right. In the chat window, click the Tools button.

Step 3: Select Image Creation
From the available tools list, select Create Images.

Step 4: Write Your Prompt
Type a detailed description of the image you want to create into the input field. For example: "A futuristic 3D chart showing sustainable growth trends."

Submit Your Request: Press the Submit button and let Gemini process your instructions.
Insert Into Your Sheet: Once Gemini displays the generated image options, if you're happy with the result, simply click Insert to place it directly into your spreadsheet.
Key Benefits of Creating AI Images Directly in Google Sheets
Integrating Gemini into Google Sheets isn't just a fun gimmick—it delivers real, measurable value to your workflow:
- Streamlines Your Process: No more switching between browser tabs, cloud storage, or image editors. Everything lives in one place, from raw data to polished visuals.
- Personalizes Your Visuals: Instead of relying on generic stock photos, you create custom imagery that aligns perfectly with your specific reports and business goals.
- Saves Time and Money: You essentially get a 24/7 design assistant ready to handle image requests instantly—without paying for external image licenses or freelance designers.
- Boosts Professionalism: Your presentations and reports become more dynamic, eye-catching, and easier to understand, which helps capture attention from stakeholders and leadership.
Description: Learn how to create AI-generated illustrations straight from your spreadsheet data without extra steps or copying content.
Related Articles
- ExcelMerger Pro: Combine Multiple Excel Files Into One
- How to Change Gemini Live's Voice to Your Preferred Option
- Create a National Day Celebration Video: A Step-by-Step Guide
- Teaching AI to Remember Your Writing Style: A Self-Learning System
- What is Google Sheets Canvas? Turn Your Spreadsheet into an Interactive Dashboard











































