Skip to main content

Generate social content pillars, calendars and posts using Google Sheets and OpenAI

Workflow preview

Generate social content pillars, calendars and posts using Google Sheets and OpenAI preview
Open on n8n.io

Important notice

This workflow is provided as-is. Please review and test before using in production.

Overview

How it works

This workflow turns a single planning row in Google Sheets into a fully structured content engine. It generates weighted content pillars, builds a rule-based posting calendar, and then creates publish-ready social posts using AI. The workflow strictly controls format routing, CTA rules, and execution order. All outputs are written back to Google Sheets for easy review and execution.

Step-by-step

  • Step 1: Input capture & pillar generation

    • Google Sheets Trigger – Detects new or updated planning rows.
    • Get row(s) in sheet – Fetches brand, platform, scheduling, and promotion inputs.
    • Message a model – Calculates calendar metrics and generates platform-specific content pillars.
    • Code in JavaScript – Validates AI output and enforces 100% weight distribution.
    • Append row in sheet – Stores finalized content pillars in the pillars sheet.
  • Step 2: Calendar generation & routing

    • Message a model7 – Generates a full day-by-day content calendar from the pillars.
    • Code in JavaScript7 – Normalizes calendar data into a sheet-compatible structure.
    • Append row in sheet6 – Saves calendar entries with dates, formats, CTAs, and status.
    • Switch By Format – Routes items based on Video vs Non-Video formats.
  • Step 3: Post creation & final storage

    • Loop Over Items – Processes each calendar entry one at a time.
    • Message a model6 – Creates complete hooks, captions, CTAs, and hashtags.
    • Code in JavaScript6 – Formats AI output for final storage.
    • Append row in sheet7 – Stores publish-ready posts in the final sheet.
    • Wait – Controls pacing to avoid API rate limits.

Why use this?

  • Eliminates manual content planning and ideation.
  • Enforces strategic content mix and CTA discipline.
  • Produces platform-ready posts automatically.
  • Keeps all planning, calendars, and content in Google Sheets.
  • Scales content operations without extra overhead.