Consistently posting on LinkedIn is crucial for networking, personal branding, and business growth. However, manually posting updates can be time-consuming. With Power Automate, you can schedule, automate, and streamline LinkedIn posts—saving time and ensuring consistency.
In this guide, we’ll show how to automate LinkedIn posts using Power Automate and LinkedIn API, so you can focus on engagement instead of manual posting.
1. Why Automate LinkedIn Posts?
✅ Saves time – No need to post manually every day.
✅ Ensures consistency – Maintain a regular posting schedule.
✅ Works with multiple sources – Automate posts from Excel, RSS feeds, or blogs.
✅ Increases engagement – Focus on responding to comments instead of manual posting.
✅ Supports images and hashtags – Schedule rich media posts with hashtags.
Example:
Set up Power Automate to post a LinkedIn update every Monday at 9 AM from an Excel sheet or a social media calendar.
2. What You Need to Get Started
Before setting up automation, ensure you have:
✔️ A LinkedIn account with admin access (for company pages).
✔️ A LinkedIn Developer Account (to generate API keys).
✔️ Power Automate Premium (LinkedIn API integration requires authentication).
✔️ A spreadsheet or database containing post content.
3. Steps to Automate LinkedIn Posts with Power Automate
Step 1: Register a LinkedIn App
Since Power Automate does not have a direct LinkedIn connector for personal or business posts, you’ll need to use LinkedIn’s API.
1️⃣ Go to LinkedIn Developer Portal.
2️⃣ Click “Create App”, provide details, and submit.
3️⃣ Once approved, go to Auth settings and generate Client ID and Client Secret.
4️⃣ Under Products, enable “Share on LinkedIn” to allow posting via API.
5️⃣ Generate an OAuth access token to authenticate API requests.
Step 2: Set Up a Data Source for Your Posts
You can store your LinkedIn posts in:
✅ Excel (OneDrive/Google Sheets)
✅ SharePoint List
✅ RSS Feed (for blog auto-posting)
✅ Microsoft Forms (for user-generated content)
Example Excel Sheet Layout
| Date | Post Content | Image URL (Optional) | Hashtags |
|---|---|---|---|
| 2025-03-10 | “Power Automate makes life easier!” | image.png | #PowerAutomate, #AI |
| 2025-03-15 | “Check out our latest automation tips!” | #Automation, #Tech |
Step 3: Create a Power Automate Flow
1️⃣ Open Power Automate → Click “Create” → Select “Scheduled cloud flow”.
2️⃣ Set a schedule (e.g., daily at 9 AM to check for new posts).
3️⃣ Click “New Step” → Select “List rows in Excel” (or SharePoint List, RSS Feed).
4️⃣ Click “New Step” → Choose “HTTP” (to send data to LinkedIn API).
5️⃣ Configure the HTTP action:
- Method:
POST - URL:
https://api.linkedin.com/v2/ugcPosts - Headers:
Content-Type: application/json Authorization: Bearer YOUR_ACCESS_TOKEN - Body:
{ "author": "urn:li:person:YOUR_PROFILE_ID", "lifecycleState": "PUBLISHED", "specificContent": { "com.linkedin.ugc.ShareContent": { "shareCommentary": { "text": "@{items('Apply_to_each')?['Post Content']}" }, "shareMediaCategory": "NONE" } }, "visibility": { "com.linkedin.ugc.MemberNetworkVisibility": "PUBLIC" } }
Step 4: Test and Deploy Your Automation
Run the Power Automate flow manually to test it.
If successful, it will post on LinkedIn automatically.
Monitor activity logs in Power Automate for errors.
4. Enhancements and Additional Features
🔹 Auto-post images: Modify the JSON body to include mediaCategory: IMAGE with an image URL.
🔹 Use AI Builder: Generate automated LinkedIn captions using AI-powered suggestions.
🔹 Multi-platform posting: Extend automation to Twitter, Facebook, or Instagram.
🔹 Hashtag management: Store hashtags in a separate column and add dynamically.
🔹 Engagement tracking: Automate LinkedIn analytics collection using Power BI dashboards.