Find eyewitness YouTube footage of breaking events with OpenAI, Google Sheets and Telegram
Ready for 3.0What this workflow does
This AI workflow has 37 nodes and runs when someone submits an n8n form (“Open an event window”) (plus 2 other triggers). Along the way it connects Google Sheets, Telegram and OpenAI Chat Model. It also calls app.recentreborn.com over HTTP.
How it runs
Trigger: When someone submits an n8n form (“Open an event window”) (plus 2 other triggers).
- Set Desk Configuration (Edit Fields (Set)): sets 20 fields: sheetUrl, telegramChatId, formats…
- If: checks a condition and branches into true / false
- Create Event Sheet Row (Code): runs custom JavaScript code
- Fetch Events From Sheet (Google Sheets): uses Google Sheets
- Append Event to Events Tab (Google Sheets): append
- Fetch Footage Log From Sheet (Google Sheets): uses Google Sheets
- Notify Read Failure via Telegram (Telegram): uses Telegram
- Announce Event via Telegram (Telegram): uses Telegram
- Display Save Failure Notice (n8n Form): shows the next form page
- Plan Search and Closing Tasks (Code): runs custom JavaScript code
…plus 23 more steps. See the full node list below.
Services it uses
HTTP calls to: app.recentreborn.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 (15)
- n8n Form Trigger
n8n-nodes-base.formTrigger - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Manual Trigger
n8n-nodes-base.manualTrigger - Edit Fields (Set)
n8n-nodes-base.set - If
n8n-nodes-base.if - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - Telegram
n8n-nodes-base.telegram - n8n Form
n8n-nodes-base.form - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Wait
n8n-nodes-base.wait - HTTP Request
n8n-nodes-base.httpRequest - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Split Out
n8n-nodes-base.splitOut
From the author
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…