Analyze Reddit Posts with AI to Identify Business Opportunities

This n8n workflow leverages AI to analyze Reddit posts, identify potential business opportunities, and manage the findings. It automates the process of extracting relevant information from Reddit, performing sentiment analysis, summarizing content, and then categorizing and storing these insights, with an option to notify a user via email for review.

What it does

This workflow performs the following key steps:

1. Triggers Manually: The workflow is initiated manually.
2. Fetches Reddit Posts: It queries Reddit for posts based on specified criteria (e.g., keywords, subreddits).
3. Filters Posts: It applies conditional logic to filter Reddit posts, likely based on content or other metadata.
4. Analyzes Sentiment: For each filtered post, it performs sentiment analysis using an AI model to gauge the general tone (positive, negative, neutral).
5. Summarizes Content: It uses an AI summarization chain to create concise summaries of the Reddit posts.
6. Identifies Business Opportunities: An AI agent is employed to analyze the summarized posts and sentiment, identifying potential business opportunities.
7. Prepares Data: It structures the extracted and analyzed data (original post, sentiment, summary, identified opportunity) into a consistent format.
8. Stores Data: The processed data is then written to a Google Sheet for organized storage and further analysis.
9. Notifies via Email (Conditional): If certain criteria are met (e.g., a high-potential opportunity is identified), an email notification can be sent via Gmail for human review.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running instance of n8n.
• Reddit Account & Credentials: To access Reddit posts.
• OpenAI API Key: For the AI Agent, Summarization Chain, and Sentiment Analysis nodes.
• Google Sheets Account: To store the analyzed data.
• Gmail Account & Credentials: (Optional) If you wish to receive email notifications.

Setup/Usage

1. Import the workflow: Download the provided JSON and import it into your n8n instance.
2. Configure Credentials:
   • Set up your Reddit credentials.
   • Set up your OpenAI credentials for the AI nodes.
   • Set up your Google Sheets credentials.
   • (Optional) Set up your Gmail credentials if you want email notifications.
3. Customize Reddit Node: Adjust the "Reddit" node to specify the subreddits, keywords, or other criteria for the posts you want to analyze.
4. Configure If Node: Modify the "If" node's conditions to refine which Reddit posts proceed to AI analysis (e.g., filter by number of upvotes, specific keywords in the title/body).
5. Review AI Nodes:
   • Sentiment Analysis: Ensure the model and prompt are suitable for your needs.
   • Summarization Chain: Verify the summarization prompt.
   • AI Agent: Customize the agent's prompt to guide it in identifying specific types of business opportunities relevant to your domain.
6. Configure Edit Fields (Set) Node: Ensure the fields being set match the column headers in your Google Sheet.
7. Configure Google Sheets Node: Specify the Spreadsheet ID and Sheet Name where the data should be written.
8. Customize Gmail Node (Optional): If using, configure the recipient, subject, and body of the email notification based on the identified opportunities.
9. Activate the workflow: Once configured, activate the workflow. You can then execute it manually using the "Manual Trigger" node.