Step 2: Connect Reddit Data Sources

Configure three subreddit searches that run simultaneously to capture relevant posts.

1. Open Fetch Startup Threads and set Operation to search, Subreddit to startups, Keyword to Scaling Leads, Limit to 2, and Sort to new.
2. Open Retrieve Marketing Posts and set Operation to search, Subreddit to marketing, Keyword to Lead Generation, Limit to 2, and Sort to new.
3. Open Collect Smallbiz Topics and set Operation to search, Subreddit to smallbusiness, Keyword to Business Automation, Limit to 2, and Sort to new.
4. Credential Required: Connect your redditOAuth2Api credentials to Fetch Startup Threads, Retrieve Marketing Posts, and Collect Smallbiz Topics.

Step 3: Merge and Normalize Post Fields

Combine the three post streams and map only the required fields before sending to the AI agent.

1. In Combine Post Streams, set Number Inputs to 3 to merge all three Reddit branches.
2. Connect Fetch Startup Threads, Retrieve Marketing Posts, and Collect Smallbiz Topics into Combine Post Streams.
3. Open Map Post Fields and create these assignments: subreddit = {{ $json.subreddit }}, text = {{ $json.selftext }}, title = {{ $json.title }}.

Step 4: Set Up the AI Extraction Pipeline

Use the agent and output parser to produce structured insights for each post.

1. Open Insight Extraction Agent and set Text to =Subreddit: {{ $json.subreddit }} Text: {{ $json.text }} Title: {{ $json.title }}.
2. Ensure Prompt Type is define and Has Output Parser is enabled in Insight Extraction Agent.
3. In OpenAI Chat Engine, select the model gpt-4.1-mini.
4. Credential Required: Connect your openAiApi credentials to OpenAI Chat Engine.
5. Open Structured JSON Parser and keep Auto Fix enabled with the provided JSON schema example.

Step 5: Configure Google Sheets Output

Append AI-generated insights into your Google Sheet.

1. Open Append Insights to Sheet and set Operation to append.
2. Set Document ID to [YOUR_ID] and Sheet Name to gid=0 (Sheet1).
3. Map columns to output fields: Summary = {{ $json.output.summary }}, Pain Point = {{ $json.output.pain_point }}, Content Angle = {{ $json.output.content_angle }}.
4. Credential Required: Connect your googleSheetsOAuth2Api credentials to Append Insights to Sheet.

Step 6: Test and Activate Your Workflow

Run a manual test to verify posts are collected, insights are generated, and rows are appended to your sheet.

1. Click Execute Workflow and watch Scheduled Run Starter trigger the three Reddit nodes in parallel.
2. Confirm Combine Post Streams outputs a unified list and Map Post Fields shows subreddit, text, and title.
3. Verify Insight Extraction Agent returns a JSON object with summary, pain_point, and content_angle.
4. Check your Google Sheet to confirm new rows were appended by Append Insights to Sheet.
5. Toggle the workflow to Active to enable daily scheduled runs.