Score Reddit buying-intent leads with Apify, OpenAI, Google Sheets and Slack

## Score Reddit buying-intent leads with AI and draft replies For founders, agencies and sales teams who sell to people that ask Reddit for help. Every morning this workflow finds buying-intent Reddit posts and comments, scores each from 0 to 100 with OpenAI and logs it to Google Sheets. For each hot lead it reads the author's Reddit history, drafts a reply and sends both to Slack. Every Monday it posts a weekly summary. Reddit data comes from the Reddit Scraper Actor on Apify, so you need no Reddit API key or OAuth app approval. ### How it works 1. Every morning (08:00) and Every Monday (09:00) start a run. Settings holds your product, phrases and limits. Weekly summary run? picks the path. 2. Search Reddit posts and comments finds matches from the last day across Reddit (or one subreddit). 3. One shape for posts and comments and Skip leads already scored clean up and drop items seen in earlier runs. 4. Score buying intent asks OpenAI for a 0-100 score, the need, and a reply angle. Log to Google Sheets keeps every scored item. 5. Hot leads only keeps items at or above minScore. Read author history gets the profile, recent posts and recent comments of every hot-lead author in one Apify run. 6. Draft reply reads that history and writes a short, helpful reply plus one line on who the author is. Alert Slack sends the lead, the line and the draft. 7. On Mondays, Read leads sheet and Last 7 days count the week's leads. Summarize the week finds the main needs, and Post weekly summary sends them with the best leads to Slack. ### Setup 1. Add the Apify node (@apify/n8n-nodes-apify, a verified node) if your n8n does not have it yet. 2. Create an Apify API credential with the token from Apify Console → API & Integrations. No account yet? Sign up free; the free plan includes monthly credit. 3. Add an OpenAI credential and select it in the three OpenAI model nodes. 4. Create a Google Sheet with a Leads tab and the columns scoredAt, score, kind, subreddit, title, need, replyAngle, author, url, text. Connect Google Sheets and pick the file in Log to Google Sheets and Read leads sheet. 5. Connect Slack and pick a channel in Alert Slack and Post weekly summary. 6. In Settings, describe your product and edit phrases (quotes mean exact match). ### Customization tips - Raise minScore to get fewer, warmer Slack alerts and fewer author-history lookups. -