Send weekly YouTube performance digests with OpenAI, Slack, Gmail and Sheets
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 13 nodes and runs on a schedule (cron 0 8 * * 1). Along the way it connects Slack, Google Sheets, Gmail and OpenAI. It also calls googleapis.com over HTTP.
How it runs
Trigger: On a schedule (cron 0 8 * * 1).
- Fetch Recent Channel Videos (HTTP Request): calls googleapis.com
- Extract Video IDs (Code): runs custom JavaScript code
- Fetch Video Statistics (HTTP Request): calls googleapis.com
- Parse & Score Videos (Code): runs custom JavaScript code
- Aggregate: combines items into one
- Message a model (OpenAI): uses OpenAI
- Prepare Digest Data (Edit Fields (Set)): sets 6 fields: aiInsight, allVideos, topVideo…
- Post Digest to Slack (Slack): uses Slack
- Split Videos for Logging (Split Out): splits a list into separate items
- Log Videos to Sheet (Google Sheets): append
…plus 2 more steps. See the full node list below.
Services it uses
HTTP calls to: googleapis.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 (10)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - Aggregate
n8n-nodes-base.aggregate - Edit Fields (Set)
n8n-nodes-base.set - Slack
n8n-nodes-base.slack - Split Out
n8n-nodes-base.splitOut - Google Sheets
n8n-nodes-base.googleSheets - Gmail
n8n-nodes-base.gmail - OpenAI
@n8n/n8n-nodes-langchain.openAi
From the author
Quick overview This workflow runs every Monday to fetch your latest YouTube videos, calculate performance rankings, generate an OpenAI insight summary, then share a weekly digest to Slack, log metrics to Google Sheets, and email an HTML report via Gmail. How…