{"product_id":"build-a-reddit-rag-archive-in-n8n-apify-sheets-slack","title":"Build a Reddit RAG Archive in n8n: Apify, Sheets \u0026 Slack","description":"\u003ch3\u003eBuild a Reddit RAG Archive in n8n—weekly, with Apify, Google Sheets, and Slack\u003c\/h3\u003e\n\u003cp\u003eThis 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.\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 the Schedule Trigger.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eStarts Apify’s \u003cem\u003ereddit-archive-scraper\u003c\/em\u003e actor\u003c\/strong\u003e via an n8n HTTP request, passing your subreddit(s) and search\/query settings (including date window and max limits).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRetrieves dataset items\u003c\/strong\u003e returned by the Apify actor.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilters and formats the results\u003c\/strong\u003e into:\n    \u003cul\u003e\n      \u003cli\u003ea markdown “RAG pack”\u003c\/li\u003e\n      \u003cli\u003ea Slack-ready preview\u003c\/li\u003e\n      \u003cli\u003ea list of rows for Google Sheets\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends a summary message to Slack\u003c\/strong\u003e using a Slack incoming webhook.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSplits prepared Google Sheets rows\u003c\/strong\u003e into individual items for reliable appending.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAppends rows to Google Sheets\u003c\/strong\u003e, specifically into the configured spreadsheet and an “Archive” sheet.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eMaintain a \u003cstrong\u003eReddit-based knowledge base\u003c\/strong\u003e for RAG, updated every week.\u003c\/li\u003e\n  \u003cli\u003eBuild a \u003cstrong\u003eresearch archive\u003c\/strong\u003e for SaaS teams analyzing community feedback for specific topics.\u003c\/li\u003e\n  \u003cli\u003eCreate an auditable \u003cstrong\u003esource-backed dataset\u003c\/strong\u003e in Google Sheets while monitoring progress via Slack.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApify\u003c\/strong\u003e via HTTP request (supports \u003ccode\u003eAuthorization: Bearer \u0026lt;APIFY_TOKEN\u0026gt;\u003c\/code\u003e through an Apify HTTP Header Auth credential).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e integration using OAuth credentials to append “Archive” rows.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSlack\u003c\/strong\u003e integration using an incoming webhook for weekly digests.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes used\u003c\/strong\u003e: code, split out, sticky note, http request, google sheets, schedule trigger.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eSetup checklist\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eCreate and assign the \u003cstrong\u003eApify HTTP Header Auth\u003c\/strong\u003e credential.\u003c\/li\u003e\n  \u003cli\u003eConnect \u003cstrong\u003eGoogle Sheets OAuth\u003c\/strong\u003e and set the spreadsheet ID (and sheet name if needed).\u003c\/li\u003e\n  \u003cli\u003eConfigure a \u003cstrong\u003eSlack incoming webhook\u003c\/strong\u003e URL and target channel.\u003c\/li\u003e\n  \u003cli\u003eUpdate the Apify actor input: \u003cstrong\u003esubreddits\u003c\/strong\u003e, \u003cstrong\u003esearchQuery\u003c\/strong\u003e, date window, and max limits.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45824205258931,"sku":"N8N-18159","price":75.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/TGvvgc83C83ZbvAH3_4xv_3GILY0Vy.png?v=1786612491","url":"https:\/\/buyflowscripts.com\/products\/build-a-reddit-rag-archive-in-n8n-apify-sheets-slack","provider":"N8N Commerce","version":"1.0","type":"link"}