Generate real-estate marketing images and videos with OpenAI and Google Drive

🏡 Automated Real-Estate Content Generation Workflow

This n8n workflow automates turning short user ideas into production-ready real-estate marketing assets (photorealistic images and optional 360° videos). A form submission seeds a prompt board → an LLM refines prompts → the refined prompt is sent to an image/video generator → assets are uploaded to Google Drive and an approval email is sent so stakeholders can accept/reject outputs.

⚙️ How It Works (High Level)

Trigger:
User submits the ideation form (On form submission).

Record:
The raw idea is appended to Google Sheets (Append row in sheet).

Refine:
An AI agent (LangChain/OpenAI) refines the prompt into a photorealistic prompt and produces captions & variants (AI Agent).

Store Refined Prompt:
Update the sheet with the improved prompt (Append or update row in sheet).

Generate Asset:
Send improved prompt to OpenAI image/video generation nodes (Generate an image2 / Generate a video).

Upload & Share:
Upload resulting files to Google Drive (Upload file / Upload file1) and set sharing permissions (Share file / Share file1).

Approval Flow:
Email the requester with the asset + improved prompt and wait for approval (Send message and wait for response).

Decision:
A Switch node routes approved outputs to final storage/notifications and rejected ones back for rework (or sends a failure email).

Video Branch:
Separate flow → refine → HTTP → video generator → upload → share → update sheet (parallel video pipeline).

Quick Setup Guide 👉 Demo & Setup Video 👉 Sheet Template 👉 Course

🔑 Nodes of Interest (Quick Reference)

On form submission — Form trigger for ideation input
Append row in sheet — Initial recording to Google Sheets
AI Agent — LangChain/OpenAI agent for prompt refinement
Generate an image2 — OpenAI image generation node
Upload file / Upload file1 — Google Drive upload nodes
Share file / Share file1 — Set file sharing permissions
Send message and wait for response — Gmail approval workflow
Switch — Approval vs rejection routing
Form + AI Agent1 + Generate a video — Video generation pipeline
Wait / Wait1 — Handle long-running generation
OpenAI Chat Model / OpenAI Chat Model1 — LLM configuration nodes

🔐 What You'll Need (Credentials & Access)

Google Sheets OAuth2 (sheet access)
Google Drive OAuth2 (file storage)
OpenAI API Key (image/video + LLM)
Gmail OAuth2 (email approvals)
n8n webhook/public form access
Optional: External HTTP endpoints for video processing

💡 Tip: Store credentials securely in n8n credential manager and avoid hardcoding secrets.

⚡ Recommended Settings & Best Practices

Model & Prompt Control:**
Use strong system prompts enforcing photorealism and real-estate context.

Rate Limits & Retries:**
Add retry logic with exponential backoff for API calls.

Wait Times:**
Use Wait nodes for long video generation tasks.

File Size & Format:**
Standardize image sizes (e.g., 1792×1024) and compress videos.

Sharing Permissions:**
Use view-only links for approvals.

Logging & Observability:**
Track prompt, model, timestamp in Google Sheets.

Security:**
Use credential manager, rotate API keys regularly.

Cost Control:**
Monitor OpenAI usage and apply limits.

Input Validation:**
Validate prompt length and required fields.

🚀 Customization Ideas

Property type presets (apartment, villa, office, etc.)
Auto-generate captions, hashtags, and listing descriptions
Add AI moderation before sharing assets
Replace Google Drive with S3 / Cloudflare R2 + CDN
Auto-post approved assets to social media or CMS
A/B test prompts for performance optimization
Multi-language prompt support
Slack/Telegram approval dashboard instead of email

🏷️ Tags

n8n, automation, real-estate, prompt-engineering, OpenAI, DALL·E, video, google-sheets, google-drive, gmail, approval-flow, image-generation