30-Day Social Content Pipeline: AI-Generated Visuals at Scale
10-step n8n workflow reading approved marketing email copy from Google Sheets, passing the full body text directly to Gemini 2.5 Flash Image as the generation prompt, uploading 4 variations per content piece to Drive, and writing image links back to the sheet — $63K+/year in design labour eliminated, ROI 10,500–13,500% per batch.
The Problem
Manual visual content process per piece: copywriter creates text (30 min) → designer interprets copy (15 min) → creates 4 image variations (2–3 hours) → review/revision (30–60 min) → export + upload (10 min) + track in sheet (5 min) = 3.5–4.5 hours per content piece. For 20 content pieces: 70–90 hours of design work = $5,250–6,750 per batch at $75/hour. Designer dependency meant one sick day delayed the entire content calendar. A/B testing different visual approaches required days and additional designer spend. Brand inconsistency compounded across sessions and different designers. In a real BrainLink batch: 3 weeks + $5,000 in design labour for 20 images.
The Solution
10-node n8n workflow triggered on demand. (1) Manual trigger — user runs workflow when content is ready for visuals. (2) Google Sheets reads Hook Number, Hook Name, Email Subject, and full Email Body (400–600 words marketing copy). (3) Filter: only processes rows where APPROVEDIMAGE = 'REGENERATE' — human curation gate before any API spend. (4) Limit node caps at 5 content pieces per run to respect Gemini rate limits. (5) JavaScript extracts per-piece data: hook_number, hookname, email_subject, email_body, row_number. Key insight: the email body text serves directly as the image generation prompt — no separate prompt engineering step. (6) Loop processes each content piece sequentially. (7) Gemini 2.5 Flash Image (`models/gemini-2.5-flash-image`) generates image from email body in ~3 seconds, returns PNG. (8) 3-second wait node prevents rate limit violations between images. (9) Google Drive upload with systematic naming: Image1_Hook14.png, Image2_Hook14.png — returns webViewLink. (10) JavaScript aggregates all 4 image URLs per hook into single row; Google Sheets updated with Image1–Image4 column links matched on Hook Number.
Tech Stack
Results
- Image creation: 3.5–4.5 hours per piece → 3 seconds — 99%+ faster. For 20 pieces: 90 hours → under 20 minutes (4 workflow runs of 5 pieces each)
- Cost: $5,250–6,750 per batch → ~$0.50 in Gemini API costs (20 images × $0.025/image) — 97% cost reduction
- Real BrainLink result: replaced 3 weeks + $5,000 in design labour with 2 days + $2 in API costs
- A/B testing visual approaches now costs fractions of a cent instead of designer day rates — effectively unlimited iteration
- Human curation gate (REGENERATE flag) ensures only approved content triggers API spend and human review catches the ~10% needing regeneration
- $63,000+ saved annually. ROI: 10,500–13,500% per batch