N8N Weekly Analytics Report: AI-Powered YouTube Performance Insights

Never miss important trends in your YouTube analytics. This workflow automatically fetches your data weekly and uses AI to provide actionable insights delivered to your inbox.

What This Workflow Does

• Weekly Schedule: Runs every Monday at 9 AM
• Data Collection: Fetches YouTube Analytics data
• AI Analysis: GPT-4 analyzes trends and provides insights
• Email Report: Sends a formatted report to your email

Metrics Tracked

• Daily views and watch time
• Subscriber gains/losses
• Estimated revenue
• Top performing videos
• Engagement rates (likes, comments)

Prerequisites

• N8N instance
• YouTube Analytics API access
• OpenAI API key
• Email sending capability (SMTP/SendGrid)

Step-by-Step Setup

Step 1: Configure Weekly Schedule

• Add "Schedule Trigger" node
• Set to weekly, Monday, 9:00 AM
• Choose your timezone

Step 2: Fetch YouTube Analytics

• Add "YouTube" node
• Resource: Analytics
• Configure metrics:

- views

- likes

- comments

- subscribersGained

- estimatedRevenue

• Date range: Last 7 days

Step 3: AI Analysis

• Add "OpenAI" node
• Prompt:

Analyze this YouTube analytics data and provide insights:

{{ JSON.stringify($json) }}

Provide:
Key trends from the past week
Best performing day and why
Areas for improvement
Content recommendations for next week
Revenue forecast if trends continue

Step 4: Send Email Report

• Add "Send Email" node
• Configure:

- To: [email protected]

- Subject: Weekly YouTube Analytics - {{ DateTime.now().toFormat('MMM dd, yyyy') }}

- Body: {{ $json.choices[0].message.content }}

Sample Report Output

Weekly YouTube Analytics Report

📈 Key Trends:

Your channel saw a 23% increase in views compared to last week...

>

🏆 Best Day: Wednesday

Your video on "AI Tools" drove 40% of weekly traffic...

>

💡 Recommendations:

1. Post more AI-related content

2. Optimize posting time to Wednesday evenings...

Download the Workflow

Get this workflow from our N8N Workflows page.