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

1. 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). 2. One‑time setup for your own account Before using the workflow, you must point it to your Google Sheet, Drive folder, and model image.

2.1. Prepare your Google assets Google Sheet

Create or copy a spreadsheet. Create two sheets, for example: Sheet A (input): e.g. “Product Images” Required column: Image-URL Sheet B (output): e.g. “Output Images” Required columns: Image-URL, Prompt, Output Google Drive

Create a folder to store generated AI images (e.g. “AI Product Photos”). Upload one model image (e.g. Model.png) that will be used as the human model in all generated photos. n8n credentials

In n8n, make sure you have: A Google Sheets credential (your Google account). A Google Drive credential. A Google Gemini / PaLM API credential. 2.2. Update the workflow nodes Open the workflow “Automated generation of AI advertising photos for product marketing” and update these nodes:

Node: “Read Image URLs” (Google Sheets)

Set Document / Spreadsheet to your product spreadsheet. Set Sheet to your input sheet (e.g. “Product Images”). Make sure that sheet has a column named exactly Image-URL. Node: “Insert Image URL in Table” (Google Sheets)

Operation: appendOrUpdate (keep as is). Set Document / Spreadsheet to the same spreadsheet as above (or another one if you prefer). Set Sheet to your output sheet (e.g. “Output Images”). Make sure the output sheet has columns: Image-URL Prompt Output Matching column: Image-URL (keeps update‑by‑product behavior). Node: “Download model image” (Google Drive)