Step 2: Connect Google Sheets

Connect your spreadsheets for feed sources, lookup, and output storage.

1. Open Fetch Feed Directory and confirm Sheet Name is {{ $json["Rss Feeds"] }} and Document ID is {{ $json.Document }}.
2. Credential Required: Connect your googleSheetsOAuth2Api credentials in Fetch Feed Directory.
3. Open Lookup URL in Sheet and confirm the filter uses lookupColumn link with lookupValue {{ $json.link }}.
4. Set Sheet Name to {{ $('Configuration Set').item.json["Articles Sheet"] }} and Document ID to {{ $('Configuration Set').item.json.Document }} in Lookup URL in Sheet.
5. Credential Required: Connect your googleSheetsOAuth2Api credentials in Lookup URL in Sheet.
6. Open Append Summary to Sheets and keep Operation set to appendOrUpdate with useAppend enabled.
7. Credential Required: Connect your googleSheetsOAuth2Api credentials in Append Summary to Sheets.

Step 3: Configure RSS Source Parsing and Filtering

Read the feed directory, parse RSS items, and filter for recent entries before processing.

1. In Iterate Feed List, leave batch settings as-is to cycle through feed rows from Fetch Feed Directory.
2. Open Parse RSS Sources and set URL to {{ $json["RSS URL"] }}.
3. In Attach Source Label, keep Include Other Fields enabled and set RSS NAME to {{ $('Iterate Feed List').item.json["RSS NAME"] }}.
4. Open Filter Recent Items and ensure the condition compares leftValue {{ $json.pubDate }} to the expression {{ $('Configuration Set').item.json['Current Time'].toDateTime().minus($('Configuration Set').item.json['Last X Days'],'days').startOf('day') }}.
5. Confirm Iterate Feed Entries follows Filter Recent Items to batch individual articles.

Step 4: Set Up Content Retrieval and AI Summarization

Fetch article HTML, extract readable content, convert it to Markdown, and generate an AI summary.

1. In Lookup URL in Sheet, keep alwaysOutputData enabled so Verify Article Presence can detect duplicates.
2. Open Verify Article Presence and keep the condition {{ $item("0").$node["Lookup URL in Sheet"].json }} set to check if the lookup result is empty.
3. In Retrieve Page HTML, set URL to {{ $('Iterate Feed Entries').item.json.link }} and keep the response format as text.
4. In Extract Body Markup, keep operation set to extractHtmlContent and the selector body returning html.
5. In HTML to Markdown Transform, set HTML to {{ $json.data }} and keep ignore set to img,form.
6. Open Generate Summary and verify the Text prompt uses the expression with item fields like {{ $('Iterate Feed Entries').item.json.title }} and content {{ $json.data }}.
7. Open LLM Chat Provider and set Model to google/gemini-2.5-flash.
8. Credential Required: Connect your openRouterApi credentials in LLM Chat Provider.

Step 5: Configure Output Storage and Looping

Clean the AI output and append results to your article log, then loop to the next entry.

1. In Clean Summary Text, set text to {{ $json.text.replace(/<think>[\s\S]*?<\/think>/g, '') }} to remove model reasoning artifacts.
2. In Append Summary to Sheets, confirm column mappings: link, title, source, pubDate, ai summary, and categories from the expressions shown in the node.
3. Ensure the connection path Append Summary to Sheets → Iterate Feed Entries is intact to continue processing batches.
4. Confirm Iterate Feed Entries ends at Workflow Terminus when no more items remain.

Step 6: Test and Activate Your Workflow

Validate that items are filtered, summarized, and stored correctly before enabling the schedule.

1. Click Execute Workflow starting from Manual Execution Start to test the flow end-to-end.
2. Check that Lookup URL in Sheet prevents duplicates and that new rows appear in Append Summary to Sheets with ai summary populated.
3. Verify that Filter Recent Items only passes entries within the last 31 days.
4. When successful, activate the workflow and rely on Scheduled Automation Trigger for ongoing runs.