

Description:
This dual-workflow system automates the full lifecycle of discovering, qualifying, and distributing design or innovation-related content. It scrapes category pages, filters by freshness and relevance, enriches the data, and auto-formats personalized daily content digests.
Data Ingestion:
Pulls category URLs from Google Sheets and scrapes articles using ScrapeNinja, capturing titles, links, and publish dates.
AI-Based Qualification:
Uses OpenAI to analyze each article’s content, checking for trigger keywords, topics, and publication recency (e.g., last 7 days).
Content Curation & Storage:
Cleans data, removes duplicates, and formats validated articles before saving them back to Google Sheets for structured tracking.
Automated Distribution:
A second n8n flow aggregates the best posts, filters fresh content, and generates AI-written summary emails automatically sent via Gmail.

Description: