Find eyewitness YouTube footage of breaking events with OpenAI, Google Sheets and Telegram

Description

Quick overview Help your newsroom be first to credible eyewitness footage. During a breaking event, this automation keeps watch on YouTube and sends editors only the clips worth checking, earliest upload first, so they can contact the original creator and verify faster. How it works Receives an editor’s form submission to open an event window with one or more YouTube search queries and a monitoring duration. Appends the event window to the Google Sheets “Events” tab and posts an “event opened” message to Telegram. Runs every 15 minutes, reads the “Events” and “Footage Log” tabs from Google Sheets, and plans searches for each active event while respecting credit and paging limits. Queries YouTube through the RecentReborn search API (optionally paging), stops early when daily quota is low, and collects new video results not already logged. Scores and categorizes new videos using keyword rules and (optionally) an OpenAI chat model to label titles as eyewitness, news reupload, commentary, or unrelated and to flag likely copies. Appends all new videos to the Google Sheets “Footage Log” tab, updates counters and closes expired or deactivated events in the “Events” tab. Sends a Telegram digest with new eyewitness candidates and problems for the run, and posts a wrap-up summary when an event window closes. Setup Create a Google Sheet with tabs named “Events” and “Footage Log” and matching column headers expected by the workflow. Add credentials for Google Sheets OAuth2, Telegram (bot token), and HTTP Header Auth for the RecentReborn API (Authorization: Bearer …). Add an OpenAI API credential if you keep AI labeling enabled (set useAi to false in the config to run rules-only). In the configuration values, set sheetUrl to your Google Sheet URL and telegramChatId to the chat that should receive digests and alerts. Activate the workflow and use the form URL (path: /eyewitness-event-window) to start an event window and begin monitoring. Requirements A RecentReborn API account (app.recentreborn.com) with an API key Additional info Visit https://recentreborn.com/developers for more tutorials and templates. An n8n automation workflow template by Felix M.

Community Metrics

Categories

• Automation
• AI

Tags

• n8n
• workflow
• google-sheets
• http-request
• telegram
• code
• basic-llm-chain
• openai-chat-model

Capabilities

• 6 nodes

Information