Zero‑Touch Social: An n8n + Supabase Pipeline That Writes, Renders, and Posts for You

The Problem

Manual content ops are a drag on growth. Your team burns hours writing copy, hunting assets, exporting sizes, rendering videos, logging into pages, and posting one‑by‑one. Then come the missed windows, inconsistent branding, broken handoffs, version chaos, and platform API errors at the worst moment. Spreadsheets become the source of truth no one trusts. Creativity stalls because the pipeline is the bottleneck.

The Engineering Solution

We ship an end‑to‑end content engine built entirely on the PDV stack. It drafts, renders, approves, schedules, and publishes to Facebook and Instagram without human touch—while keeping you in control.

• Source of truth in Supabase

  • Tables: content_briefs, assets, calendar_slots, approvals, posts.
  • Storage: raw uploads, generated images/videos with signed URLs.
  • Statuses: draft → generate → review → scheduled → published → synced_insights.

• Orchestration in n8n

  • Triggers: Cron for daily/weekly drops; Webhook for ad‑hoc briefs.
  • Sub‑workflows: reusable modules (generate_copy, render_visuals, meta_publish, insights_pull) via Execute Workflow.
  • Data handling: Binary Data to move image/video payloads; Code nodes (JS) for templating, slugging, UTM stamping.
  • Resilience: per‑node retry/backoff, error routes to escalate and auto‑requeue.

• AI generation (within PDV models)

  • Copy: Gemini drafts captions, hooks, CTAs, and alt text from content_briefs + product links.
  • Images: Nano Banana 2 renders on‑brand visuals (prompted from brand guide + brief).
  • Video: Veo/Sora 2/Kling produce short vertical cuts; n8n polls job status and attaches outputs to Supabase Storage.

• Publish adapters via Meta Graph API

  • Instagram: create media containers (image or reel) and publish when approved/time‑boxed. Captions, tags, and location when applicable.
  • Facebook Pages: publish or schedule posts with captions and media.
  • Token management: OAuth2 credentials stored in n8n; post IDs and links persisted to Supabase for auditability.

• Approvals without friction

  • n8n writes previews to Supabase and flips records to review. Stakeholders approve in a minimal Cloud Run UI or from a signed preview link.
  • Rejections push items back to generate_copy or render_visuals with reason codes.

• Scheduling and rate‑limit discipline

  • calendar_slots table computes per‑profile windows and time zones.
  • A queue sub‑workflow enforces API pacing and exponential backoff so bursts don’t trip Graph API limits.

• Measurement loop

  • After publish, an insights_pull sub‑workflow fetches reach/engagement metrics and stores them in Supabase for dashboards and creative iteration.

• Optional redundancy with Make.com

  • For teams demanding failover, we mirror the final publish step in Make.com. If a publish error persists in n8n, a Supabase flag triggers the Make scenario to complete the post with the same media and caption.

What it looks like in practice

1. Marketers drop a brief (offer, audience, tone, product URLs) into Supabase.
2. n8n generates copy via Gemini and art via Nano Banana 2; short video via Veo/Sora 2/Kling.
3. Previews are saved as signed URLs; approver flips status to approved.
4. At the scheduled slot, n8n publishes to Instagram/Facebook through Meta Graph API and records post IDs.
5. Insights sync nightly; winning patterns feed back into prompts and templates.

The PDV Advantage

• Operator‑first build: We don’t sell another tool—we deliver a working pipeline you can own, extend, and audit.
• Stack discipline: Only n8n/Make, Supabase, GCP Cloud Run, and approved AI models. No fragile mystery middleware.
• Asset velocity: Daily output without headcount. Captions, images, and vertical cuts roll off an assembly line.
• Governance baked in: Approvals, version history, and a single source of truth. Every post is traceable to a brief.
• Platform‑native publishing: Direct Meta Graph API calls; we respect rate limits and API changes with queued, idempotent delivery.

Our Service: Social Media Engine

• We design, implement, and operate your pipeline: n8n workflows, Supabase schema, Cloud Run preview/approval UI, and Meta integrations.
• SLA options add Make.com failover, 24/7 monitors, and monthly prompt/creative refresh.

Ready to stop hand‑posting?

Book a Build Sprint. In two weeks we’ll deploy your Zero‑Touch Social pipeline and start shipping daily posts you don’t have to babysit.