Generate weekly Twitter & Facebook performance reports with GPT-4o analysis

by Rahul Joshi ✓ · 143 views · created 2025-11-06 · Market Research, AI Summarization

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, Gmail, Facebook Graph API and Google Sheets. It also calls api.x.com over HTTP.

How it runs

Trigger: Manually, when you click “Execute workflow”.

1. Fetch Recent Tweets (HTTP Request): calls api.x.com
2. Fetch Recent Facebook Posts (Facebook Graph API): uses Facebook Graph API
3. Format Twitter Post Data (Code): runs custom JavaScript code
4. Format Facebook Post Data (Code): runs custom JavaScript code
5. Merge: merges the data from its input branches
6. Validate API Response Integrity (If): checks a condition and branches into true / false
7. Consolidate Social Data Summary (Code): runs custom JavaScript code
8. Log Errors in Google Sheets (Google Sheets): append
9. Generate HTML Social Performance Report (AI Agent): runs an AI agent, with model: Configure GPT-4o Model
10. Send Email Summary to Marketing Team (Gmail): uses Gmail

Services it uses

Azure OpenAI Chat ModelGmailFacebook Graph APIGoogle Sheets

HTTP calls to: api.x.com

Before you upgrade to n8n 3.0

Nodes used (10)

• Manual Triggern8n-nodes-base.manualTrigger
• Azure OpenAI Chat Model@n8n/n8n-nodes-langchain.lmChatAzureOpenAi
• Gmailn8n-nodes-base.gmail
• HTTP Requestn8n-nodes-base.httpRequest
• Facebook Graph APIn8n-nodes-base.facebookGraphApi
• Coden8n-nodes-base.code
• Mergen8n-nodes-base.merge
• Ifn8n-nodes-base.if
• Google Sheetsn8n-nodes-base.googleSheets
• AI Agent@n8n/n8n-nodes-langchain.agent

From the author

Description Automate your weekly cross-platform social media analytics workflow with AI-powered insights. 📊🤖 This system retrieves real-time Twitter (X) and Facebook data, validates and merges the metrics, formats them via custom JavaScript, generates a…

View the original on n8n.io → Check your own copy