{"product_id":"n8n-weekly-reddit-archive-to-rag-pack-apify-sheets-slack","title":"n8n Weekly Reddit Archive to RAG Pack (Apify, Sheets, Slack)","description":"\u003ch3\u003eAutomatically Archive Weekly Reddit Content into a RAG-Ready Pack (Apify → Sheets → Slack)\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow runs every week to pull historical Reddit posts and comments using \u003cstrong\u003eApify’s reddit-archive-scraper\u003c\/strong\u003e, transforms the results into a \u003cstrong\u003eRAG-ready pack\u003c\/strong\u003e (Markdown + structured fields), appends the data to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and posts a digest to \u003cstrong\u003eSlack\u003c\/strong\u003e via an incoming webhook.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns weekly on a schedule\u003c\/strong\u003e using an n8n Schedule Trigger.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalls the Apify API\u003c\/strong\u003e to execute the \u003cstrong\u003ebenthepythondev\/reddit-archive-scraper\u003c\/strong\u003e actor with your configured subreddit(s), search query, date window, maxPosts, and comment settings.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFormats the scraped output\u003c\/strong\u003e into RAG-ready Markdown entries and structured rows, including fields such as \u003cstrong\u003etitle\u003c\/strong\u003e, \u003cstrong\u003eselftext\u003c\/strong\u003e, \u003cstrong\u003epermalink\u003c\/strong\u003e, \u003cstrong\u003ecreated time\u003c\/strong\u003e, and \u003cstrong\u003ecomment counts\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends a Slack summary\u003c\/strong\u003e to an \u003cstrong\u003eincoming-webhook\u003c\/strong\u003e URL, including the total item count and a preview of the first few posts.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends rows to Google Sheets\u003c\/strong\u003e: it splits the prepared rows into individual items and writes them to the worksheet named \u003cstrong\u003eArchive\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBuild a Reddit knowledge base\u003c\/strong\u003e for retrieval-augmented generation (RAG) experiments—without manual exports.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eContinuously track community discussions\u003c\/strong\u003e (e.g., product feedback, troubleshooting threads) in a spreadsheet-backed archive.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOperational visibility for SaaS teams\u003c\/strong\u003e via a weekly Slack digest showing what was added.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes \/ components:\u003c\/strong\u003e schedule trigger, HTTP request, code, split out, and Google Sheets (plus a Slack incoming webhook post).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApify credential:\u003c\/strong\u003e create an Apify HTTP Header Auth credential using \u003ccode\u003eAuthorization: Bearer \u0026lt;APIFY_TOKEN\u0026gt;\u003c\/code\u003e for the HTTP request node.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets setup:\u003c\/strong\u003e add OAuth, set the spreadsheet ID, and ensure a sheet named \u003cstrong\u003eArchive\u003c\/strong\u003e with columns matching the appended fields.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSlack setup:\u003c\/strong\u003e configure your Slack \u003cem\u003eincoming webhook URL\u003c\/em\u003e to receive the digest message.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45824205324467,"sku":"N8N-18158","price":73.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/BXntoMMPWl-CDFqJtgecI_c34FekUq.png?v=1786612515","url":"https:\/\/buyflowscripts.com\/products\/n8n-weekly-reddit-archive-to-rag-pack-apify-sheets-slack","provider":"N8N Commerce","version":"1.0","type":"link"}