LinkedIn Post Automation with AI and Slack by Amit MehtaLinkedIn Post Automation with AI and Slack by Amit Mehta

LinkedIn Post Automation with AI and Slack

Amit Mehta

Amit Mehta

LinkedIn Post Automation with AI (GPT-4o) Generation & 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:
Monitor spreadsheet for new topics every minute
Generate LinkedIn post using GPT-4
Send to Slack for approval/editing
Upload image to LinkedIn
Publish to profile and groups
Update spreadsheet status to Posted

๐Ÿ” Workflow Logic

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

๐Ÿงฉ Node Descriptions

Node Name Description Linkedin-Post-Topic Monitors spreadsheet for new post topics Validate-Status Filters only 'Pending' items Limit Processes one item at a time Linedin-Post-Creator Generates post content using GPT-4 Format-Content Prepares content for Slack display Approval-on-Slack Sends interactive approval message Webhook Receives Slack button responses Format-Response Extracts edited content from Slack Set-Final-Message Prepares approved content Linkedin-User-Detail Fetches LinkedIn user info Register Image Initiates LinkedIn image upload Upload Image Uploads image to LinkedIn Linkedin-post Publishes to personal profile Get-Group-id Retrieves LinkedIn group IDs Post-Linkedin-Groups Posts to multiple groups Update-Status Marks as completed in sheet

๐Ÿ› ๏ธ 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

Node/Section Sticky Note Content Linkedin-Post-Topic "Triggers every minute for new posts in your spreadsheet" Validate-Status "Filters to process only 'Pending' items - prevents duplicates" Linedin-Post-Creator "Uses GPT-4 to generate LinkedIn content - customize prompt for your brand voice" Approval-on-Slack "Sends for human review - edit the Slack user to change approver" Webhook "Receives approval responses - ensure URL is configured in Slack app" Register Image "Initiates LinkedIn media upload - requires valid image URL from sheet" Linkedin-post "Publishes to your profile - update with your LinkedIn credentials" Post-Linkedin-Groups "Posts to multiple groups - add group IDs in Groups sheet" Update-Status "Marks as 'Posted' to prevent reprocessing"

๐Ÿ’ก 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

Component Purpose Google Sheet Store post topics and status LinkedIn App API access for posting Slack App Interactive approval flow OpenAI Account GPT-4 content generation N8N Instance Workflow execution

๐Ÿงช 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

File Name Purpose Linkedin Post Google Sheet to hold post topics and status

๐Ÿท Suggested Tags & Categories

#LinkedIn
#AI
#ContentAutomation
#SocialMedia
#Slack
#GPT4
#Marketing
#WorkflowAutomation
Like this project

Posted Jun 23, 2025

Automated LinkedIn post creation and approval using AI and Slack.