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

Description

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

Import this workflow into your n8n instance
Set up Google Sheets and Google Drive service credentials
Add your RapidAPI key in the HTTP Request node headers
Use the image-to-image-gpt endpoint in the HTTP request
Configure the Google Sheet and Drive folder in the respective nodes
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!