Hébergement VPS n8n | Automatisation sécurisée et évolutive
Formation n8n en Français : Automatisation & Agents IA
<aside> 🎯
This is the build-along course for the workflow Turn LinkedIn post reactions into AI content ideas in Google Sheets. Follow it node by node, live, to re-create the automation from scratch. Every prompt, expression and value is in a copy-paste code block.
</aside>
Every day, the workflow pulls the LinkedIn posts you reacted to, keeps only the recent ones, asks GPT to reframe each one into an original content idea (angle, hook, takeaway, format, hashtags), and saves everything into a Google Sheet — with no duplicates.
flowchart LR
A["Daily Trigger"] --> B["Configuration"]
B --> C["Fetch LinkedIn Reactions"]
C --> D["Split Reactions"]
D --> E["Filter Recent Reactions"]
E --> F["Limit AI Analysis"]
F --> G["AI Content Strategist"]
G --> H["Format Idea Row"]
H --> I["Save to Google Sheets"]
The AI Content Strategist has two attached sub-nodes: an OpenAI Chat Model (the brain) and a Content Idea Parser (forces clean JSON output).
<aside> 🔑
You need three credentials. Never paste API keys directly into a node — always store them in n8n credentials.
</aside>
| Credential | n8n type | Where to get it | Used by |
|---|---|---|---|
| RapidAPI account | Header Auth (httpHeaderAuth) | rapidapi.com → subscribe to a LinkedIn Data API (linkedin-api8) | Fetch LinkedIn Reactions |
| OpenAi account | OpenAI (openAiApi) | platform.openai.com → API keys | OpenAI Chat Model |
| Google Sheets account | Google Sheets OAuth2 | Connect your Google account in n8n | Save to Google Sheets |