✨ $500 AI Visibility Audit — live at Spurlock Studios. Book the audit

Marketing

CreepFactory👹😨 | Grab r/nosleep scary stories -> airtable

This n8n workflow automatically fetches rising scary stories from the r/nosleep subreddit every six hours. It extracts details like the story text, title, URL, upvote ratio, and total upvotes. Finally, it upserts this collected data into an Airtable base named "Creepy Factory"…

Built · ~6 hours saved per week

Creepy Story Content Aggregator Workflow Overview This workflow automates the process of sourcing fresh, popular content from Reddit's famous r/nosleep subreddit. Every six hours, it scours for "rising" scary stories, extracts key information like the title, the story itself, and engagement metrics, and then neatly organizes and saves this data into a dedicated Airtable base. This creates an automated content pipeline, perfect for feeding a YouTube channel, podcast, or blog that focuses on horror narration, eliminating the manual effort of finding and curating new material. Technologies Used - n8n: The automation platform coordinating the entire process. - Reddit: The source of the creative content (scary stories). - Airtable: The destination database used as a content management system (CMS) to store and manage the sourced stories. Node-by-Node Breakdown H3: Schedule Trigger - Purpose: This node is the workflow's ignition switch. - Function: It's configured to automatically start the workflow at a regular interval. In this case, it runs every 6 hours, ensuring a consistent and timely search for new content without any manual intervention. H3: Reddit - Purpose: This node acts as the content scout, fetching stories directly from Reddit. - Function: It is specifically configured to target the r/nosleep subreddit and retrieve the top 40 posts currently categorized as "rising". This is a strategic choice, as it targets stories that are rapidly gaining popularity but are not yet oversaturated, allowing the user to capitalize on fresh, viral-potential content. H3: Edit Fields - Purpose: This node cleans up and organizes the raw data pulled from Reddit. - Function: It takes the complex data structure from the Reddit node and simplifies it. It extracts only the essential pieces of information—title, selftext (the story), url, ups (upvotes), and upvote_ratio—and renames them into clear, usable fields. This step is crucial for ensuring the data is in a perfect format for the next step. H3: Airtable - Purpose: This node is the final destination, acting as a structured content library.

Tags: Marketing, Content Management, Timer, Research

Integrations: Schedule, Airtable

Related automations

Back to the Automation Library