n8n Weekly Reddit Archive to RAG Pack (Apify, Sheets, Slack)

Automatically Archive Weekly Reddit Content into a RAG-Ready Pack (Apify → Sheets → Slack)

This n8n workflow runs every week to pull historical Reddit posts and comments using Apify’s reddit-archive-scraper, transforms the results into a RAG-ready pack (Markdown + structured fields), appends the data to Google Sheets, and posts a digest to Slack via an incoming webhook.

What this workflow does

• Runs weekly on a schedule using an n8n Schedule Trigger.
• Calls the Apify API to execute the benthepythondev/reddit-archive-scraper actor with your configured subreddit(s), search query, date window, maxPosts, and comment settings.
• Formats the scraped output into RAG-ready Markdown entries and structured rows, including fields such as title, selftext, permalink, created time, and comment counts.
• Sends a Slack summary to an incoming-webhook URL, including the total item count and a preview of the first few posts.
• Appends rows to Google Sheets: it splits the prepared rows into individual items and writes them to the worksheet named Archive.

Use cases

• Build a Reddit knowledge base for retrieval-augmented generation (RAG) experiments—without manual exports.
• Continuously track community discussions (e.g., product feedback, troubleshooting threads) in a spreadsheet-backed archive.
• Operational visibility for SaaS teams via a weekly Slack digest showing what was added.

Technical details

• Nodes / components: schedule trigger, HTTP request, code, split out, and Google Sheets (plus a Slack incoming webhook post).
• Apify credential: create an Apify HTTP Header Auth credential using Authorization: Bearer <APIFY_TOKEN> for the HTTP request node.
• Google Sheets setup: add OAuth, set the spreadsheet ID, and ensure a sheet named Archive with columns matching the appended fields.
• Slack setup: configure your Slack incoming webhook URL to receive the digest message.