Quick overview
Stop writing the same idea four different ways. This workflow learns your tone from a voice library, then drafts matching LinkedIn, Instagram, and X posts from one idea. Human-approved before publishing and it keeps improving with every post.
How it works
- Receives a new content idea submission from an n8n Form trigger.
- Reads the latest voice card from Google Sheets and sends the idea, notes, and voice card to the DeepSeek Chat Completions API to generate a structured core thesis, supporting points, and tone.
- Creates a new content item row in Google Sheets, generates a unique content item ID, and prepares a core message string for downstream drafting.
- In parallel, DeepSeek generates a LinkedIn post (then runs a second DeepSeek QA rewrite pass), an Instagram caption package (caption, visual concept, hashtags), and an X thread (4–7 tweets), and the workflow formats each draft into a consistent record.
- Optionally generates an Instagram image concept with the Google Gemini image generation API, converts the returned base64 image into a PNG, and uploads it to Google Drive.
- Merges the LinkedIn, Instagram, and X drafts, updates the matching content item in Google Sheets to “pending_review”, and sends all drafts to gotoHuman as a single review request.
- When gotoHuman returns an approval/rejection webhook, the workflow publishes approved drafts to LinkedIn, Instagram Graph API, and X API (with retries), marks the item as published in Google Sheets, and prepares a failure alert message if any publish call returns an error.
- Runs weekly to pull published items from Google Sheets, fetches LinkedIn engagement metrics, scores performance, writes results to a Performance sheet, and adds top-performing examples back into a Voice Library Examples sheet.
Setup
- Create a Google Sheets file with tabs for “Voice Library”, “Content Items”, “Performance”, and “Voice Library Examples”, then connect Google Sheets OAuth and set the correct spreadsheet ID/sheet names in all Google Sheets nodes.
- Provide a DeepSeek API key (or compatible OpenAI-style endpoint) and replace the hardcoded Authorization headers in the DeepSeek HTTP requests.
- Set up a gotoHuman account, connect the gotoHuman credential, and ensure your review template includes long-text fields with IDs
linkedinDraft, instagramDraft, and xThread.
- If you want Instagram images, add a Google Gemini API key and configure the Gemini request, then connect Google Drive OAuth and set the target folder for image uploads.
- Replace the placeholder and hardcoded platform values for publishing (LinkedIn author URN and token, Instagram Business ID and access token, X bearer token) and complete any required multi-step publishing logic noted in the workflow comments.