{ "edges": [ { "to": "node-0003", "from": "node-0002", "toPort": "0", "fromPort": "0" }, { "to": "node-0002", "from": "node-cfg-0010", "toPort": "0", "fromPort": "0" }, { "to": "node-0006", "from": "node-0005", "toPort": "0", "fromPort": "0" }, { "to": "node-cfg-0010", "from": "node-0001", "toPort": "0", "fromPort": "0" }, { "to": "node-0004", "from": "node-0003", "toPort": "0", "fromPort": "0" }, { "to": "node-0005", "from": "node-0004", "toPort": "0", "fromPort": "0" }, { "to": "node-0002", "from": "b369108f-37f6-4d5d-9f70-3d06f3f2e620", "toPort": "0", "fromPort": "0" } ], "nodes": [ { "id": "node-0001", "name": "Schedule Trigger", "type": "trigger", "params": { "kind": "n8n-nodes-base.scheduleTrigger", "rule": { "interval": [ { "field": "cronExpression", "expression": "0 7 * * *" } ] } }, "position": [ 48, 160 ] }, { "id": "node-0002", "name": "Google Sheets", "type": "integration", "params": { "options": {}, "service": "googleSheets", "operation": "read", "sheetName": { "__rl": true, "mode": "list", "value": "gid=0", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1k6mDOKB0B6Wt2OOvaAo7oTxpn7Zt-XeiLA0NZlM6VFY/edit#gid=0", "cachedResultName": "input" }, "documentId": { "__rl": true, "mode": "list", "value": "1k6mDOKB0B6Wt2OOvaAo7oTxpn7Zt-XeiLA0NZlM6VFY", "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1k6mDOKB0B6Wt2OOvaAo7oTxpn7Zt-XeiLA0NZlM6VFY/edit?usp=drivesdk", "cachedResultName": "stocks" } }, "position": [ 496, 256 ] }, { "id": "node-0003", "name": "HTTP Request - EOD", "type": "http", "params": { "url": "={{ 'https://eodhd.com/api/eod/' + $json.ticker + '.US' }}", "options": {}, "sendQuery": true, "queryParameters": { "parameters": [ { "name": "api_token", "value": "={{ $('⚙️ Config').first().json.api_token }}" }, { "name": "fmt", "value": "json" }, { "name": "order", "value": "d" }, { "name": "from", "value": "={{ new Date(Date.now() - 14 * 24 * 60 * 60 * 1000).toISOString().split('T')[0] }}" }, { "name": "to", "value": "={{ new Date().toISOString().split('T')[0] }}" } ] } }, "position": [ 720, 256 ] }, { "id": "node-0004", "name": "HTTP Request - News", "type": "http", "params": { "url": "https://eodhd.com/api/news", "options": {}, "sendQuery": true, "queryParameters": { "parameters": [ { "name": "s", "value": "={{ $('Google Sheets').item.json.ticker + '.US' }}" }, { "name": "api_token", "value": "={{ $('⚙️ Config').first().json.api_token }}" }, { "name": "fmt", "value": "json" }, { "name": "limit", "value": "3" }, { "name": "from", "value": "={{ new Date(Date.now() - 7 * 24 * 60 * 60 * 1000).toISOString().split('T')[0] }}" } ] } }, "position": [ 944, 256 ] }, { "id": "node-0005", "name": "Build Email HTML", "type": "code", "params": { "jsCode": "const gsItems = $('Google Sheets').all();\nconst eodAll = $('HTTP Request - EOD').all();\nconst newsAll = $('HTTP Request - News').all();\n\n// Helper: handles pairedItem as object, array, or number\nfunction getPairedIdx(item) {\n const pi = item.pairedItem;\n if (pi === null || pi === undefined) return 0;\n if (Array.isArray(pi)) return pi[0]?.item ?? 0;\n if (typeof pi === 'object') return pi.item ?? 0;\n return Number(pi) || 0;\n}\n\n// Group split items back by ticker using pairedItem index\nconst eodByIdx = {};\nconst newsByIdx = {};\n\neodAll.forEach(item => {\n const idx = getPairedIdx(item);\n if (!eodByIdx[idx]) eodByIdx[idx] = [];\n eodByIdx[idx].push(item.json);\n});\n\nnewsAll.forEach(item => {\n const idx = getPairedIdx(item);\n if (!newsByIdx[idx]) newsByIdx[idx] = [];\n newsByIdx[idx].push(item.json);\n});\n\nconst oneWeekAgo = new Date(Date.now() - 7 * 24 * 60 * 60 * 1000);\nconst results = [];\nconst failedTickers = [];\n\ngsItems.forEach((gsItem, idx) => {\n const ticker = (gsItem.json.ticker || '').toString().trim().toUpperCase();\n if (!ticker) return;\n\n const eodData = eodByIdx[idx] || [];\n const newsData = newsByIdx[idx] || [];\n\n const eodFailed = eodData.length === 0 || eodData[0]?.error !== undefined;\n const newsFailed = newsData.length === 0 || newsData[0]?.error !== undefined;\n\n if (eodFailed && newsFailed) { failedTickers.push(ticker); return; }\n\n // Price & change\n const sorted = [...eodData].sort((a, b) => new Date(b.date) - new Date(a.date));\n let price = null, changePct = null;\n if (sorted.length >= 2) {\n price = sorted[0].close;\n const prev = sorted[1].close;\n changePct = prev !== 0 ? ((price - prev) / prev) * 100 : null;\n } else if (sorted.length === 1) {\n price = sorted[0].close;\n }\n\n // News — filter to last 7 days\n const news = newsData\n .filter(a => a.date && new Date(a.date) >= oneWeekAgo)\n .slice(0, 5)\n .map(a => {\n const polarity = a.sentiment?.polarity ?? null;\n const sentimentEmoji = polarity === null ? '' : polarity > 0.6 ? '😊' : polarity < 0.4 ? '😟' : '😐';\n const sentimentLabel = polarity === null ? '' : polarity > 0.6 ? 'Positivo' : polarity < 0.4 ? 'Negativo' : 'Neutral';\n const sentimentColor = polarity === null ? '#718096' : polarity > 0.6 ? '#276749' : polarity < 0.4 ? '#c53030' : '#b7791f';\n return {\n title: a.title || 'Untitled',\n date: a.date || '',\n url: a.link || a.url || '#',\n summary: (a.content || a.description || '').toString().substring(0, 200),\n tags: (a.tags || []).slice(0, 3),\n sentimentEmoji, sentimentLabel, sentimentColor\n };\n });\n\n if (eodFailed) failedTickers.push(ticker);\n results.push({ ticker, price, changePct, news, error: eodFailed });\n});\n\n// Classify movers\nconst withChange = results.filter(r => r.changePct !== null);\nwithChange.sort((a, b) => Math.abs(b.changePct) - Math.abs(a.changePct));\n\n// ── Build HTML ──────────────────────────────────────────────────────────────\nconst today = new Date().toLocaleDateString('en-US', { weekday:'long', year:'numeric', month:'long', day:'numeric' });\nconst fmtPrice = v => v != null ? `$${Number(v).toFixed(2)}` : 'N/A';\nconst fmtPct = v => v != null ? `${v >= 0 ? '+' : ''}${Number(v).toFixed(2)}%` : 'N/A';\nconst pctColor = v => v == null ? '#718096' : v >= 0 ? '#276749' : '#c53030';\nconst signal = v => v == null ? '⚪' : v >= 2 ? '🟢' : v <= -2 ? '🔴' : '🟡';\n\n// Movers table rows\nconst moverRows = results.map(r => `\n \n ${r.ticker}\n ${fmtPrice(r.price)}\n ${fmtPct(r.changePct)}\n ${signal(r.changePct)}\n `).join('');\n\n// News sections\nconst newsSections = results.map(r => {\n if (!r.news || r.news.length === 0) return '';\n const articles = r.news.map(a => {\n const tagsHtml = a.tags.length\n ? `

${a.tags.map(t => `${t}`).join('')}

`\n : '';\n const sentHtml = a.sentimentLabel\n ? `${a.sentimentEmoji} ${a.sentimentLabel}`\n : '';\n return `\n

\n ${a.title}\n ${sentHtml}\n

\n ${a.summary ? `

${a.summary}…

` : ''}\n ${tagsHtml}\n

${a.date ? new Date(a.date).toLocaleDateString('en-US',{month:'short',day:'numeric',year:'numeric'}) : ''}

`;\n }).join('');\n\n return `\n

${r.ticker}

\n ${articles}\n

`;\n}).join('');\n\nconst failedSection = failedTickers.length\n ? `

⚠️ No data for: ${failedTickers.join(', ')}

`\n : '';\n\nconst html = `\n\n

📊 Daily Market Digest

${today}

📈 Top Movers

\n \n \n \n \n \n \n \n ${moverRows}\n

Ticker	Last Close	Change %	Signal

📰 News — Last 7 Days

\n ${newsSections || '

No news found for the selected period.

'}\n

\n${failedSection}\n

Generated by n8n · Data by EODHD

\n`;\n\nreturn [{\n json: {\n html,\n subject: `📊 Daily Market Digest — ${new Date().toLocaleDateString('en-US',{month:'short',day:'numeric',year:'numeric'})}`\n }\n}];\n" }, "position": [ 1168, 256 ] }, { "id": "node-0006", "name": "Send Email via Gmail", "type": "integration", "params": { "sendTo": "={{ $('⚙️ Config').first().json.recipient_email }}", "message": "={{ $json.html }}", "options": {}, "service": "gmail", "subject": "={{ $json.subject }}", "operation": "read" }, "position": [ 1392, 256 ] }, { "id": "b369108f-37f6-4d5d-9f70-3d06f3f2e620", "name": "When clicking ‘Execute workflow’", "type": "manualTrigger", "params": {}, "position": [ 272, 352 ] }, { "id": "node-cfg-0010", "name": "⚙️ Config", "type": "set", "params": { "options": {}, "assignments": { "assignments": [ { "id": "cfg-a1", "name": "api_token", "type": "string", "value": "YOUR_EODHD_API_KEY" }, { "id": "cfg-a2", "name": "recipient_email", "type": "string", "value": "your@email.com" } ] } }, "position": [ 272, 160 ] } ] }

Send a daily stock movers and news email digest via Google Sheets, EODHD and Gmail