Breaking news aggregator with SendGrid and PostgreSQL
UnknownWhat this workflow does
This workflow has 10 nodes and runs on a schedule (every 24 hours). Along the way it connects SendGrid, Postgres and Scrapegraphai (community).
How it runs
Trigger: On a schedule (every 24 hours).
- Define Regulatory Sources (Code): runs custom JavaScript code
- Loop Through Sources (Loop Over Items (Split in Batches)): loops over the items in batches
- Scrape Regulatory Page (Scrapegraph Ai): uses Scrapegraph Ai
- Normalize & Score Impact (Code): runs custom JavaScript code
- Add Timestamp & Metadata (Edit Fields (Set)): sets or maps fields
- High Impact? (If): checks a condition and branches into true / false
- Prepare Email Content (Edit Fields (Set)): sets or maps fields
- Store Regulation Record (Postgres): uses Postgres
- SendGrid: uses SendGrid
Services it uses
Scraping pages by hand? Firecrawl is a simpler option (10% off for new users).
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that n8n-nodes-scrapegraphai is verified or supports 3.0 (used in Scrape Regulatory Page).
Nodes used (8)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Code
n8n-nodes-base.code - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Scrapegraph Ai
n8n-nodes-scrapegraphai.scrapegraphAi - Edit Fields (Set)
n8n-nodes-base.set - If
n8n-nodes-base.if - SendGrid
n8n-nodes-base.sendGrid - Postgres
n8n-nodes-base.postgres
From the author
Breaking News Aggregator with SendGrid and PostgreSQL ⚠️ COMMUNITY TEMPLATE DISCLAIMER: This is a community-contributed template that uses ScrapeGraphAI (a community node). Please ensure you have the ScrapeGraphAI community node installed in your n8n instance…