Quick overview
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 Runs every week on a schedule. Starts the Apify reddit-archive-scraper actor with your subreddit and query settings and retrieves the resulting dataset items. Filters and formats the returned Reddit posts into a markdown pack, a Slack-ready preview, and a list of rows for Google Sheets. Sends a summary message to Slack using an incoming webhook. Splits the prepared Google Sheets rows into individual items. Appends the rows to the specified Google Sheets spreadsheet and “Archive” sheet. Setup Create an Apify HTTP Header Auth credential that sends Authorization: Bearer and assign it to the Apify HTTP request step. Connect Google Sheets OAuth credentials and replace the Google Spreadsheet ID (and sheet name if needed) where the rows are appended. Create a Slack incoming webhook, replace the webhook URL in the Slack request, and set the target channel in Slack’s webhook configuration. 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). An n8n automation workflow template by benthepythondev.
benthepythondev
web
free
Others in the same category, ranked by how often they are opened.
