Generate AI product marketing photos from Google Sheets with Google Gemini and Drive

About

How it works Reads product image links from a Google Sheet. Analyzes each image, generates an AI prompt, and combines the product with a human model image. Creates final AI advertising photos and: Saves images to Google Drive. Saves prompts + result links to a separate “output” sheet. Here’s an updated version of the note, optimized so the customer knows exactly what they must customize (no hard‑coded IDs assumed). One‑time setup for your own account Before using the workflow, you must point it