{"product_id":"daily-stock-crypto-brief-n8n-workflow-gmail-telegram-sheets","title":"Daily Stock \u0026 Crypto Brief n8n Workflow: Gmail, Telegram, Sheets","description":"\u003ch3\u003eGet a daily Stock \u0026amp; Crypto Brief in your inbox—plus a Telegram digest—automatically\u003c\/h3\u003e\n\u003cp\u003eThis \u003cstrong\u003eDaily Stock \u0026amp; Crypto Brief\u003c\/strong\u003e n8n workflow runs every morning (or on demand) to analyze stock trend\/momentum, score \u003cstrong\u003eGoogle News\u003c\/strong\u003e headlines with an \u003cstrong\u003eOpenAI-compatible\u003c\/strong\u003e model, pulls crypto data from \u003cstrong\u003eCoinGecko\u003c\/strong\u003e, saves results to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and sends a formatted \u003cstrong\u003eHTML email via Gmail\u003c\/strong\u003e plus a compact \u003cstrong\u003eTelegram\u003c\/strong\u003e message.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSchedules and triggers:\u003c\/strong\u003e Runs daily at \u003cstrong\u003e07:00\u003c\/strong\u003e (or via manual trigger) and loads your configured tickers, crypto list, and recipient email.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBuilds day-over-day context:\u003c\/strong\u003e Reads prior ticker scores from \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e to calculate changes.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eStock technical analysis:\u003c\/strong\u003e Fetches \u003cstrong\u003e250 daily price bars\u003c\/strong\u003e per ticker from \u003cstrong\u003eTwelve Data\u003c\/strong\u003e, computes technical indicators\/signals including \u003cstrong\u003eSMA\/EMA, RSI, MACD, Bollinger Bands, ATR\u003c\/strong\u003e, and \u003cstrong\u003e52-week position\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNews sentiment scoring:\u003c\/strong\u003e Pulls recent ticker headlines from \u003cstrong\u003eGoogle News RSS\u003c\/strong\u003e and uses an \u003cstrong\u003eOpenAI-compatible chat model\u003c\/strong\u003e to return a structured sentiment score and short summary based on those headlines.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eComposite scoring and verdict:\u003c\/strong\u003e Combines trend, momentum, sentiment, and volatility into a \u003cstrong\u003e0–100 score\u003c\/strong\u003e with a \u003cstrong\u003eBUY \/ HOLD \/ AVOID\u003c\/strong\u003e verdict; includes pacing (\u003cstrong\u003ewait\u003c\/strong\u003e) to respect free API rate limits.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRanks and reports:\u003c\/strong\u003e Detects verdict\/indicator events, appends today’s scores to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and fetches crypto prices from \u003cstrong\u003eCoinGecko\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExec summary + delivery:\u003c\/strong\u003e Uses an \u003cstrong\u003eOpenAI-compatible model\u003c\/strong\u003e to draft an executive summary, generates an \u003cstrong\u003eHTML email\u003c\/strong\u003e for \u003cstrong\u003eGmail\u003c\/strong\u003e, and sends a concise \u003cstrong\u003eTelegram\u003c\/strong\u003e digest.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eDaily \u003cstrong\u003einvestment briefing\u003c\/strong\u003e for SaaS operators or analysts who track tickers and crypto.\u003c\/li\u003e\n  \u003cli\u003eAutomated “what changed since yesterday” scoring using \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e history.\u003c\/li\u003e\n  \u003cli\u003eNews-aware alerts combining \u003cstrong\u003etechnical indicators\u003c\/strong\u003e with \u003cstrong\u003eGoogle News\u003c\/strong\u003e sentiment.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations \/ nodes:\u003c\/strong\u003e \u003cstrong\u003eTwelve Data\u003c\/strong\u003e (stock bars), \u003cstrong\u003eGoogle News RSS\u003c\/strong\u003e, \u003cstrong\u003eCoinGecko\u003c\/strong\u003e (crypto), \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e (score storage\/history), \u003cstrong\u003eGmail\u003c\/strong\u003e (HTML email), \u003cstrong\u003eTelegram\u003c\/strong\u003e (digest).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWorkflow building blocks:\u003c\/strong\u003e \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003ewait\u003c\/strong\u003e, \u003cstrong\u003egmail\u003c\/strong\u003e, \u003cstrong\u003etelegram\u003c\/strong\u003e, \u003cstrong\u003esticky note\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAI step:\u003c\/strong\u003e OpenAI-compatible chat model for structured headline sentiment + executive summary.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eSetup note:\u003c\/strong\u003e Configure your \u003cstrong\u003eTwelve Data API key\u003c\/strong\u003e and the workflow’s ticker\/crypto lists and recipients.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46094109540531,"sku":"N8N-19949","price":10.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/vjgDDf-m0cJWFh_hyg8tW_NSPba6Rk.png?v=1790413536","url":"https:\/\/buyflowscripts.com\/products\/daily-stock-crypto-brief-n8n-workflow-gmail-telegram-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}