Back to Templates

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

Created by

Created by: Evoort Solutions || evoortsolutions

Evoort Solutions

Last update

Last update 15 hours ago

Share


🖼️ 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

Node Description
1. Manual Trigger Starts the workflow when executed manually
2. Google Sheets2 Reads all rows from the input Google Sheet
3. Loop Over Items Processes one row (prompt) at a time
4. If2 Filters only rows where Prompt is not empty and drive path is empty
5. HTTP Request1 Calls 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. Code1 Decodes the base64 image returned by the API
9. Google Drive1 Uploads 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. Wait Delays 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:

Column Purpose
Prompt The AI prompt to send to the API
Image url (Optional) Initial image URL
drive path Updated with Drive link by flow
Generated Date Auto-filled by the workflow
Base64 Stores 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!