Step 2: Connect Google Sheets for Input and Output

Pull the full input row and prepare the three output destinations for pillars, calendar rows, and final posts.

1. Open Retrieve Sheet Rows and select Document your_google_sheet_id_here and Sheet gid=0.
2. Credential Required: Connect your Google Sheets credentials (this node has none configured).
3. Open Append Pillar Rows and set Operation to append.
4. Map the columns using the exact expressions:
   • Platform → {{ $json.Platform }}
   • Weight (%) → {{ $json["Weight (%)"] }}
   • CTA Allowed → {{ $json["CTA Allowed"] }}
   • Pillar Name → {{ $json["Pillar Name"] }}
   • Allowed Formats → {{ $json["Allowed Formats"] }}
   • Primary Purpose → {{ $json["Primary Purpose"] }}
5. Open Append Calendar Rows and set Operation to append, then map:
   • Date → {{ $json.Date }}
   • Sr No → {{ $json["Sr No"] }}
   • Format → {{ $json.Format }}
   • Status → {{ $json.Status }}
   • CTA Type → {{ $json["CTA Type"] }}
   • Platform → {{ $json.Platform }}
   • Pillar ID → {{ $json["Pillar ID"] }}
   • Hook Angle → {{ $json["Hook Angle"] }}
   • Post Intent → {{ $json["Post Intent"] }}
6. Open Append Final Posts and set Operation to append, then map:
   • CTA → {{ $json.CTA }}
   • Date → {{ $json.Date }}
   • Sr No → {{ $json["Sr No"] }}
   • Hashtags → {{ $json.Hashtags }}
   • Main Content → {{ $json["Main Content"] }}
   • Hook (Option 1) → {{ $json["Hook Option 1"] }}
   • Hook (Option 2) → {{ $json["Hook Option 2"] }}
   • Platform Variant → {{ $json["Platform Variant"] }}
7. Credential Required: Connect your Google Sheets credentials in Append Pillar Rows, Append Calendar Rows, and Append Final Posts (none configured).

Step 3: Set Up Pillar Generation and Parsing

This stage uses AI to create content pillars and parses them into clean rows for the pillar sheet.

1. Open Pillar Metrics AI and select Model gpt-4o.
2. Confirm the prompt uses the input fields such as {{ $json['Brand Name'] }}, {{ $json['Industry'] }}, {{ $json['Platform'] }}, and {{ $json['Duration (Days)'] }}.
3. Credential Required: Connect your OpenAI credentials in Pillar Metrics AI (this node has none configured).
4. Open Parse Pillar Output and keep the JavaScript parser as provided to validate weights and format the Google Sheets rows.
5. Verify the execution order: Retrieve Sheet Rows → Pillar Metrics AI → Parse Pillar Output → Append Pillar Rows.

Step 4: Build and Store the Content Calendar

Generate a full posting calendar from the pillars, format the results, and route by format.

1. Open Calendar Builder AI and select Model gpt-4o.
2. Confirm the prompt references the input sheet using expressions like {{ $('Retrieve Sheet Rows').item.json['Start Date'] }} and {{ $('Retrieve Sheet Rows').item.json['Posting Frequency / Week'] }}.
3. Credential Required: Connect your OpenAI credentials in Calendar Builder AI (none configured).
4. Open Format Calendar Rows and keep the JavaScript parser to map Sr No, Date, Platform, Format, and CTA Type.
5. Verify the flow: Append Pillar Rows → Calendar Builder AI → Format Calendar Rows → Append Calendar Rows → Route By Format.
6. In Route By Format, keep the two rules:
   • Rule 1: equals with Left Value {{ $json.Format }} and Right Value Video
   • Rule 2: notEquals with Left Value {{ $json.Format }} and Right Value Video

Step 5: Generate Post Copy in Batches with Delay

This path iterates through calendar entries, generates content, appends final posts, and enforces a delay between items.

1. Confirm the sequence: Append Calendar Rows → Route By Format → Iterate Calendar Items → Post Copy AI → Parse Post Content → Append Final Posts → Delay Between Posts → Iterate Calendar Items.
2. Open Iterate Calendar Items and leave default options to process items one by one.
3. Open Post Copy AI and select Model gpt-4o.
4. Ensure the prompt uses expressions like {{ $json["Sr No"] }}, {{ $json.Platform }}, and {{ $json["CTA Type"] }}.
5. Credential Required: Connect your OpenAI credentials in Post Copy AI (none configured).
6. Open Parse Post Content and keep the JavaScript logic that pulls the original date from $('Iterate Calendar Items').item.json.
7. Open Delay Between Posts and configure wait timing as needed for rate limiting (currently no parameters set).

Step 6: Test and Activate Your Workflow

Run a manual test, verify data in all three sheets, and then turn on the automation.

1. Click Execute Workflow to trigger a manual run with sample data in the input sheet.
2. Confirm successful execution by checking:
   • Append Pillar Rows writes new pillar rows
   • Append Calendar Rows writes calendar entries
   • Append Final Posts writes completed post copy
3. Inspect the execution logs for Parse Pillar Output, Format Calendar Rows, and Parse Post Content to ensure no JSON parsing errors.
4. When satisfied, toggle the workflow to Active to enable hourly updates from Sheet Update Trigger.