Breaking news aggregator with SendGrid and PostgreSQL

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 before using this template.

This workflow automatically scrapes multiple government and regulatory websites, extracts the latest policy or compliance-related news, stores the data in PostgreSQL, and instantly emails daily summaries to your team through SendGrid. It is ideal for compliance professionals and industry analysts who need near real-time awareness of regulatory changes impacting their sector.

Pre-conditions/Requirements

Prerequisites - n8n instance (self-hosted or n8n.cloud) - ScrapeGraphAI community node installed - Operational SendGrid account - PostgreSQL database accessible from n8n - Basic knowledge of SQL for table creation

Required Credentials - ScrapeGraphAI API Key – Enables web scraping and parsing - SendGrid API Key – Sends email notifications - PostgreSQL Credentials – Host, port, database, user, and password

Specific Setup Requirements | Resource | Requirement | Example Value | |----------------|------------------------------------------------------------------|------------------------------| | PostgreSQL | Table with columns: id, title, url, source, publishedat| newsupdates | | Allowed Hosts | Outbound HTTPS access from n8n to target sites & SendGrid endpoint| https://.gov, https://api.sendgrid.com | | Keywords List | Comma-separated compliance terms to filter results | GDPR, AML, cybersecurity |

How it works