Reddit RAG Archive n8n Workflow: Apify + Google Sheets + Slack

Turn Reddit into a searchable RAG-ready archive—automatically

This n8n workflow runs a weekly Apify Reddit archive job (past the 1,000-post cap), flattens posts + comments into Google Sheets, and sends a Slack digest to support RAG pipelines.

What this workflow does

• Runs on a schedule using an n8n Schedule Trigger (every week).
• Calls the Apify API to execute the actor benthepythondev/reddit-archive-scraper with your configured subreddits, searchQuery, date window, and comment/max limits.
• Filters and formats results into:
  • per-post Markdown,
  • a Slack preview message,
  • and a list of structured rows for storage.
• Sends a Slack incoming-webhook summary (how many posts were collected + a preview of the first results).
• Splits the rows and appends each post as a new entry in a Google Sheets worksheet (expects a sheet named "Archive" with matching columns).

Use cases

• SaaS operators building internal knowledge bases from Reddit discussions.
• Automation engineers who need reliable weekly ingestion of posts/comments into a persistent datastore.
• RAG teams who want curated Reddit text stored as rows (Markdown + structured fields) for downstream retrieval.

Technical details

• Apify HTTP Request using an Apify HTTP Header Auth credential with: Authorization: Bearer <APIFY_TOKEN>.
• Google Sheets (OAuth): updates your target spreadsheet by appending to the "Archive" sheet.
• Slack incoming webhook: posts a digest/preview of the collected Reddit items.
• n8n nodes used: Schedule Trigger, HTTP Request, Code, Split In Batches (split list into items), Sticky Note, Google Sheets.

Actor reference: https://apify.com/benthepythondev/reddit-archive-scraper
Catalog: https://benthepythondev00.github.io/