LinkedIn post automation with AI (GPT-4o) generation & Slack approval

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 | 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: - rliteprofile - Read profile data - remailaddress - Access email - wmembersocial - Post content - rworganizationadmin - 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