Step 2: Connect Reddit Data Retrieval

Pull targeted Reddit posts from the desired subreddit and keyword.

1. Add the Retrieve Reddit Posts node.
2. Set Operation to search and Keyword to looking for a solution.
3. Set Subreddit to =smallbusiness, Limit to 20, and Sort to hot.
4. Credential Required: Connect your redditOAuth2Api credentials.
5. Connect Retrieve Reddit Posts to Validate Post Metrics.

Step 3: Set Up Processing and AI Analysis

Filter posts by quality, map essential fields, and run AI checks and summarization with parallel branches.

1. In Validate Post Metrics, configure the conditions to match:
   Ups > 2 using {{ $json.ups }}, Selftext is not empty using {{ $json.selftext }}, and Created after the last 180 days using {{ DateTime.fromSeconds($json.created).toISO() }} compared to {{ $today.minus(180,'days').toISO() }}.
2. In Map Essential Fields, map the following fields with expressions: upvotes → {{ $json.ups }}, subreddit_subscribers → {{ $json.subreddit_subscribers }}, postcontent → {{ $json.selftext }}, url → {{ $json.url }}, and date → {{ DateTime.fromSeconds($json.created).toISO() }}.
3. Map Essential Fields outputs to both Combine Entry Streams and AI Content Assessment in parallel.
4. Configure AI Content Assessment with the provided prompt text and confirm it references {{ $json.postcontent }}. OpenAI credentials are added via OpenAI Chat Engine A — ensure OpenAI Chat Engine A has openAiApi connected.
5. Set Combine Entry Streams to Mode combine and Combine By combineByPosition, then connect it to Content Relevance Check.
6. In Content Relevance Check, validate that {{ $json.output }} equals yes.
7. Content Relevance Check outputs to Generate Post Summary, Propose Business Solutions, Merge Triple Outputs, and Analyze Sentiment in parallel.
8. Ensure Generate Post Summary uses OpenAI Chat Engine B as its language model with openAiApi credentials connected to OpenAI Chat Engine B.
9. Configure Propose Business Solutions to use model gpt-4o-mini and keep the message content referencing {{ $json.postcontent }}. Credential Required: Connect your openAiApi credentials.
10. Set Merge Triple Outputs to Mode combine, Combine By combineByPosition, and Number Inputs to 3.
11. In Analyze Sentiment, set Input Text to {{ $json.postcontent }}. Credentials are supplied via OpenAI Chat Engine C — ensure OpenAI Chat Engine C has openAiApi connected.

Step 4: Configure Output and Action Nodes

Append the analyzed content to Google Sheets and draft sentiment-based emails in Gmail.

1. Connect Merge Triple Outputs to Append Results to Sheet.
2. In Append Results to Sheet, set Operation to append, Document ID to [YOUR_ID], and Sheet Name to gid=0.
3. Map column values in Append Results to Sheet as follows: Upvotes → {{ $json.upvotes }}, Post_url → {{ $json.url }}, Post_date → {{ $json.date }}, Post_summary → {{ $json.response.text }}, Post_solution → {{ $json.message.content }}, Subreddit_size → {{ $json.subreddit_subscribers }}.
4. Credential Required: Connect your googleSheetsOAuth2Api credentials.
5. Analyze Sentiment outputs to Draft Positive Email, Draft Neutral Email, and Draft Negative Email in parallel.
6. In Draft Positive Email, set Resource to draft, Subject to Positive Post, and Message to {{ $json.postcontent }}. Credential Required: Connect your gmailOAuth2 credentials.
7. In Draft Neutral Email, set Resource to draft, Subject to Neutral Post, and Message to {{ $json.postcontent }}. Credential Required: Connect your gmailOAuth2 credentials.
8. In Draft Negative Email, set Resource to draft, Subject to Negative Post, and Message to {{ $json.postcontent }}. Credential Required: Connect your gmailOAuth2 credentials.

Step 5: Test and Activate Your Workflow

Run a manual test to verify data collection, AI outputs, and downstream actions before turning it on.

1. Click Execute Workflow to run Manual Execution Start and fetch live Reddit posts.
2. Confirm that posts pass Validate Post Metrics and that Map Essential Fields outputs the mapped fields.
3. Verify that Generate Post Summary and Propose Business Solutions produce outputs, and that Merge Triple Outputs combines three inputs before Append Results to Sheet.
4. Check your Google Sheet for new appended rows and your Gmail drafts for the three sentiment-based messages.
5. Once confirmed, toggle the workflow to Active so it’s ready for production runs.