Step 2: Connect Ghost and Retrieve Articles

Pull recent blog posts from Ghost to build the promotion dataset.

1. Open Retrieve Blog Articles and set Operation to getAll.
2. Set Limit to 3.
3. Credential Required: Connect your Ghost credentials.
4. Connect Retrieve Blog Articles to Map Post Fields.

Step 3: Map Fields and Batch Processing

Normalize article fields and loop through each post for clean content processing.

1. In Map Post Fields, add assignments for each field:
   • id → {{ $json.id }}
   • title → {{ $json.title }}
   • featured_image → {{ $json.feature_image }}
   • excerpt → {{ $json.excerpt }}
   • content → {{ $json.html }}
   • link → {{ $json.url }}
2. Connect Map Post Fields to Iterate Article Batches.
3. In Iterate Article Batches, leave Options empty to use the default batch size.

Step 4: Clean HTML and Merge Content Streams

Strip HTML from the post content and combine clean data before AI drafting.

1. In Strip Markup Text, keep the Code as provided to convert HTML into clean_content.
2. Connect Iterate Article Batches to both Strip Markup Text and Combine Clean Content as shown in the workflow.
3. In Combine Clean Content, set Mode to combineBySql.
4. Combine Clean Content outputs to both Generate LinkedIn Copy and Merge Social Drafts in parallel.

Step 5: Set Up AI Drafting with OpenAI

Generate LinkedIn promotional copy from the cleaned article content using an OpenAI chat model.

1. Open Generate LinkedIn Copy and set Text to =Article Title: {{ $json.title }} Article Link: {{ $json.link }} Article Content: {{ $json.clean_content }}.
2. Keep Prompt Type set to define, and preserve the system instructions in Options → System Message.
3. Ensure OpenAI Chat Engine is connected as the language model for Generate LinkedIn Copy (AI language model connection).
4. Credential Required: Connect your OpenAI credentials in OpenAI Chat Engine (not in Generate LinkedIn Copy).
5. In OpenAI Chat Engine, set Model to gpt-4o-mini.

Step 6: Merge Drafts and Append to Google Sheets

Merge AI output with article fields and log everything to a Google Sheet.

1. In Merge Social Drafts, set Mode to combineBySql.
2. Connect Merge Social Drafts to Append to Sheet.
3. In Append to Sheet, set Operation to append.
4. Map the columns in Append to Sheet using expressions:
   • id → {{ $json.id }}
   • title → {{ $json.title }}
   • content → {{ $json.content }}
   • excerpt → {{ $json.excerpt }}
   • clean_content → {{ $json.clean_content }}
   • linkedin_post → {{ $json.output }}
   • featured_image → {{ $json.featured_image }}
5. Select your Document and Sheet Name in Append to Sheet.
6. Credential Required: Connect your Google Sheets credentials.

Step 7: Test and Activate Your Workflow

Run a manual test to confirm article retrieval, AI generation, and sheet logging work end-to-end.

1. Click Execute Workflow and run from Manual Start Trigger.
2. Confirm Retrieve Blog Articles returns up to 3 posts.
3. Verify Generate LinkedIn Copy outputs a professional LinkedIn draft in output.
4. Check Append to Sheet for a new row with all mapped fields and the generated post.
5. When satisfied, toggle the workflow to Active for production use.