Airtable + Reddit: fresh prompts, no repeats
Posting “just one discussion prompt a day” sounds simple until you’re staring at your subreddit history, trying not to repeat yourself, and second-guessing every question you write.
Community managers usually feel this first. But marketers running engagement loops and founders building early traction run into it too. This Airtable Reddit automation gives you fresh prompts on a schedule, without accidentally recycling last week’s thread.
You’ll see how the workflow pulls past posts from Airtable, has AI draft a new discussion question, publishes it to Reddit, then archives it so it won’t repeat.
How This Automation Works
The full n8n workflow, from trigger to final output:
n8n Workflow Template: Airtable + Reddit: fresh prompts, no repeats
flowchart LR
subgraph sg0["Schedule Flow"]
direction LR
n0@{ icon: "mdi:play-circle", form: "rounded", label: "Schedule Trigger", pos: "b", h: 48 }
n1@{ icon: "mdi:brain", form: "rounded", label: "OpenAI Chat Model", pos: "b", h: 48 }
n2@{ icon: "mdi:cog", form: "rounded", label: "Aggregate", pos: "b", h: 48 }
n3@{ icon: "mdi:robot", form: "rounded", label: "Generate New Discussion", pos: "b", h: 48 }
n4["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/reddit.svg' width='40' height='40' /></div><br/>Post Discussion"]
n5["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/airtable.svg' width='40' height='40' /></div><br/>Create Archived Discussion"]
n6["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/airtable.svg' width='40' height='40' /></div><br/>Get Previous Discussions"]
n2 --> n3
n4 --> n5
n0 --> n6
n1 -.-> n3
n3 --> n4
n6 --> n2
end
%% Styling
classDef trigger fill:#e8f5e9,stroke:#388e3c,stroke-width:2px
classDef ai fill:#e3f2fd,stroke:#1976d2,stroke-width:2px
classDef aiModel fill:#e8eaf6,stroke:#3f51b5,stroke-width:2px
classDef decision fill:#fff8e1,stroke:#f9a825,stroke-width:2px
classDef database fill:#fce4ec,stroke:#c2185b,stroke-width:2px
classDef api fill:#fff3e0,stroke:#e65100,stroke-width:2px
classDef code fill:#f3e5f5,stroke:#7b1fa2,stroke-width:2px
classDef disabled stroke-dasharray: 5 5,opacity: 0.5
class n0 trigger
class n3 ai
class n1 aiModel
class n5,n6 database
classDef customIcon fill:none,stroke:none
class n4,n5,n6 customIcon
The Problem: Consistent Reddit prompts are hard to sustain
Reddit rewards consistency, but “be consistent” is a pretty cruel instruction when you also have a business to run. You post a solid prompt on Monday, get a great thread, and then Friday comes and you can’t remember what you already asked. So you scroll your own subreddit, skim titles, and try to invent something new while your schedule slips. Worse, repeated prompts frustrate regulars. They stop replying, mods get annoyed, and your community starts to feel stale even if you’re technically posting.
The friction compounds. Here’s where it breaks down most often.
- You end up reusing the same “safe” questions, which trains people to ignore your posts.
- It’s easy to miss a day, and getting back into rhythm takes more effort than it should.
- Manual tracking in notes or spreadsheets falls apart once multiple people help with community.
- Even good AI prompts can repeat themes if you don’t feed it your posting history.
The Solution: Airtable-backed prompt generation and scheduled posting
This workflow turns your “what should we post today?” problem into a simple system: a schedule, a memory, and an autopublisher. n8n runs on the cadence you choose (daily, weekdays, twice a week, whatever). When it triggers, it pulls your previously posted discussion questions from Airtable, compacts them into a clean list, and uses that context to guide an AI model to write something new. Then it posts the question to your chosen subreddit as a text, image, or link post. Finally, it saves the newly posted prompt back into Airtable so the next run has one more item to avoid.
The workflow starts with a timed trigger and a “retrieve history” query from Airtable. AI drafts one new prompt using that history as guardrails, and Reddit publishes it. Airtable then archives the posted thread so your library stays current.
What You Get: Automation vs. Results
| What This Workflow Automates | Results You’ll Get |
|---|---|
|
|
Example: What This Looks Like
Say you run one subreddit and you want 5 discussion posts a week. Manually, you might spend about 15 minutes digging for past topics and another 10 minutes polishing the wording, so roughly 2 hours weekly. With this workflow, you set it up once (about 5 minutes), then each post is basically: scheduled trigger, a minute to fetch Airtable history, and a short wait while AI drafts and Reddit publishes. You go from “constant context switching” to a quick review-and-let-it-run routine.
What You’ll Need
- n8n instance (try n8n Cloud free)
- Self-hosting option if you prefer (Hostinger works well)
- Airtable to store prior prompts and archives.
- Reddit to publish scheduled discussion posts.
- OpenAI API key (get it from the OpenAI API dashboard).
Skill level: Beginner. You’ll connect accounts, paste a few IDs, and adjust a prompt.
Don’t want to set this up yourself? Talk to an automation expert (free 15-minute consultation).
How It Works
A timed schedule kicks things off. The workflow starts with a Schedule Trigger node, so you decide when prompts go live. Daily is common, but “weekdays only” is usually healthier for moderation.
Your posting history gets pulled from Airtable. n8n searches your base for previously posted questions (your “do not repeat” list), then aggregates them into a single bundle the AI can actually understand.
AI drafts a brand-new discussion prompt. A ChatGPT-style model generates one question based on your system prompt and the archive of past prompts, so it nudges away from duplicates and tired angles.
Reddit publishes, then Airtable stores the new one. The Reddit node posts to your chosen subreddit (text, image, or link), and the Airtable “archive” node writes the new prompt back into your database so tomorrow’s run is smarter.
You can easily modify the system prompt to match your niche and tone based on your needs. See the full implementation guide below for customization options.
Step-by-Step Implementation Guide
Step 1: Configure the Schedule Trigger
Set the workflow to run automatically on a daily schedule.
- Add the Timed Automation Trigger node as the workflow trigger.
- Open Timed Automation Trigger and set the schedule rule to run at hour
19(as configured in the node). - Keep the trigger connected to Retrieve Prior Threads to maintain the execution flow.
Step 2: Connect Airtable and Retrieve Prior Threads
Pull previously used questions to avoid duplicates in new prompts.
- Open Retrieve Prior Threads and set Operation to
search. - Set Base to
[YOUR_ID](cached name:[TEMPLATE] Reddit Discussion). - Set Table to
[YOUR_ID](cached name:Content). - Set View to
[YOUR_ID](cached name:r/Example). - Credential Required: Connect your airtableTokenApi credentials.
- Connect Retrieve Prior Threads to Combine Prior Text.
Step 3: Aggregate Past Questions and Generate a New Prompt
Combine past content and create a new open-ended Reddit question with the AI chain.
- In Combine Prior Text, set Fields to Aggregate to include
Copy. - Open Draft New Prompt and set Prompt Type to
define. - Set Text in Draft New Prompt to
=Generate a short open-ended question of the [WEEK/DAY] about [INSERT TOPIC HERE] for the r/[SUBREDDIT NAME HERE] subreddit. ONLY provide the short open-ended question and nothing else in your output. Make sure it isn't any of the following previously used below. {{ $json.Copy }}. - Ensure OpenAI Chat Engine is connected as the language model for Draft New Prompt.
- Credential Required: Connect your openAiApi credentials in OpenAI Chat Engine (credentials are added to the parent AI model node, not the chain node).
Copy field and that the prompt includes {{ $json.Copy }} exactly.Step 4: Publish to Reddit and Archive the Post
Post the generated question and log it back to Airtable for future reference.
- Open Publish to Reddit and set Text to
={{ $json.text }}. - Set Title to
={{ $json.text }}. - Set Subreddit to
Biohackers. - Credential Required: Connect your redditOAuth2Api credentials.
- Open Archive Posted Thread and set Operation to
create. - Map Question to
={{ $('Draft New Prompt').item.json.text }}. - Set Subreddit to
r/Exampleand Published Date to={{ $now }}. - Credential Required: Connect your airtableTokenApi credentials.
Step 5: Test and Activate Your Workflow
Verify the full flow before enabling the schedule for production use.
- Click Execute Workflow to run a manual test from Timed Automation Trigger.
- Confirm that Retrieve Prior Threads returns records and Combine Prior Text aggregates the
Copyfield. - Verify that Draft New Prompt outputs a single short question and Publish to Reddit posts it to
Biohackers. - Check Airtable to ensure Archive Posted Thread creates a record with the correct Question and Published Date.
- Toggle the workflow Active to enable the 19:00 scheduled run.
Common Gotchas
- Airtable credentials can expire or need specific permissions. If things break, check your Airtable personal access token scopes and the base/table access first.
- If you’re using Wait nodes or external rendering, processing times vary. Bump up the wait duration if downstream nodes fail on empty responses.
- Default prompts in AI nodes are generic. Add your brand voice early or you’ll be editing outputs forever.
Frequently Asked Questions
About 5 minutes if your Airtable, Reddit, and OpenAI accounts are ready.
No. You’ll mostly connect accounts and map a few Airtable fields. The “hard” part is writing a good system prompt, honestly.
Yes. n8n has a free self-hosted option and a free trial on n8n Cloud. Cloud plans start at $20/month for higher volume. You’ll also need to factor in OpenAI API costs (usually a few cents per post, depending on your prompt length).
Two options: n8n Cloud (managed, easiest setup) or self-hosting on a VPS. For self-hosting, Hostinger VPS is affordable and handles n8n well. Self-hosting gives you unlimited executions but requires basic server management.
Yes, but you’ll want to adjust it in two places: the “Generate New Discussion” prompt (so the AI writes for a text post vs. a link post) and the “Publish to Reddit” node (where you select text, image, or link). Common tweaks include adding banned topics to the system prompt, switching subreddits by Airtable field, and adding a manual approval step before posting.
Usually it’s an expired personal access token or missing scopes for the base you’re querying. Update the token in n8n, then double-check the “Retrieve Prior Threads” and “Archive Posted Thread” nodes are pointing at the right base, table, and view. If the workflow suddenly finds “zero records,” it’s often a view filter issue rather than an API outage.
A lot.
For scheduled Reddit posting with “memory” (avoiding duplicates), n8n is usually the better fit because it’s comfortable with multi-step logic, aggregating history, and more detailed control without inflating task costs. Zapier and Make can do it, but you’ll often end up paying for lots of little operations: search records, format data, call AI, post, then write back. n8n also gives you the option to self-host, which matters when you want this running quietly for months. If you only need a simple 2-step “new row → post” automation, Zapier or Make may feel faster. Talk to an automation expert if you want help choosing.
Once this is running, your subreddit gets steady discussion without you babysitting the calendar. Set it up, let it post, and keep your energy for the threads that matter.
Need Help Setting This Up?
Our automation experts can build and customize this workflow for your specific needs. Free 15-minute consultation—no commitment required.
