Step 2: Connect Google Sheets

Two sheets provide source links and RSS feeds, and two sheets store outputs. All Google Sheets nodes require OAuth2 credentials.

1. Open Fetch Seed Links and select the document with Document set to [YOUR_ID] and Sheet set to Save Initial Links. Credential Required: Connect your googleSheetsOAuth2Api credentials.
2. Open Retrieve RSS Sources and set Document to [YOUR_ID] and Sheet to RSS Links. Credential Required: Connect your googleSheetsOAuth2Api credentials.
3. In Store Initial Records, set Operation to appendOrUpdate and map columns: link → {{ $json.link }}, title → {{ $json.title }}, pubDate → {{ $json.pubDate }}. Credential Required: Connect your googleSheetsOAuth2Api credentials.
4. In Append Relevant to Sheets, set Operation to append and map columns such as title → {{ $('Topic Relevance Classifier').item.json.title }} and summary → {{ $json.summary }}. Credential Required: Connect your googleSheetsOAuth2Api credentials.

Step 3: Configure RSS Parsing and Date Filtering

This path pulls RSS items, normalizes dates, filters by recency, and splits into parallel streams.

1. In Parse RSS Feed, set URL to ={{ $json.rss_feed_url }} to read each feed from the sheet.
2. In Normalize Publish Date, set pubDate to ={{ new Date($json.pubDate).toISOString() }} and keep the other content fields as mapped in the node.
3. In Date Range Check, keep the condition that compares ={{ new Date($json.pubDate).getTime() }} to ={{ new Date(Date.now() - 10* 24 * 60 * 60 * 1000).getTime() }} so only the last 10 days are processed.
4. In Map Filtered Fields, preserve the field mappings for pubDate, title, link, and content fields as shown.
5. Confirm that Map Filtered Fields outputs to both Store Initial Records and Rejoin Streams in parallel.

Step 4: Deduplicate and Rebuild Full Items

This stage merges seeds with parsed items, removes duplicates, and restores full content for summarization.

1. Ensure Fetch Seed Links and Store Initial Records both feed into Combine Inputs, then to Keep Date and Link.
2. In Keep Date and Link, keep only pubDate and link with values set to ={{ $json.pubDate }} and ={{ $json.link }}.
3. Leave Deduplicate Links as-is to filter unique links using its JavaScript logic.
4. Confirm that Deduplicate Links and Map Filtered Fields both flow into Rejoin Streams, then into Rebuild Full Items.
5. Keep Rebuild Full Items as-is so it reconstructs content-rich items for the next step.

Step 5: Set Up AI Classification and Summarization

Content is cleaned, classified for relevance, and summarized using the LLM chain connected to OpenAI models.

1. Keep Strip HTML Content as-is to generate cleanedContent from RSS HTML.
2. In Topic Relevance Classifier, set Input Text to ={{ $json.title }}{{ $json.cleanedContent }} and keep the category definitions.
3. OpenAI Chat Model A is connected as the language model for Topic Relevance Classifier — ensure credentials are added to OpenAI Chat Model A. Credential Required: Connect your openAiApi credentials.
4. In LLM Summary Chain, set Text to ={{ $json.cleanedContent }} and keep Prompt Type set to define.
5. OpenAI Chat Model B is connected as the language model for LLM Summary Chain — ensure credentials are added to OpenAI Chat Model B. Credential Required: Connect your openAiApi credentials.

Step 6: Configure Output Destinations

Relevant summaries are formatted and then written to Google Sheets and Notion simultaneously.

1. In Prepare Relevant Output, keep mappings such as article_url → ={{ $('Topic Relevance Classifier').item.json.link }}, summary → ={{ $json.text }}, fetched_at → ={{$now}}, and publish_date → ={{ $('Topic Relevance Classifier').item.json.pubDate.toDateTime().format('yyyy-MM-dd') }}.
2. Confirm that Prepare Relevant Output outputs to both Append Relevant to Sheets and Create Notion Entry in parallel.
3. In Create Notion Entry, keep Resource set to databasePage and map properties: article_url → ={{ $json.article_url }}, summary → ={{ $json.summary }}, fetched_at → ={{ $json.fetched_at }}. Credential Required: Connect your notionApi credentials.

Step 7: Test and Activate Your Workflow

Run the workflow manually to verify each branch and output before activating it for production use.

1. Click Execute Workflow to run from Manual Run Trigger.
2. Verify that Manual Run Trigger starts both Fetch Seed Links and Retrieve RSS Sources in parallel and that the flow progresses through Parse RSS Feed, Date Range Check, and Rebuild Full Items.
3. Confirm that relevant items reach Prepare Relevant Output, then appear in both the Append Relevant to Sheets output sheet and the Create Notion Entry database.
4. Once validated, toggle the workflow Active for production use.