Generate automated social media reports with GPT-4o, Twitter, Facebook & Notion
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 12 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Azure OpenAI Chat Model, Google Sheets, Notion and Gmail and 1 more. It also calls api.x.com and graph.facebook.com over HTTP.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Fetch Twitter Metrics (X API) (HTTP Request): calls api.x.com
- Fetch Facebook Page Metrics (Graph API) (HTTP Request): calls graph.facebook.com
- Merge: merges the data from its input branches
- Validate API Response Integrity (If): checks a condition and branches into true / false
- Normalize & Format Social Data (JavaScript) (Code): runs custom JavaScript code
- Log Errors in Google Sheets (Google Sheets): append
- Generate HTML Social Performance Report (AI) (AI Agent): runs an AI agent, with model: Configure GPT-4o Model
- Save Report to Notion Database (Notion): work with database page
- Send Email Summary to Marketing Team (Gmail): uses Gmail
- Announce Summary in Slack (Slack): uses Slack
Services it uses
HTTP calls to: api.x.com, graph.facebook.com
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (11)
- Manual Trigger
n8n-nodes-base.manualTrigger - Azure OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatAzureOpenAi - HTTP Request
n8n-nodes-base.httpRequest - Merge
n8n-nodes-base.merge - If
n8n-nodes-base.if - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - AI Agent
@n8n/n8n-nodes-langchain.agent - Notion
n8n-nodes-base.notion - Gmail
n8n-nodes-base.gmail - Slack
n8n-nodes-base.slack
From the author
Description Automate your weekly social media analytics with this end-to-end AI reporting workflow. 📊🤖 This system collects real-time Twitter (X) and Facebook metrics, merges and validates data, formats it with JavaScript, generates an AI-powered HTML…