Skip to main content

Generate institutional-grade stock price targets and BUY/HOLD/SELL signals with GPT-5, Gemini, Alpha Vantage and Google Sheets

Workflow preview

Workflow preview
100%
Generate institutional-grade stock price targets and BUY/HOLD/SELL signals with GPT-5, Gemini, Alpha Vantage and Google Sheets preview
Open on n8n.io

1. Workflow Overview

A professional AI equity analysis automation built on n8n that transforms structured financial data and real time news into disciplined, risk adjusted price targets and actionable BUY/HOLD/SELL sig...

Best for

  • Crypto Trading automation workflows
  • AI Summarization automation workflows
  • advanced n8n builders looking for reusable templates

Tools used

n8n-nodes-base.splitinbatches, n8n-nodes-base.googlesheets, n8n-nodes-base.scheduletrigger, n8n-nodes-base.stickynote, n8n-nodes-base.code, n8n-nodes-base.merge, @n8n/n8n-nodes-langchain.openai, n8n-nodes-base.xml

Source and attribution

This workflow is cataloged by N8N Workflows and links back to its original n8n.io source page by Mo AlBarrak.

Original n8n.io source

1.1 Workflow description

Title
Generate institutional-grade stock price targets and BUY/HOLD/SELL signals with GPT-5, Gemini, Alpha Vantage and Google Sheets
Workflow name
Generate institutional-grade stock price targets and BUY/HOLD/SELL signals with GPT-5, Gemini, Alpha Vantage and Google Sheets

A professional AI equity analysis automation built on n8n that transforms structured financial data and real-time news into disciplined, risk-adjusted price targets and actionable BUY/HOLD/SELL signals โ€” delivered through automation channels like Telegram or dashboards.

Key Features

Automated Fundamental & News Parsing: Ingests financial metrics and analyst-grade news streams into a unified valuation engine.

Phase-Aware Valuation Logic: Recognizes growth vs mature companies, applying appropriate valuation methods (EPS, revenue multiples, fundamentals) to avoid unrealistic targets.

Implied P/E Sanity Gate: Prevents misleading EPS-based valuations on growth/transition phase stocks.

Bear/Base/Bull Scenario Generation: Produces three price targets with institutional-standard bands and logic.

Risk & Confidence Scoring: Combines F-Score with qualitative risk extraction from news to produce a confidence index (20โ€“90).

Structured JSON Output: Designed for automation, feeds dashboards, alerts, APIs, or downstream analytics.

Cross-Model Verification (optional): Works with multi-model LLM consensus (e.g., GPT + Gemini) for enhanced reliability.

Ideal For

Asset managers & analysts who want automated equity valuations

Retail platforms seeking a disciplined valuation engine

Fintech products integrating AI-powered stock insights

Educators and research teams needing structured valuation tools

โš™๏ธ Technical Notes (Best Practice for Production)

Rate-Limit & Timers for Long Lists If processing a long watchlist via HTTP requests (e.g., financial APIs, news APIs), you should add timers (Wait nodes) or rate-limit controls before each HTTP request to:

Respect API quotas & avoid throttling

Reduce workflow errors under heavy loads

Improve reliability for automated batch runs

This is especially important when using workflows that fetch quotes, historical data, or news articles for multiple stocks in sequence.

๐Ÿ“Œ Use Cases ๐Ÿ”น Daily Watchlist Runner

Run nightly analysis on a portfolio and distribute targets + risk insights via Telegram or email.

๐Ÿ”น API Feed

Expose JSON results via webhook/API for downstream apps and dashboards.

๐Ÿ”น Research & Alerts

Trigger alerts when confidence shifts, price targets are breached, or news alters thesis.

๐Ÿง  Why This Is Valuable

Unlike simple โ€œchatโ€ bots that give generic responses, this workflow encodes institutional valuation discipline โ€” no hallucinated price points, no fuzzy narratives โ€” just structured, defensible outputs.

This makes it compelling to:

Professional users

Startup investors

SaaS subscription customers

Fintech integrators

1.2 Logical Blocks

This catalog entry is organized from the workflow JSON. The node-level section below shows the executable blocks available for review before importing the template.

2. Block-by-Block Analysis

Block 1 - loop_over_tickers

Type / Role
n8n-nodes-base.splitInBatches - splitInBatches
Config choices
Version 3

Block 2 - Read_tickers_from_Sheet

Type / Role
n8n-nodes-base.googleSheets - googleSheets
Config choices
Version 4.6

Block 3 - write_sentiment_to_sheets

Type / Role
n8n-nodes-base.googleSheets - googleSheets
Config choices
Version 4.6

Block 4 - Schedule Trigger

Type / Role
n8n-nodes-base.scheduleTrigger - scheduleTrigger
Config choices
Version 1.2

Block 5 - Sticky Note

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 6 - Sticky Note1

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 7 - Sticky Note2

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 8 - Sticky Note3

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 9 - Sticky Note4

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 10 - Sticky Note5

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 11 - Code in JavaScript

Type / Role
n8n-nodes-base.code - code
Config choices
Version 2

Block 12 - Merge

Type / Role
n8n-nodes-base.merge - merge
Config choices
Version 3.2

Block 13 - Message a model

Type / Role
@n8n/n8n-nodes-langchain.openAi - openAi
Config choices
Version 2.1

Block 14 - XML

Type / Role
n8n-nodes-base.xml - xml
Config choices
Version 1

Block 15 - Merge1

Type / Role
n8n-nodes-base.merge - merge
Config choices
Version 3.2

Block 16 - If

Type / Role
n8n-nodes-base.if - if
Config choices
Version 2.3

Block 17 - If1

Type / Role
n8n-nodes-base.if - if
Config choices
Version 2.3

Block 18 - Edit Fields2

Type / Role
n8n-nodes-base.set - set
Config choices
Version 3.4

Block 19 - Merge2

Type / Role
n8n-nodes-base.merge - merge
Config choices
Version 3.2

Block 20 - Is Cache Valid?

Type / Role
n8n-nodes-base.if - if
Config choices
Version 2.3

Block 21 - Cache Lookup

Type / Role
n8n-nodes-base.googleSheets - googleSheets
Config choices
Version 4.7

Block 22 - alphavantage - Balance Sheet

Type / Role
n8n-nodes-base.httpRequest - httpRequest
Config choices
Version 4.4

Block 23 - alphavantage - Profile

Type / Role
n8n-nodes-base.httpRequest - httpRequest
Config choices
Version 4.4

Block 24 - alphavantage - Income Statement

Type / Role
n8n-nodes-base.httpRequest - httpRequest
Config choices
Version 4.4

Showing the first 24 of 51 workflow blocks. Download the JSON for the full node graph.

3. Summary Table

Workflow Generate institutional-grade stock price targets and BUY/HOLD/SELL signals with GPT-5, Gemini, Alpha Vantage and Google Sheets
Complexity advanced
Nodes 51
Categories Crypto Trading, AI Summarization
Author Mo AlBarrak
Published 25 Feb 2026

4. Reproducing the Workflow from Scratch

  1. 1. Download the workflow JSON

    Use the JSON export at /data/workflows/13701/13701.json as the source template for this automation.

  2. 2. Import the template into n8n

    Open n8n, import the downloaded JSON, and review each node before activating the workflow.

  3. 3. Configure credentials and variables

    Replace placeholder credentials, API keys, webhook URLs, account IDs, and environment-specific values with your own settings.

  4. 4. Test with sample data

    Run the workflow manually or in a staging workspace, inspect node output, and confirm downstream systems receive the expected data.

  5. 5. Activate and monitor

    Enable the workflow only after testing, then monitor executions, errors, and rate limits during the first production runs.

5. General Notes & Resources

Review imported nodes carefully before activation. This catalog entry is intended to help you inspect the workflow structure, understand required services, and find related templates faster.

Node names, credentials, schedules, webhook paths, and external service limits may need adjustment for your workspace.

Frequently asked questions

What does Generate institutional-grade stock price targets and BUY/HOLD/SELL signals with GPT-5, Gemini, Alpha Vantage and Google Sheets do?

A professional AI equity analysis automation built on n8n that transforms structured financial data and real time news into disciplined, risk adjusted price targets and actionable BUY/HOLD/SELL sig...

What do I need before importing this workflow?

Review the workflow JSON, configure any required credentials in n8n, and test the automation in a safe workspace before using it in production.

Can I customize this workflow?

Yes. Use the block-by-block analysis and the downloadable JSON to inspect each node, then adjust credentials, prompts, schedules, filters, or destinations for your Crypto Trading, AI Summarization use case.