Automated Social Media Content Generator with ChatGPT & Tavily Research
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 LinkedIn 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. An n8n automation workflow template by Mirai.
Mirai
web
paid
Others in the same category, ranked by how often they are opened.
