Send weekly social analytics reports with LinkedIn, X, Instagram, Google Sheets and GPT-4o
UnknownUnknown. This template uses community nodes we can't verify statically. Uses community nodes that can't be verified statically (unverified community packages are off by default in 3.0). Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 16 nodes and runs on a schedule (every week at 09:00). Along the way it connects X (Formerly Twitter), Google Sheets, OpenAI and Instagram (community).
How it runs
Trigger: On a schedule (every week at 09:00).
- WES Config (Edit Fields (Set)): sets 4 fields: weight_like, weight_comment, weight_share…
- Get LinkedIn Posts (HTTP Request): calls an HTTP API
- Search Tweets (X (Formerly Twitter)): search
- Get media (Instagram): get media (ig user)
- Merge: merges the data from its input branches
- Merge: merges the data from its input branches
- Normalize & Validate Posts (Code): runs custom JavaScript code
- Loop Over Batches (Loop Over Items (Split in Batches)): loops over the items in batches
- Calculate Analytics (WES) (Code): runs custom JavaScript code
- Wait for All Branches (Merge): merges the data from its input branches
…plus 5 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that @mookielianhd/n8n-nodes-instagram is verified or supports 3.0 (used in Get media).
Nodes used (11)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Edit Fields (Set)
n8n-nodes-base.set - HTTP Request
n8n-nodes-base.httpRequest - X (Formerly Twitter)
n8n-nodes-base.twitter - Instagram
@mookielianhd/n8n-nodes-instagram.instagram - Merge
n8n-nodes-base.merge - Code
n8n-nodes-base.code - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Google Sheets
n8n-nodes-base.googleSheets - OpenAI
@n8n/n8n-nodes-langchain.openAi - Send Email
n8n-nodes-base.emailSend
From the author
Quick overview This workflow runs every Monday, pulls the last 7 days of posts from LinkedIn, X (Twitter), and Instagram, normalizes engagement metrics, logs raw post data to Google Sheets, calculates a weighted engagement rate, generates strategy…