Gold market prediction system with Perplexity Sonar-Pro, FRED data, and WordPress reporting
Needs changesNeeds changes. This template uses 1 thing(s) that n8n 3.0 removes: AI Agent v1 (old agent modes). 1 breaking item(s) found. Static check, last run 2026-10-19.
What to replace before upgrading
| Removed in 3.0 | Replace with |
|---|---|
| AI Agent v1 (old agent modes) AI Agent - Gold Market Analysis (v1.7) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (9)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - HTTP Request
n8n-nodes-base.httpRequest - Edit Fields (Set)
n8n-nodes-base.set - Merge
n8n-nodes-base.merge - AI Agent
@n8n/n8n-nodes-langchain.agent - Wordpress
n8n-nodes-base.wordpress - Slack
n8n-nodes-base.slack - Send Email
n8n-nodes-base.emailSend - OpenRouter Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenRouter
What it does
Introduction Automates gold market tracking using AI forecasting by collecting live prices, financial news, and macro indicators (inflation, interest rates, employment) to produce real-time insights and trend predictions for analysts and investors. How It Works Every 6 hours, the system fetches market data and news → runs AI sentiment and trend analysis → generates a concise forecast report → publishes it to WordPress → and alerts users via Slack or email. Workflow Template Trigger → Fetch → Format → Merge → AI Analyze → Report → Publish → Notify Workflow Steps 1. Schedule: Executes automatically every 6 hours using a Cron trigger. 2. Fetch: Retrieves live gold prices (MetalPriceAPI), financial headlines (NewsAPI), and macroeconomic indicators (FRED). 3. Format & Merge: Cleans, normalizes, and merges all data into a single structured dataset for AI analysis. 4. AI Analyze (OpenAI): Performs sentiment, trend, and correlation analysis to forecast short-term gold price movements. 5. Report Generation: Creates a concise summary report with forecasts, insights, and confidence metrics. 6. Publish & Notify: Automatically posts to WordPress and sends alerts via Slack and Email to keep analysts updated. Setup Add API keys: MetalPrice, NewsAPI, FRED, OpenAI, WordPress, Slack, Gmail. Configure scheduling interval, API endpoints, and authentication in n8n. Predefine WordPress post format and Slack message templates for smooth automation. Prerequisites n8n v1.0+, API keys, OAuth credentials, and internet access. Use Cases Investment forecasting, financial newsletter automation, or market monitoring dashboards. Customization Add cryptocurrency or stock tracking, modify AI prompts, or route summaries to Telegram, Notion, or Google Sheets. Benefits Saves analyst time, ensures consistent insights, enhances accuracy, and delivers timely, AI-driven financial intelligence.