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

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.