🔧 Project Overview

This n8n automation streamlines the process of drafting, generating, and posting content to LinkedIn using Notion as the content source and OpenAI (via Sora AI) for content and image generation. Here's how the system works

📌 Workflow Steps Overview

1. Create a new Notion card with post content ideas.
2. Set the card status to "Ready to be generated by AI".
3. The workflow:
   • Uses the description to generate a LinkedIn-ready post with the help of Sora AI (powered by OpenAI).
   • Generates an image (if applicable) using AI.
   • Updates the card in Notion with the generated content and image.
   • Changes the status to "Generated by AI".
4. Manually review the generated content in Notion.
5. Once reviewed, set status to "Ready to post".
6. The workflow:
   • Automatically posts the content to LinkedIn.
   • Updates the status in Notion to "Posted".

📂 Tools & Services Used

Notion – for content management and workflow status control.
n8n – automation orchestrator.

Sora AI / OpenAI – for text and image generation.

LinkedIn API – for publishing posts.

🛠️ Detailed Workflow Breakdown

1. Content Creation in Notion

Create a new Notion database item (card).

Fill in:

- **Title**: This will be the basis or hook of your post.
- **Description**: A short brief for the AI to understand the theme.
- **Status**: Set to `Idea` initially.

2. Triggering AI Generation

Change Status to Ready to be generated by AI

n8n Trigger: Watches for changes in Notion status.

n8n Actions:

1. Retrieves the Title and Description from the Notion card.
2. Sends the Description to Sora AI (OpenAI GPT-4) to generate:
   • A professional, engaging LinkedIn post.
   • If relevant, an image prompt is also generated and sent to Sora AI for visual content creation.
3. Saves the generated content back into the Notion card:
   • Adds the LinkedIn post text.
   • Embeds or links the generated image.
4. Updates Status in Notion to Generated by AI.

3. Manual Review Step

You review the AI-generated content in Notion.

Make edits if needed.

Once approved, set the Status to Ready to Post.

4. Publishing to LinkedIn

n8n watches for the status change.

Once detected, the workflow:

- Extracts the final post content and image from Notion.
- Sends the post to the LinkedIn API (your company or personal page).
- Confirms the post was successful.
- **Updates Notion status to** **`Posted`**.