Turn Reddit into a steady source of market insights. The flow finds posts that describe business problems, summarizes them, suggests helpful solutions, and stores everything in Google Sheets. It also prepares Gmail drafts based on sentiment so your team can follow up fast.

Here is how it works. Recent posts are pulled from chosen subreddits. Filters remove low value items using engagement and keyword checks. A set node keeps only fields you need like upvotes, URL, and date. An AI agent decides if the post is a real business need. Then three AI steps run in parallel to summarize the post, propose a solution idea, and label sentiment. Results are merged, added to Google Sheets, and routed to Gmail as positive, neutral, or negative drafts.

Setup is simple with Reddit, OpenAI, Google Sheets, and Gmail accounts. Point the Reddit node to your communities, map the Sheets columns, and connect Gmail to create drafts. Expect faster research cycles and clearer decisions. Great for market research teams, product managers, and sales teams who want to spot pain points and respond with helpful ideas.

• Reddit post collection from selected subreddits with engagement sorting.
• Feature based filters to keep posts with enough upvotes, comments, or recency.
• Content filters to include or exclude posts by keywords or phrases.
• AI agent checks if a post describes a real business problem.
• AI summarization turns long posts into quick executive notes.
• AI solution ideas suggest products or services that could help.
• AI sentiment analysis labels posts as positive, neutral, or negative.
• Gmail creates drafts for each sentiment so teams can reply faster.
• Google Sheets appends upvotes, URL, date, summary, and solution for tracking.

• Reduce manual research from 3 hours to 15 minutes per batch
• Streamline Reddit scanning and triage by about 80 percent
• Improve data quality by storing consistent fields in one sheet
• Connect Reddit, OpenAI, Gmail, and Google Sheets in one flow
• Handle 10 times more posts with automated filtering and routing
• Speed up outreach by creating sentiment based Gmail drafts

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with Reddit, OpenAI, Gmail and Google Sheets. See the Tools Required section above for links to create accounts with these services.
3. Connect Reddit: Double click the Get Posts node, open the Credential to connect with dropdown, click Create new credential, then follow the on screen steps to approve Reddit OAuth2.
4. Connect OpenAI: Open any OpenAI node such as OpenAI Chat Model, choose Create new credential, and paste your API key from the OpenAI API page. Select the model gpt 4o mini.
5. Connect Google Sheets: Open the Output The Results node, create a new Google Sheets credential, approve access, then pick your document and sheet.
6. Connect Gmail: Open each Gmail Draft node, create a new Gmail OAuth2 credential, approve access, and keep the resource set to draft.
7. Configure Reddit query: In Get Posts, select subreddits, sort order, and limit to control how many posts are fetched each run.
8. Tune filters: In Filter Posts By Features set thresholds for upvotes, comments, or post age. In Filter Posts By Content add include or exclude keywords.
9. Map fields: In Select Key Fields confirm upvotes, subreddit, url, date, and postcontent are set correctly for downstream steps.
10. Review AI prompts: In Analysis Content By AI, Post Summarization, and Find Proper Solutions adjust the instructions for your use case and brand tone.
11. Map Sheets columns: In Output The Results confirm the column mapping for Upvotes, Post_url, Post_date, Post_summary, and Post_solution. Run a quick test append.
12. Validate end to end: Click Execute Workflow. Check Google Sheets for new rows and Gmail for three draft folders based on sentiment. Adjust thresholds if the volume is too high or low.
13. Troubleshoot: If drafts are missing, confirm the sentiment values match positive, neutral, or negative. For auth errors, reauthorize OAuth2 credentials. For rate limits, lower the Reddit limit or add delays.