Get Started
Back to Templates

Auto-Comment on Reddit Posts with AI Brand Mentions & Baserow Tracking

Created by

Created by: Arunava || arunava

Arunava

Last update

Last update 2 days ago

Categories

Share

This workflow finds fresh Reddit posts that match your keywords, decides if they’re actually relevant to your brand, writes a short human-style reply using AI, posts it, and logs everything to Baserow.

💡Perfect for

  • Lead gen without spam: drop helpful replies where your audience hangs out.

  • Get discovered by AI surfaces (AI Overviews / SGE, AISEO/GSEO) via high-quality brand mentions.

  • Customer support in the wild: answer troubleshooting threads fast.

  • Community presence: steady, non-salesy contributions in niche subreddits.

🧠 What it does

  • Searches Reddit for your keyword query on a schedule (e.g., every 30 min)

  • Checks Baserow first so you don’t reply twice to the same post

  • Uses an AI prompt tuned for short, no-fluff, subreddit-friendly comments

  • Softly mentions your brand only when it’s clearly relevant

  • Posts the comment via Reddit’s API

  • Saves post_id, comment_id, reply, permalink, status to Baserow

  • Processes posts one-by-one with an optional short wait to be nice to Reddit

⚡ Requirements

  • Reddit developer API

  • Baserow account, table, and API token

  • AI provider API (OpenAI / Anthropic / Gemini)

⚙️ Setup Instructions

  1. Create Baserow table
    Fields (user-field names exactly):
    post_id (unique), permalink, subreddit, title, created_utc, reply (long text), replied (boolean), created_on (datetime).

  2. Add credentials in n8n

  • Reddit OAuth2 (scopes: read, submit, identity) and set a proper User-Agent string (Reddit requires it).
  • LLM: Google Gemini and/or Anthropic (both can be added; one can be fallback in the AI Agent).
  • Baserow: API token.

  1. Set the Schedule Trigger (Cron)
    Start hourly (or every 2–3h). Pacing is mainly enforced by the Wait nodes.

  2. Update “Check duplicate row” (HTTP Request)

  • URL:
    https://api.baserow.io/api/database/rows/table/{TABLE_ID}/?user_field_names=true&filter__post_id__equal={{$json.post_id}}
  • Header: Authorization: Token YOUR_BASEROW_TOKEN
    (Use your own Baserow domain if self-hosted.)

  1. Configure “Filter Replied Posts”
    Ensure it skips items where your Baserow record shows replied === true (so you don’t comment twice).

  2. Configure “Fetch Posts from Reddit”
    Set your keyword/search query (and time/sort). Keep User-Agent header present.

  3. Configure “Write Reddit Comment (AI)”

  • Update your brand name (and optional link).
  • Edit the prompt/tone to your voice; ensure it outputs a short reply field (≤80 words, helpful, non-salesy).
  1. Configure “Post Reddit Comment” (HTTP Request)
  • Endpoint: POST https://oauth.reddit.com/api/comment
  • Body: thing_id: "t3_{{$json.post_id}}", text: "{{$json.reply}}"
  • Uses your Reddit OAuth credential and User-Agent header.
  • Update user_agent value in header by your username n8n:reddit-autoreply:1.0 (by /u/{reddit-username})
  1. Store Comment Data on Baserow (HTTP Request)
  • POST https://api.baserow.io/api/database/rows/table/{TABLE_ID}/?user_field_names=true
  • Header: Authorization: Token YOUR_BASEROW_TOKEN
  • Map: post_id, permalink, subreddit, title, created_utc, reply, replied, created_on={{$now}}.

  1. Keep default pacing
    Leave Wait 5m (cool-off) and Wait 6h (global pace) → ~4 comments/day. Reduce waits gradually as account health allows.

  2. Test & enable
    Run once manually, verify a Baserow row and one test comment, then enable the schedule.

🤝 Need a hand?

I’m happy to help you get this running smoothly—or tailor it to your brand.

Reach out to me via email: [email protected]