Generate AI trading alerts from CoinGecko and Alpha Vantage via Slack, email and SMS
VerifiedFetches market data and sends email alerts while logging to Postgres.
What this workflow does
The workflow uses scheduled HTTP requests to retrieve cryptocurrency and stock prices, records results in a Postgres database, and dispatches email alerts for qualifying signals.
It suits traders who need automated data collection and basic email notifications without manual API calls or spreadsheet tracking.
Who is this for?
Crypto traders, retail investors, and small finance teams who want automated market monitoring without constant manual chart watching.
What problem it solves
Manually tracking prices and indicators across CoinGecko and Alpha Vantage is slow and error-prone; this workflow automates data pulls, basic analysis, and alert delivery.
Live workflow preview
Interactive canvas of every node and connection — scroll and click to explore. Powered by n8n's preview.
Open the template on n8n to import and run it. View source template →
What it automates
Daily crypto watchlist scan
Runs every 15 minutes on a set of coins, stores results in Postgres, and emails high-confidence signals.
Stock earnings reaction check
Pulls Alpha Vantage data after market open, logs to Postgres, and sends email alerts when thresholds are met.
End-of-day summary
Scheduled run at market close that records indicator values in Postgres and emails a concise report.
How the workflow works
The 4 nodes in this automation, in order.
- 1Send EmailemailSend
- 2HTTP RequesthttpRequest
- 3Postgrespostgres
- 4Codecode
Apps & integrations used
How to set up Generate AI trading alerts from CoinGecko and Alpha Vantage via Slack, email and SMS
- 1Add a Schedule Trigger node set to run every 5-30 minutes
- 2Add HTTP Request nodes to fetch data from CoinGecko and Alpha Vantage APIs
- 3Add a Postgres node to store price data and calculated indicators
- 4Add a Send Email node configured with your SMTP credentials for alerts
- 5Connect the nodes in sequence and test with sample API responses
- 6Activate the workflow and monitor execution history in n8n
How to customize this workflow
- →Change the Schedule Trigger interval or add a manual trigger
- →Add more HTTP Request nodes for additional symbols or endpoints
- →Extend the Postgres schema to store confidence scores or signal history
- →Modify the email template or add conditional logic before sending
Generate AI trading alerts from CoinGecko and Alpha Vantage via Slack, email and SMS: pros & cons
Pros
- +Uses only native n8n nodes (HTTP Request, Send Email, Postgres)
- +Stores execution history for later review
- +Simple to activate and schedule
- +Reduces manual API calls and email drafting
Cons
- –No built-in AI node; signal logic must be added manually or via code
- –Email-only delivery in the listed integrations (Slack/SMS require extra nodes)
- –Requires valid API keys for CoinGecko and Alpha Vantage
Frequently asked questions
It pulls market data via HTTP, stores it in Postgres, and sends email alerts based on the results.
User reviews
Verified reviews from the community shape this listing's rating.
Loading reviews…
Similar workflows
Other ai & llm automations worth a look.