Generate automated content performance reports from YouTube, TikTok and Skool with AI

by Jordan ✓ · 610 views · created 2025-12-04 · Market Research, AI Summarization

What this workflow does

This AI workflow has 43 nodes and runs on a schedule (every minute) (plus 1 other trigger). Along the way it connects YouTube, Airtable, OpenRouter Chat Model and Gmail. It also calls api.apify.com and googleapis.com over HTTP.

How it runs

Trigger: On a schedule (every minute) (plus 1 other trigger).

1. Get skool members (HTTP Request): calls an HTTP API
2. Get channel stats (YouTube): get
3. Get tiktok followers (HTTP Request): calls an HTTP API
4. Get last weeks vids (YouTube): work with video
5. Get skool members (HTTP Request): calls an HTTP API
6. Get tiktok data (HTTP Request): calls api.apify.com (POST)
7. Get channel stats (YouTube): get
8. Get week lable (Code): runs custom JavaScript code
9. Markdown: converts between Markdown and HTML
10. Format youtube sub count (Edit Fields (Set)): sets 1 field: YT subs

…plus 30 more steps. See the full node list below.

Services it uses

YouTubeAirtableOpenRouter Chat ModelGmail

HTTP calls to: api.apify.com, googleapis.com

Before you upgrade to n8n 3.0

Nodes used (13)

• Schedule Triggern8n-nodes-base.scheduleTrigger
• Markdownn8n-nodes-base.markdown
• HTTP Requestn8n-nodes-base.httpRequest
• YouTuben8n-nodes-base.youTube
• Airtablen8n-nodes-base.airtable
• Mergen8n-nodes-base.merge
• Coden8n-nodes-base.code
• Ifn8n-nodes-base.if
• Edit Fields (Set)n8n-nodes-base.set
• OpenRouter Chat Model@n8n/n8n-nodes-langchain.lmChatOpenRouter
• Aggregaten8n-nodes-base.aggregate
• Basic LLM Chain@n8n/n8n-nodes-langchain.chainLlm
• Gmailn8n-nodes-base.gmail

From the author

This n8n template acts as your automated social media data analyst. Instead of manually checking your analytics across different dashboards every week, this workflow scrapes your latest stats, calculates your week-over-week growth, and uses AI to write a…

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