Auto-Post LinkedIn Updates from Spreadsheet Topics using GPT-4o
Stworzone przez
Ostatnio edytowane 8 dni temu
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)
- Connect your Google account to these nodes:
-
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 |
Może Cię Zainteresować
Nowy w Świecie n8n?
Potrzebujesz pomocy przy budowie nowych schematów n8n? Automatyzajce procesów dla Ciebie lub Twojej firmy pozwolą oszczędzić ci czas i pieniądze, a do tego bez żadnych kosztów!