Simple Metrics

AI Generated in Google Sheets

How to generate AI Images in Google Sheets?

—

by

Simple Metrics
in

Discover how to generate and display AI-created images directly in Google Sheets with our easy-to-follow tutorial. Ideal for content creators, e-commerce, education, and more.

Watercolor style illustration of a woman seen from behind in a café, with a lazy atmosphere.
Watercolor style illustration of a woman seen from behind in a café, with a lazy atmosphere.
Side view illustration in watercolor style, depicting the interior of The Great Cave in Niah National Park. The cave is filled with towering stone walls and a mysterious atmosphere. Light streams in through an opening in the cave, creating a dramatic beam effect. An orangutan, dressed in explorer attire, stands on a protruding point inside the cave with arms outstretched, contrasting starkly with the cave's immense scale, highlighting the grandeur of the scene.
Side view illustration in watercolor style
Showa era leisure time
Showa era leisure time

Tutorial

  1. Install Add-on at Google Workspace Marketplace.
  2. Click Extension -> Gemini AI for Sheets -> Use Gemini Formulas
  3. Type in a formula =IMAGEN(“Watercolor style illustration of a woman seen from behind in a café, with a lazy atmosphere.”).
  4. After getting the Image URL, type in another formula =IMAGE(Image URL) to display the image in Google Sheets.
Step 2

Use Cases

  • Content Creation: Quickly produce images for blogs and social media.
  • E-commerce: Create product images for online stores.
  • Education: Generate images for teaching materials and research.
  • Art and Design: Explore artistic variations and concepts.
  • Game Development: Produce game graphics like textures and concept art.
  • Reporting: Automatically add relevant images to reports and presentations.