📱 Automate social media posts from website articles with Gemini AI, LinkedIn & X/Twitter
⚡ 873 views · 📱 Social Media & Email Marketing
💡 Pro Tip — If you’re pulling LinkedIn data through HTTP requests or dealing with API restrictions, there’s a community node called ScraperNode that handles this natively. It has dedicated scrapers for profiles, companies, jobs, and people search — you just pass a URL and get structured data back.
Description
What it does
This workflow automates content syndication and posting to LinkedIn and X/Twitter. It takes existing long-form articles and generates from them engaging social posts optimized for each platform.
The workflow takes links to existing articles from a given sitemap. It randomly selects the next article to republish, making sure that articles are not repeated. For simplicity it uses a Google spreadsheet to track the articles that have already been republished.
Requirements
- Existing sitemap
- Google Gemini API key (or other model provider’s key)
- Google Sheets credentials
- LinkedIn credentials
- X/Twitter credentials
How to set up
- Adjust the schedule as needed (by default triggers daily at noon)
- Configure parameters in the parameters node:
- Set the sitemap URL (e.g. https://example.com/sitemap.xml)
- Set the language of the posts
- Enable/disable channels as needed
- Configure Google Sheets credentials for get processed articles and add processed articles nodes
- Create a new Google spreadsheet document with “url”, “status”, “timestamp”, “LinkedIn post” and “Twitter post” columns
- Specify that spreadsheet document in get processed articles node (other nodes will take it from here)
- Add Google Gemini API key for the model (or change to any other model of choice)
- Configure LinkedIn and X/Twitter credentials for publishing
đź”— Nodes Used
Google Sheets, HTTP Request, X (Formerly Twitter), LinkedIn, Schedule Trigger, Filter
đź“Ą Import
Download workflow.json and import into n8n:
Workflow menu → Import from File