Filter and approve UK regulatory news with Google Sheets, Hugging Face, OpenAI, Firecrawl and Jev
Ready for 3.0What this workflow does
This workflow has 41 nodes and runs manually, when you click “Execute workflow” (plus 1 other trigger). Along the way it connects Google Sheets. It also calls api.openai.com, api.firecrawl.dev and api.typesafe.ai over HTTP.
How it runs
Trigger: Manually, when you click “Execute workflow” (plus 1 other trigger).
- Configure context (Edit Fields (Set)): sets 17 fields: sheetDocumentId, sourceTab, articlesTab…
- Start fresh this run? (If): checks a condition and branches into true / false
- Fetch live articles too? (If): checks a condition and branches into true / false
- Clear previous packages (Google Sheets): clear
- Continue after clear gate (Merge): merges the data from its input branches
- Live fetch (FCA Press Release) (RSS Read): reads an RSS feed
- Clear seen ledger (Google Sheets): clear
- Read source articles (Google Sheets): uses Google Sheets
- Read seen ledger (Google Sheets): uses Google Sheets
- Map live articles to dataset shape (Edit Fields (Set)): sets 7 fields: id, title, summary…
…plus 29 more steps. See the full node list below.
Services it uses
HTTP calls to: api.openai.com, api.firecrawl.dev, api.typesafe.ai
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 (14)
- Manual Trigger
n8n-nodes-base.manualTrigger - Webhook
n8n-nodes-base.webhook - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - Filter
n8n-nodes-base.filter - Aggregate
n8n-nodes-base.aggregate - Switch
n8n-nodes-base.switch - HTTP Request
n8n-nodes-base.httpRequest - If
n8n-nodes-base.if - Merge
n8n-nodes-base.merge - RSS Read
n8n-nodes-base.rssFeedRead - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Wait
n8n-nodes-base.wait
From the author
Quick overview This workflow pulls article links from Google Sheets and optional live RSS feeds, filters and deduplicates them using Hugging Face or OpenAI embeddings, then uses Firecrawl plus TypeSafe JEV scoring to approve the most relevant stories and…