How to Generate Images from a Spreadsheet with AI in Make.com

Need a batch of images from a list of ideas? Keep your prompts in a spreadsheet and let Make generate one image per row with DALL-E, then file each result in Google Drive automatically.

• A Make.com account
• A Google Sheet with a column of prompts
• An OpenAI API key with image access
• A Google Drive folder for the output

Step 1: Read the prompt rows

Add the Google Sheets Search Rows module as your trigger. Point it at your sheet and the prompts column. This returns every row, and Make will run the rest of the scenario once per row automatically.

Step 2: Generate the image

Add OpenAI Create an Image (DALL-E). Map the prompt cell into the Prompt field. Choose a size such as 1024x1024 and set the response format to return a URL or base64 image data.

Step 3: Save the image to Drive

Add a Google Drive Upload a File module. Map the image data into the file field, build a file name from the row number or prompt, and choose your output folder.

File name: image_{{1.`__ROW_NUMBER__`}}.png
Data:      {{2.data}}
Folder:    /AI Images

Step 4: Mark the row as done

Add a Google Sheets Update a Row module to write done into the status column. This stops duplicate generations if you re-run the scenario and gives you a clear progress view.

Step 5: Run the batch

Click Run once and watch the modules cycle through each row. Open your Drive folder to confirm one image per prompt has landed.

Result: a folder of fresh AI images, one for every idea in your sheet, generated and named in a single click.