Automate professional LinkedIn post creation with AI — powered by GPT-5, n8n & Google Sheets
Generate, refine, and publish thought-leadership posts with zero manual effort.
Transform trending topics into polished content ready to engage your audience.
- 🔄 Fully Automated Workflow — fetch topics, research web content, generate posts, and update your sheet
- 🧠 AI-Powered Writing — GPT-5 crafts original, scannable, inspiring LinkedIn posts
- 🌍 Tavily Web Search Integration — fetches top 3 articles for contextually rich insights
- 📊 Google Sheets as CMS — manage topics and track post completion status
- 💬 Ready-to-Publish Output — includes emojis, hashtags, and reflective CTAs
- 🧩 No-Code Setup — import directly into n8n
| Node | Description |
|---|---|
| Manual / Schedule Trigger | Starts the workflow manually or at a set time daily |
| Google Sheets | Reads a list of “To Do” topics |
| HTTP Request | Fetches 3 top articles related to each topic using Tavily API |
| AI Agent | Analyzes the articles and crafts an original LinkedIn post |
| OpenAI Chat Model (GPT-5) | Powers the content generation |
| Google Sheets Update | Writes the final post and marks the topic as “Done” |
The AI agent follows an internal SOP (Standard Operating Procedure):
- Extract Insights from top 3 articles
- Paraphrase into new sentences (7–8 lines, short & scannable)
- Maintain a professional + inspiring tone
- Add 1–2 emojis & 3–5 hashtags
- End with a reflective or question-based CTA
| Topic | Status | Content |
|---|---|---|
| “AI Product Strategy” | To Do | |
| “Growth in SaaS Markets” | To Do | |
| “Leadership in Uncertain Times” | Done | “Innovation thrives on uncertainty 🌱…” |
-
Trigger Workflow
- Manually (when you click “Execute”) or automatically at 9 AM.
-
Fetch Article Data
- Uses Tavily API to retrieve top 3 articles per topic.
-
Generate Post
- OpenAI Agent transforms insights into a polished post.
-
Update Google Sheet
- Writes post content and changes status to “Done”.
This workflow requires three APIs to function properly.
Follow the quick steps below to connect them inside n8n before running the LinkedIn Content Creator workflow.
| Service | Usage | Setup Steps |
|---|---|---|
| 🧠 OpenAI API Key | Used by GPT-5 model for AI text generation | 1. Go to your OpenAI Dashboard 2. Create a new Secret Key 3. In n8n → Credentials → OpenAI API → Paste your key |
| 🌐 Tavily API Key | Fetches top 3 web articles related to each LinkedIn topic | 1. Sign up at Tavily 2. Copy your Bearer Token 3. In n8n → HTTP Request node → under Headers, set Authorization: Bearer YOUR_KEY |
| 📊 Google Sheets OAuth2 | Reads & updates your LinkedIn Topics Sheet | 1. Go to Google Cloud Console 2. Enable Google Sheets API 3. Create OAuth2 credentials 4. In n8n → Credentials → Google Sheets OAuth2 → Connect your account |
⚙️ Once these credentials are connected, the workflow will automatically:
- Fetch trending topics from Google Sheets
- Gather top insights via Tavily
- Generate polished LinkedIn posts with OpenAI GPT-5
| Node | Credential Type | Connected Account |
|---|---|---|
| OpenAI (Generate Post) | OpenAI API | openai_gpt5_key |
| Tavily (Fetch Trends) | HTTP Request | tavily_bearer_token |
| Google Sheets (Update Topics) | Google Sheets OAuth2 | linkedin_sheets_auth |
Use Environment Variables in n8n for better security:
OPENAI_API_KEY=sk-xxxxx
TAVILY_API_KEY=tavily-xxxxx
GOOGLE_CLIENT_ID=xxxxx.apps.googleusercontent.com
GOOGLE_CLIENT_SECRET=xxxxx- Open n8n → Import Workflow
- Paste the contents of:
/workflows/linkedin-content-creator.json
The complete JSON (ready to import) file has been attached in repo.
Find the link of the attached sheet for your reference.
- n8n (Automation platform)
- OpenAI GPT-5 (Content generation)
- Google Sheets API (Data source & output)
- Tavily API (Web search for article content)
- Add Notion or Airtable as data sources
- Post directly to LinkedIn via Zapier or Make
- Generate post carousels or Twitter threads
Muskkan Iyer
AI Product Analyst | Data Enthusiast | Automation Builder
⭐ Star this repo if you find it helpful!
Made with ❤️ by AI enthusiast