This workflow monitors targeted subreddits for potential sales leads using Reddit’s API, AI content analysis, Supabase, and Google Sheets.
It is built specifically to discover posts from Reddit users who may benefit from a particular product or service. It can be easily customized for any market.
Targeted Subreddit Monitoring:
Searches multiple niche subreddits like smallbusiness
, startup
, sweatystartup
, etc., using relevant keywords.
AI-Powered Relevance Scoring:
Uses OpenAI GPT to analyze each post and determine if it’s written by someone who might benefit from your product, returning a simple “yes” or “no.”
Duplicate Lead Filtering with Supabase:
Ensures you don’t email the same lead more than once by storing already-processed Reddit post IDs in a Supabase table.
Content Filtering:
Filters out posts with no body text or no upvotes to ensure only high-quality content is processed.
Lead Storage in Google Sheets:
Saves qualified leads into a connected Google Sheet with key data (URL, post content, subreddit, and timestamp).
Email Digest Alerts:
Compiles relevant leads and sends a daily digest of matched posts to your team’s inbox for review or outreach.
Manual or Scheduled Trigger:
Can be manually triggered or automatically scheduled (via the built-in Schedule Trigger node).
Code
node to match your market.type=link
to type=comment
in the Reddit Search node.