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

Description

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.