Track investor behavior with NewsAPI, Gemini, Groq and Slack alerts

Description

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.