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

Workflow overview

Why this workflow matters

Relevant for managed services and support workflows.

Quick Overview This workflow captures an investor’s buy/sell action via an AlekSystem 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 AlekSystem 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 AlekSystem 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 AlekSystem 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 AlekSystem 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 errorcommits@mailinator.com) matches your needs. Publish the form and share the form URL with users, and confirm the weekly schedule timing matches your desired reporting cadence.

Best fit

Need another direction?