Skip to main content

Automated product ad image creation with OpenAI, Gemini & Google Workspace

Workflow preview

Workflow preview
100%
Automated product ad image creation with OpenAI, Gemini & Google Workspace preview
Open on n8n.io

Important notice

This workflow is provided as-is. Please review and test before using in production.

1. Workflow Overview

How it works This workflow automates the generation of ad ready product images by combining product and influencer photos with AI styling. It runs on a scheduled trigger, fetches data from Google S...

Best for

  • Content Creation automation workflows
  • Multimodal AI automation workflows
  • advanced n8n builders looking for reusable templates

Tools used

n8n-nodes-base.googledrive, @n8n/n8n-nodes-langchain.openai, n8n-nodes-base.scheduletrigger, n8n-nodes-base.extractfromfile, n8n-nodes-base.googlesheets, n8n-nodes-base.httprequest, n8n-nodes-base.code, n8n-nodes-base.converttofile

Source and attribution

This workflow is cataloged by N8N Workflows and links back to its original n8n.io source page by Avkash Kakdiya.

Original n8n.io source

1.1 Workflow description

Title
Automated product ad image creation with OpenAI, Gemini & Google Workspace
Workflow name
Automated product ad image creation with OpenAI, Gemini & Google Workspace

How it works

This workflow automates the generation of ad-ready product images by combining product and influencer photos with AI styling. It runs on a scheduled trigger, fetches data from Google Sheets, and retrieves product and influencer images from Google Drive. The images are processed with OpenAI and OpenRouter to generate enhanced visuals, which are then saved back to Google Drive. Finally, the result is logged into Google Sheets with a ready-to-publish status.

Step-by-step

1. Trigger & Data preparation

  • Schedule Trigger – Runs workflow automatically on a set schedule.
  • Google Sheets (Get the Raw) – Retrieves today’s product and model URLs.
  • Google Drive (Download Product Image) – Downloads the product image.
  • Google Drive (Download Influencer Image) – Downloads the influencer image.
  • Extract from File (Binary → Base64) – Converts both product and model images for AI processing.

2. AI analysis & image generation

  • OpenAI (Analyze Image) – Creates an ad-focused visual description (lighting, mood, styling).
  • HTTP Request (OpenRouter Gemini) – Generates an AI-enhanced image combining product + influencer.
  • Code Node (Cleanup) – Cleans base64 output to remove extra prefixes.
  • Convert to File – Transforms AI output into a proper image file.

3. Save & update

  • Google Drive (Upload Image) – Uploads generated ad image to target folder.
  • Google Sheets (Append/Update Row) – Stores the Drive link and updates publish status.

Why use this?

  • Automates the entire ad image creation process without manual design work.
  • Ensures product visuals are consistent, styled, and ad-ready.
  • Saves final creatives in Google Drive for easy access and sharing.
  • Keeps campaign tracking organized by updating Google Sheets automatically.
  • Scales daily ad production efficiently for multiple products or campaigns.

1.2 Logical Blocks

This catalog entry is organized from the workflow JSON. The node-level section below shows the executable blocks available for review before importing the template.

2. Block-by-Block Analysis

Block 1 - download_influencer_image

Type / Role
n8n-nodes-base.googleDrive - googleDrive
Config choices
Version 3

Block 2 - upload_image

Type / Role
n8n-nodes-base.googleDrive - googleDrive
Config choices
Version 3

Block 3 - Analyze image

Type / Role
@n8n/n8n-nodes-langchain.openAi - openAi
Config choices
Version 1.8

Block 4 - Schedule Trigger

Type / Role
n8n-nodes-base.scheduleTrigger - scheduleTrigger
Config choices
Version 1.2

Block 5 - Download Product Image

Type / Role
n8n-nodes-base.googleDrive - googleDrive
Config choices
Version 3

Block 6 - Convert Binary to Text

Type / Role
n8n-nodes-base.extractFromFile - extractFromFile
Config choices
Version 1

Block 7 - Get the Raw

Type / Role
n8n-nodes-base.googleSheets - googleSheets
Config choices
Version 4.7

Block 8 - influencer_image_Convert_to_Text

Type / Role
n8n-nodes-base.extractFromFile - extractFromFile
Config choices
Version 1

Block 9 - Image Generation

Type / Role
n8n-nodes-base.httpRequest - httpRequest
Config choices
Version 4.2

Block 10 - base64 cleanup

Type / Role
n8n-nodes-base.code - code
Config choices
Version 2

Block 11 - Convert to File

Type / Role
n8n-nodes-base.convertToFile - convertToFile
Config choices
Version 1.1

Block 12 - Update Spreadsheet with Results

Type / Role
n8n-nodes-base.googleSheets - googleSheets
Config choices
Version 4.7

Block 13 - Sticky Note

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 14 - Sticky Note1

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 15 - Sticky Note2

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

3. Summary Table

Workflow Automated product ad image creation with OpenAI, Gemini & Google Workspace
Complexity advanced
Nodes 15
Categories Content Creation, Multimodal AI
Author Avkash Kakdiya
Published 16 Sept 2025

4. Reproducing the Workflow from Scratch

  1. 1. Download the workflow JSON

    Use the JSON export at /data/workflows/8627/8627.json as the source template for this automation.

  2. 2. Import the template into n8n

    Open n8n, import the downloaded JSON, and review each node before activating the workflow.

  3. 3. Configure credentials and variables

    Replace placeholder credentials, API keys, webhook URLs, account IDs, and environment-specific values with your own settings.

  4. 4. Test with sample data

    Run the workflow manually or in a staging workspace, inspect node output, and confirm downstream systems receive the expected data.

  5. 5. Activate and monitor

    Enable the workflow only after testing, then monitor executions, errors, and rate limits during the first production runs.

5. General Notes & Resources

Review imported nodes carefully before activation. This catalog entry is intended to help you inspect the workflow structure, understand required services, and find related templates faster.

Node names, credentials, schedules, webhook paths, and external service limits may need adjustment for your workspace.

Frequently asked questions

What does Automated product ad image creation with OpenAI, Gemini & Google Workspace do?

How it works This workflow automates the generation of ad ready product images by combining product and influencer photos with AI styling. It runs on a scheduled trigger, fetches data from Google S...

What do I need before importing this workflow?

Review the workflow JSON, configure any required credentials in n8n, and test the automation in a safe workspace before using it in production.

Can I customize this workflow?

Yes. Use the block-by-block analysis and the downloadable JSON to inspect each node, then adjust credentials, prompts, schedules, filters, or destinations for your Content Creation, Multimodal AI use case.