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.