Personalized Learning Content Aggregator with AI Filtering - n8n Workflow

Content Curators overwhelmed by daily RSS feeds.
Learners who need highly specific, non-promotional educational resources.
Professionals looking for ready-to-use n8n templates to implement smart data filtering.
Anyone needing a scheduled n8n workflow to manage information intake automatically.

Information overload is a major challenge when tracking specific learning topics. Traditional aggregators often miss the mark, delivering promotional content or outdated materials. This sophisticated n8n workflow solves this by combining powerful content sourcing (RSS and Reddit) with cutting-edge artificial intelligence filtering.

The core value provided by this n8n template lies in its efficiency: it automatically executes on a schedule, fetches articles based on keywords pulled directly from your Google Sheet configuration, and uses an AI n8n node (powered by GPT-4.1-mini) to judge content quality and relevance. Only articles deemed valuable by the AI are saved, creating a clean, focused knowledge base directly in Google Sheets, making this a highly productive n8n workflow.

The process begins with the Schedule Trigger n8n trigger, set to run twice daily (8 AM and 6 PM).

1. Configuration Retrieval: The n8n workflow first retrieves target keywords from a designated Google Sheets location.


2. Keyword Iteration: The Loop Over Keywords n8n node processes each keyword individually, ensuring targeted searches for both RSS and Reddit.


3. Data Fetching: For each keyword, the n8n workflow simultaneously uses the Search RSS Feeds n8n node and the Search Reddit via API n8n node to gather articles and posts.


4. Data Consolidation: The Merge All Search Results n8n node combines the disparate Reddit and RSS data streams into a single dataset.


5. AI Preparation: The Prepare Articles for AI n8n node standardizes the data and formats the aggregated articles into a single text block suitable for the LLM prompt, ensuring the AI can easily analyze the content.


6. Intelligent Filtering: The core of the n8n workflow is the AI Content Filter n8n node (using a LangChain agent powered by the OpenAI Chat Model, configured with gpt-4.1-mini). This AI n8n node analyzes the article text against strict criteria (relevance, educational value, non-promotional) and outputs a JSON array containing only the indices of the selected, high-quality articles.


7. Final Selection & Storage: The Parse AI Response n8n node uses the indices to select the corresponding full article records. Finally, the selected articles are appended as new rows to the designated target Google Sheet using the Save to Google Sheets n8n node.

To deploy this efficient n8n workflow, follow these steps:

1. Import: Copy the provided n8n workflow JSON and paste it into your n8n instance using the 'New' -> 'Import from JSON' option.


2. Credentials: Set up the required credentials in your n8n environment:

1. Configure Sources: Update the Workflow Configuration node with your comma-separated RSS feed URLs.


2. Set Keywords: Ensure your designated Google Sheet contains a list of keywords the n8n workflow should search for.


3. Activate: Set the initial Schedule Trigger - Twice Daily n8n trigger node to 'Active' to begin automated execution of this valuable n8n template.

Schedule Trigger - Twice Daily (n8n trigger): Initiates the n8n workflow every day at 8 AM and 6 PM, ensuring fresh content collection.
Get Keywords from Google Sheets (Google Sheets n8n node): Connects to a specific spreadsheet and worksheet (gid=0) to dynamically pull the user's defined list of learning keywords.
Loop Over Keywords (Code n8n node): Essential for flow control, it iterates over the list retrieved from Google Sheets, allowing subsequent search steps (Reddit and RSS) to run independently for each specific keyword.
Search Reddit via API (HTTP Request n8n node): Executes a search query on the Reddit public API, querying for posts relevant to the currently processed keyword.
Merge All Search Results (Merge n8n node): Combines the items outputted by the parallel RSS and Reddit search branches into a unified list before processing by the AI.
AI Content Filter (LangChain Agent n8n node): This crucial n8n node contains the filtering prompt, instructing the linked OpenAI Chat Model (gpt-4.1-mini) to select high-quality, relevant educational content based on strict criteria.

• Save to Google Sheets (Google Sheets n8n node): The final action, which uses the appendOrUpdate operation to store the curated articles (Title, URL, Source, Description, Date) into the specified target sheet, completing the n8n workflow.