Back to Templates
Automated Social Media Content Generator with ChatGPT & Tavily Research
This n8n template turns a simple spreadsheet of ideas into ready-to-publish content for LinkedIn, X, and Instagram.
It uses Tavily to find recent insights from the web and ChatGPT to craft optimized posts automatically — writing results back to your sheet.
⚙️ Good to know
Triggers automatically when a new row is added to your Google Sheet.
Uses Tavily for intelligent web research based on your topic.
Generates three platform-specific posts (LinkedIn, X, IG) using ChatGPT.
Saves all results back into the same sheet — no manual copying.
Requires API keys for OpenAI, Tavily, and Google Sheets credentials.
🧭 How it works
Step 1 — Watch the Sheet & Prepare Inputs
A Google Sheets Trigger monitors your content sheet with six columns:
Campaign
Content topic
Target audience
X
IG
The Set Search Fields node structures this data for later steps.
Step 2 — Research with Tavily
The Search Internet node calls Tavily’s API (insert your key here) to fetch fresh news and articles about the topic.
Split Out unfolds the search results; Aggregate compiles them into a single, clean dataset used by the LLMs.
Step 3 — Generate Platform-Optimized Posts
Each platform uses a dedicated ChatGPT agent:
LinkedIn – long-form, insightful, paragraph breaks, 1–2 emojis, 3–5 hashtags, and a call to action.
X – ≤ 280 characters, concise and catchy, 1–3 hashtags, 1–2 emojis.
Instagram – scannable text with CTA, hashtags, and image suggestions for posts/carousels.
Finally, Update Campaign writes the generated posts back into your sheet (LinkedIn, X, and IG columns) using the campaign name as the match key.
🧩 How to use
Prepare your Google Sheet
Columns: Campaign, Content topic, Target audience, LinkedIn, X, IG.
Keep the last three empty — they’ll be filled automatically.
Connect credentials
Google Sheets → account owning the document.
Tavily → enter your API key in the Search Internet node.
OpenAI → connect your key in the three generation nodes (LinkedIn, X, IG).
Run
Add a new row to the sheet and watch the workflow automatically research, write, and update the row with finished posts.
🧾 Requirements
n8n instance
Google Sheets access
OpenAI API key
Tavily API key
🧱 Customizing this workflow
Tone & Voice – Edit system prompts in each GPT node.
Research Depth – Adjust max_results or search_depth in Tavily.
Localization – Modify prompts for language or region.
Formatting – Add post templates, hashtags, or links.
Quality Control – Add moderation or length checks before saving results.
A/B Testing – Duplicate platform nodes to create and compare multiple drafts.
💡 Tips
Keep topics focused — one clear idea per row.
Use Tavily’s news topic for the freshest insights.
Test on a few rows to calibrate tone and hashtags before scaling.
✅ In short:
Idea in Google Sheet → Tavily research → ChatGPT writes LinkedIn/X/IG posts → Auto-update in sheet.
Plug in your keys, run once, and your content pipeline writes itself.