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

Описание и применение

Автоматизированный процесс извлечения и суммирования последних видео из YouTube‑каналов с помощью n8n, Apify и OpenAI, результаты сохраняются в Google Sheets.

Задача

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…

Источник