Generate platform-specific social media posts with ChatGPT, Tavily & G-Sheets

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 maxresults or searchdepth 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.