n8n: Weekly Social Analytics Reports to Email via GPT-4o

Get a weekly social analytics email automatically—powered by GPT-4o

This n8n workflow generates a weekly summary of your social performance and emails it to you using GPT-4o—so you don’t have to manually pull metrics or write updates every week.

What this workflow does

Each week, the workflow collects social metrics from your Twitter data, then prepares an easy-to-read report. It uses GPT-4o to turn raw analytics into a concise narrative you can act on. Finally, it sends the resulting report directly via email—delivering a consistent cadence of social insights.

• Runs on a weekly schedule inside n8n
• Retrieves relevant Twitter analytics data
• Processes and formats the metrics using workflow logic (including Code and Set nodes)
• Uses GPT-4o to produce a readable weekly social analytics report
• Sends the report to your inbox with the Email Send step

Use cases

• SaaS operators who need weekly updates on brand and engagement performance without manual reporting
• Automation engineers who want a ready-made pattern for “metrics → AI summary → email” using n8n
• Social media managers who want a lightweight weekly digest covering key Twitter indicators
• Founders and teams who prefer decision-ready summaries delivered on schedule

Technical details

• n8n nodes used: set, code, merge, twitter, email send, sticky note
• AI summarization: GPT-4o (to convert analytics into a weekly report)
• Delivery: Email Send to send the generated social analytics report