{"product_id":"reddit-rag-archive-n8n-workflow-apify-google-sheets-slack","title":"Reddit RAG Archive n8n Workflow: Apify + Google Sheets + Slack","description":"\u003ch3\u003eTurn Reddit into a searchable RAG-ready archive—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow runs a weekly \u003cstrong\u003eApify Reddit archive\u003c\/strong\u003e job (past the 1,000-post cap), flattens \u003cstrong\u003eposts + comments\u003c\/strong\u003e into \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and sends a \u003cstrong\u003eSlack digest\u003c\/strong\u003e to support \u003cstrong\u003eRAG\u003c\/strong\u003e pipelines.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on a schedule\u003c\/strong\u003e using an n8n Schedule Trigger (every week).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCalls the Apify API\u003c\/strong\u003e to execute the actor \u003cem\u003ebenthepythondev\/reddit-archive-scraper\u003c\/em\u003e with your configured subreddits, searchQuery, date window, and comment\/max limits.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFilters and formats results\u003c\/strong\u003e into:\n    \u003cul\u003e\n      \u003cli\u003eper-post \u003cstrong\u003eMarkdown\u003c\/strong\u003e,\u003c\/li\u003e\n      \u003cli\u003ea \u003cstrong\u003eSlack preview\u003c\/strong\u003e message,\u003c\/li\u003e\n      \u003cli\u003eand a list of \u003cstrong\u003estructured rows\u003c\/strong\u003e for storage.\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends a Slack incoming-webhook\u003c\/strong\u003e summary (how many posts were collected + a preview of the first results).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSplits the rows\u003c\/strong\u003e and \u003cstrong\u003eappends each post\u003c\/strong\u003e as a new entry in a Google Sheets worksheet (expects a sheet named \u003cstrong\u003e\"Archive\"\u003c\/strong\u003e with matching columns).\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSaaS operators\u003c\/strong\u003e building internal knowledge bases from Reddit discussions.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAutomation engineers\u003c\/strong\u003e who need reliable weekly ingestion of posts\/comments into a persistent datastore.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRAG teams\u003c\/strong\u003e who want curated Reddit text stored as rows (Markdown + structured fields) for downstream retrieval.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eApify HTTP Request\u003c\/strong\u003e using an Apify HTTP Header Auth credential with: \u003ccode\u003eAuthorization: Bearer \u0026lt;APIFY_TOKEN\u0026gt;\u003c\/code\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets (OAuth)\u003c\/strong\u003e: updates your target spreadsheet by appending to the \u003cstrong\u003e\"Archive\"\u003c\/strong\u003e sheet.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSlack incoming webhook\u003c\/strong\u003e: posts a digest\/preview of the collected Reddit items.\u003c\/li\u003e\n  \u003cli\u003en8n nodes used: \u003cstrong\u003eSchedule Trigger\u003c\/strong\u003e, \u003cstrong\u003eHTTP Request\u003c\/strong\u003e, \u003cstrong\u003eCode\u003c\/strong\u003e, \u003cstrong\u003eSplit In Batches\u003c\/strong\u003e (split list into items), \u003cstrong\u003eSticky Note\u003c\/strong\u003e, \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003e\u003cstrong\u003eActor reference:\u003c\/strong\u003e https:\/\/apify.com\/benthepythondev\/reddit-archive-scraper\u003cbr\u003e\n\u003cstrong\u003eCatalog:\u003c\/strong\u003e https:\/\/benthepythondev00.github.io\/\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45824205455539,"sku":"N8N-18157","price":57.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/nlS2GyGjPEKIv_4Ao-gcj_3WheDB9V.png?v=1786612543","url":"https:\/\/buyflowscripts.com\/products\/reddit-rag-archive-n8n-workflow-apify-google-sheets-slack","provider":"N8N Commerce","version":"1.0","type":"link"}