How it works:
This workflow automates the entire LinkedIn content distribution process — from AI-powered post creation to auto-posting on both personal LinkedIn profiles and LinkedIn groups, using GPT-4o and Google Sheets as the content source and control panel.
- Auto-generates professional LinkedIn posts from spreadsheet topics using GPT-4o.
- Posts to your LinkedIn profile and multiple groups.
- Updates status to avoid duplicate posting.
- Fully customizable and reusable with your spreadsheet.
Set up Steps
-
Create and Upload the Spreadsheet
- Name it: Linkedin Post
- Sheet1 (for post topics): Columns: ID | Linkedin Post Title | Status
- Add post titles under Linkedin Post Title
- Set Status to Pending
- Create new sheet name as "Groups" (for group distribution): Column: GroupIds
- Add LinkedIn Group IDs, one per row
-
Connect Google Sheets Nodes
- Connect your Google account to these nodes:
- Linkedin Post topic (Reads post topics)
- Get group id (Reads LinkedIn groups)
- Update Status (Writes back the status after posting)
-
Configure GPT-4o (OpenAI)
- Add your OpenAI API key in the Linkedin Post creator node
- This node will generate high-quality content from your topic titles
-
Connect LinkedIn Account
- Add your LinkedIn credentials in the Linkedin user detail node
- Ensure appropriate permissions to post on profile and groups
-
Activate the Workflow : Once live, the workflow will:
- Monitor the Google Sheet for Pending posts.
- Generate content via GPT-4o.
- Post to:
- Your LinkedIn Profile
- Each LinkedIn Group listed in the Groups sheet
- Update the post Status to Posted
Customization Tips
Want to personalize this template?
- Change AI tone or style in the OpenAI node prompt
- Add a scheduler node if you'd like to post at fixed intervals
- Use a Slack or Telegram approval step before posting
- Integrate analytics tools to track post performance
Suggested Sticky Notes for Workflow
Node or Section |
Sticky Note Content |
Linkedin Post topic |
Reads the topic titles and statuses from Sheet1 |
OpenAI (GPT-4o) |
Generates content using topic title — you can modify the tone/prompt here |
Linkedin user detail |
Your personal LinkedIn credentials — required to post |
Group loop |
Iterates through LinkedIn Group IDs and posts the content |
Update Status |
Updates spreadsheet so the topic isn't re-posted |