n8nflow.net logo

Generate & Upload Images with Image-to-Image GPT, Google Sheets & Drive

by Evoort Solutionsโ€ขUpdated: Last update 2 months agoโ€ขSource: n8n.io
Loading workflow viewer...

Getting Started

๐Ÿ–ผ๏ธ Image-to-Image AI Generator from Google Sheets with Google Drive Upload


โœ… Use Case

Automatically generate AI images from prompts listed in a Google Sheet, upload the images to Google Drive, and log the result back into the sheet.

Uses the image-to-image-gpt API for fast, customizable generation.


๐Ÿ’ก Problem It Solves

Manual image generation workflows are inefficient and error-prone. Creative and content teams often have to:

  • Manually paste prompts into image generation tools
  • Save images locally
  • Upload to Google Drive
  • Paste the link back into tracking spreadsheets

This automation removes all that frictionโ€”turning one spreadsheet into a complete image creation pipeline.


๐ŸŒŸ Benefits

  • ๐Ÿ” Fully automated image generation
  • ๐Ÿ“ค Direct uploads to Google Drive
  • ๐Ÿงพ Image links and timestamps logged in Google Sheets
  • โš ๏ธ Built-in error logging for API failures
  • ๐Ÿงฉ Modular and easily extensible
  • ๐Ÿ“Š Keeps a historical log of successes and errors

๐Ÿงฉ Workflow Overview

NodeDescription
1. Manual TriggerStarts the workflow when executed manually
2. Google Sheets2Reads all rows from the input Google Sheet
3. Loop Over ItemsProcesses one row (prompt) at a time
4. If2Filters only rows where Prompt is not empty and drive path is empty
5. HTTP Request1Calls the image-to-image-gpt API with the prompt
6. If1 (Error Handling)If an error exists in the API response, route to logging
7. Google Sheets4 (Error Log)Appends error details to a log sheet for review
8. Code1Decodes the base64 image returned by the API
9. Google Drive1Uploads the image to a selected Google Drive folder
10. Google Sheets1 (Write Back)Updates the original row with the image drive path and timestamp
11. WaitDelays the next prompt to prevent hitting API rate limits

๐Ÿ›  Tech Stack

  • n8n (no-code automation)
  • Google Sheets (data input/output)
  • Google Drive (image storage)
  • image-to-image-gpt API via RapidAPI
  • JavaScript (in Code node) for base64 processing

๐Ÿ“ Sheet Format

Your Google Sheet should include the following columns:

ColumnPurpose
PromptThe AI prompt to send to the API
Image url(Optional) Initial image URL
drive pathUpdated with Drive link by flow
Generated DateAuto-filled by the workflow
Base64Stores raw or error data

๐Ÿš€ How to Use

  1. Import this workflow into your n8n instance
  2. Set up Google Sheets and Google Drive service credentials
  3. Add your RapidAPI key in the HTTP Request node headers
  4. Use the image-to-image-gpt endpoint in the HTTP request
  5. Configure the Google Sheet and Drive folder in the respective nodes
  6. Execute manually or add a Cron node for scheduling

๐Ÿ“Œ Example Applications

  • ๐Ÿ› eCommerce : Auto-generate product mockups
  • ๐Ÿงต Fashion/Design : Visualize styles or fabrics from prompts
  • โœ๏ธ Blogging/Content : Auto-generate header images from titles
  • ๐Ÿ“ฃ Marketing : Generate ad banners from text

๐Ÿงช Tips

  • You can add a Cron node if you want this to run on a schedule
  • Use a separate tab/sheet for logging failed prompts
  • Extend the flow by adding:
    • Email notifications
    • Slack alerts
    • File name templating

Create your free n8n account and set up the workflow in just a few minutes using the link below:

๐Ÿ‘‰ Start Automating with n8n

Save time, stay consistent, and grow your LinkedIn presence effortlessly!