LinkedIn Post Automation with AI Generation (Gpt-4o) & Slack Approval

How it Works

This workflow automates the creation and publishing of LinkedIn posts with AI-generated content and human approval via Slack, using Google Sheets, OpenAI (GPT-4), Slack Interactive Messages, and the LinkedIn API.

Whether you're a social media manager, content creator, or marketing professional, this workflow helps you maintain consistent LinkedIn presence and scale content creation while keeping human oversight — all managed from a simple spreadsheet.

🎯 Use Case

Ideal for:

• Content Marketers managing multiple LinkedIn accounts
• Personal Brand Builders maintaining regular posting schedule
• Agencies handling client social media presence
• Teams requiring content approval workflows

Setup Instructions

1. Prepare the Spreadsheet

• File name: Linkedin Post
• Main sheet structure:
  | ID | Linkedin Post Title | Status | Image URL |
• Groups sheet structure:
  | GroupIds |
• Add post topics and set their Status as Pending

2. Configure Google Sheets Nodes

Connect your Google account to:

• Linkedin-Post-Topic (Trigger node)
• Update-Status
• Get-Group-id

3. Add API Credentials

• OpenAI API Key → for GPT-4 content generation
• Slack OAuth Token → for approval messages
• LinkedIn Access Token → for posting content
• HTTP Header Auth → Bearer token for LinkedIn API

4. Configure Webhooks

• Set up Slack Interactive Components webhook
• Point Request URL to your N8N webhook endpoint
• Enable interactive messages in Slack app

5. Activate the Workflow

Once live, the workflow will:

1. Monitor spreadsheet for new topics every minute
2. Generate LinkedIn post using GPT-4
3. Send to Slack for approval/editing
4. Upload image to LinkedIn
5. Publish to profile and groups
6. Update spreadsheet status to Posted

🔁 Workflow Logic

1. Trigger: New/updated row with Pending status
2. Generate: AI creates engaging LinkedIn post
3. Approve: Slack message for review/edit
4. Process: Handle approval response
5. Upload: Register and upload image
6. Publish: Post to LinkedIn profile & groups
7. Update: Mark as Posted in sheet

🧩 Node Descriptions

🛠️ Customization Tips

• Adjust AI prompt for brand voice and hashtags
• Change Slack approver or add multiple reviewers
• Modify posting schedule with delay nodes
• Add analytics tracking with additional API calls
• Filter groups based on specific criteria
• Include URL shortening for tracking

📒 Suggested Sticky Notes for Workflow

💡 AI Prompt Configuration

The workflow uses a sophisticated prompt that:

• Creates compelling hooks
• Includes 3-4 informative paragraphs
• Adds engagement questions
• Inserts relevant emojis
• Generates 4-6 hashtags
• Formats with proper spacing

🔒 Security & Permissions

LinkedIn App Requirements:

• r_liteprofile - Read profile data
• r_emailaddress - Access email
• w_member_social - Post content
• rw_organization_admin - Group posting

Slack Bot Permissions:

• chat:write - Send messages
• im:write - Direct messages
• users:read - User information

📎 Required Components

🧪 Testing Tips

• Start with one test topic marked as Pending
• Verify Slack message appears correctly
• Test both "Approve" and "Edit" buttons
• Check image upload completes
• Confirm post appears on LinkedIn
• Verify status updates to Posted

⚠️ Common Issues & Solutions

LinkedIn API Errors:

• Token expiration → Refresh access token
• Rate limits → Add delays between posts
• Group restrictions → Check posting permissions

Slack Integration:

• Missing responses → Verify webhook URL
• Button not working → Check interactive components
• User not found → Confirm Slack user ID

Image Upload Failures:

• Invalid URL → Validate image accessibility
• Size limits → Compress images under 10MB
• Format issues → Use JPEG or PNG only

📊 Workflow Benefits

• Time Savings: 80% reduction in content publishing time
• Consistency: Regular posting schedule maintained
• Quality Control: Human review ensures brand standards
• Scalability: Handle multiple accounts and groups
• Flexibility: Easy to modify and extend

📎 Required Files

🏷 Suggested Tags & Categories

• #LinkedIn
• #AI
• #ContentAutomation
• #SocialMedia
• #Slack
• #GPT4
• #Marketing
• #WorkflowAutomation