See llms.txt for all machine-readable content.

Back to Templates

Build a Reddit RAG archive with Apify, Google Sheets, and Slack

Created by

Created by: benthepythondev || benthepythondev
benthepythondev

Last update

Last update 2 days ago

Categories

Share

Quick overview

This workflow runs weekly, uses Apify’s reddit-archive-scraper actor to collect historical Reddit posts (and optional comments), formats them into a markdown “RAG pack,” appends the results to Google Sheets, and sends a Slack digest via an incoming webhook.

How it works

  1. Runs every week on a schedule.
  2. Starts the Apify reddit-archive-scraper actor with your subreddit and query settings and retrieves the resulting dataset items.
  3. Filters and formats the returned Reddit posts into a markdown pack, a Slack-ready preview, and a list of rows for Google Sheets.
  4. Sends a summary message to Slack using an incoming webhook.
  5. Splits the prepared Google Sheets rows into individual items.
  6. Appends the rows to the specified Google Sheets spreadsheet and “Archive” sheet.

Setup

  1. Create an Apify HTTP Header Auth credential that sends Authorization: Bearer <APIFY_TOKEN> and assign it to the Apify HTTP request step.
  2. Connect Google Sheets OAuth credentials and replace the Google Spreadsheet ID (and sheet name if needed) where the rows are appended.
  3. Create a Slack incoming webhook, replace the webhook URL in the Slack request, and set the target channel in Slack’s webhook configuration.
  4. Update the Apify actor input (subreddits, searchQuery, date window, and max limits) to match the archive you want to build.

Requirements

  • Apify account and API token; Google Sheets OAuth to a spreadsheet with an Archive tab; Slack incoming webhook.

Customization

  • Change subreddits, searchQuery, date window, and max limits on the Apify HTTP node. Point Google Sheets at a different spreadsheet or tab. Send the digest to another Slack channel by swapping the webhook.

Additional info

Actor Store page: https://apify.com/benthepythondev/reddit-archive-scraper. Output is a RAG markdown pack plus dump. Do not put the Apify token in the workflow JSON; use Header Auth (Authorization: Bearer).