Build a Reddit RAG Archive in n8n: Apify, Sheets & Slack

Build a Reddit RAG Archive in n8n—weekly, with Apify, Google Sheets, and Slack

This n8n workflow automatically archives historical Reddit posts into a markdown “RAG pack,” appends the structured results to Google Sheets, and sends a weekly digest to Slack via an incoming webhook—so your retrieval-augmented generation (RAG) pipeline stays fed with up-to-date Reddit context.

What this workflow does

• Runs weekly on a schedule using the Schedule Trigger.
• Starts Apify’s reddit-archive-scraper actor via an n8n HTTP request, passing your subreddit(s) and search/query settings (including date window and max limits).
• Retrieves dataset items returned by the Apify actor.
• Filters and formats the results into:
  • a markdown “RAG pack”
  • a Slack-ready preview
  • a list of rows for Google Sheets
• Sends a summary message to Slack using a Slack incoming webhook.
• Splits prepared Google Sheets rows into individual items for reliable appending.
• Appends rows to Google Sheets, specifically into the configured spreadsheet and an “Archive” sheet.

Use cases

• Maintain a Reddit-based knowledge base for RAG, updated every week.
• Build a research archive for SaaS teams analyzing community feedback for specific topics.
• Create an auditable source-backed dataset in Google Sheets while monitoring progress via Slack.

Technical details

• Apify via HTTP request (supports Authorization: Bearer <APIFY_TOKEN> through an Apify HTTP Header Auth credential).
• Google Sheets integration using OAuth credentials to append “Archive” rows.
• Slack integration using an incoming webhook for weekly digests.
• n8n nodes used: code, split out, sticky note, http request, google sheets, schedule trigger.

Setup checklist

• Create and assign the Apify HTTP Header Auth credential.
• Connect Google Sheets OAuth and set the spreadsheet ID (and sheet name if needed).
• Configure a Slack incoming webhook URL and target channel.
• Update the Apify actor input: subreddits, searchQuery, date window, and max limits.