Quick Overview
This workflow captures an investor’s buy/sell action via an n8n Form, pulls related market news from NewsAPI, uses Google Gemini to generate a one-line behavioral reflection, sends it via Gmail and Slack, stores it in an n8n Data Table, and posts a weekly Slack summary using Groq.
How it works
- Receives an investment action submission (buy/sell, reason, and market name) through an n8n Form.
- Fetches recent related news from NewsAPI based on the selected market and aggregates article descriptions into a single summary.
- Stores the form submission in an n8n Data Table and merges it with the aggregated news summary.
- Uses Google Gemini (via an AI Agent) to generate a short, supportive behavioral insight and sends it through Gmail and to a Slack channel.
- Parses the AI output and updates the corresponding Data Table row with the generated instant feedback.
- Runs weekly on a schedule, pulls the last seven entries from the Data Table, and uses Groq to generate a concise behavioral pattern report that is posted to Slack.
Setup
- Create or select an n8n Data Table for storing submissions and feedback, and ensure it includes an instant_feedback column (and market_type if you want it stored).
- Add credentials for NewsAPI (HTTP Header auth), Google Gemini (PaLM API), Gmail OAuth2, Slack OAuth, and Groq.
- Update the NewsAPI query (q) mapping if you want different keywords than the selected market name.
- Set the target Slack channel and confirm the Gmail “send to” address (currently [email protected]) matches your needs.
- Publish the form and share the form URL with users, and confirm the weekly schedule timing matches your desired reporting cadence.