Summarise any YouTube channel into Google Sheets with n8n (free workflow)

说明与用途

使用 n8n、Apify 和 OpenAI 自动提取并总结 YouTube 视频，结果存储在 Google 表格中。

问题

Need to monitor many YouTube channels without watching every video, capturing key announcements, tools, and topics.

结果

Automated weekly extraction and summarization of the latest 3 videos per channel, producing a searchable Google Sheet archive.

工作流

• Schedule Trigger every Monday 7:00
• HTTP Request to Apify transcript Actor
• Filter to keep videos with transcripts
• Remove Duplicates keyed on videoId to ensure idempotence
• Basic LLM Chain with OpenAI Chat Model to generate summary
• Edit Fields to select columns
• Google Sheets node to append row

证据

every Monday it takes the newest videos of a channel, summarises them with an LLM and adds one row per video to a Google Sheet.

来源

The HTTP Request node calls Apify's synchronous run endpoint…

来源

Transcripts: $0.002 per video that has a transcript…

来源