{"product_id":"n8n-portfolio-price-alerts-google-sheets-openai-telegram","title":"n8n Portfolio Price Alerts: Google Sheets, OpenAI \u0026 Telegram","description":"\u003ch3\u003eGet automatic Telegram alerts for big daily moves in your Google Sheets portfolio\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow watches your \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e portfolio, calculates 1-day price changes using \u003cstrong\u003eYahoo Finance\u003c\/strong\u003e data, enriches notable movers with \u003cstrong\u003eSEC EDGAR filings\u003c\/strong\u003e and \u003cstrong\u003eGoogle News (via SerpAPI)\u003c\/strong\u003e, then uses \u003cstrong\u003eOpenAI (GPT-5)\u003c\/strong\u003e to generate a clear explanation and sends it to you in \u003cstrong\u003eTelegram\u003c\/strong\u003e—with a log written back to your sheet.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on schedule\u003c\/strong\u003e: executes on weekdays at \u003cem\u003e10:00\u003c\/em\u003e, \u003cem\u003e14:00\u003c\/em\u003e, and \u003cem\u003e18:00\u003c\/em\u003e (Europe\/Berlin), and can also be triggered on demand via an \u003cstrong\u003eExecute Workflow\u003c\/strong\u003e trigger.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads your holdings\u003c\/strong\u003e: loads alert settings (Telegram chat ID and move threshold) and pulls each holding from the Google Sheets \u003cstrong\u003e“portfolio”\u003c\/strong\u003e tab, resolving symbols via Yahoo Finance.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDetects significant movers\u003c\/strong\u003e: fetches recent quotes from Yahoo Finance (in batches), pulls EUR FX rates from \u003cstrong\u003eFrankfurter\u003c\/strong\u003e, calculates the \u003cstrong\u003e1-day move vs. the previous close\u003c\/strong\u003e, and de-duplicates repeat alerts within the same day.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEnriches breach events\u003c\/strong\u003e: for holdings exceeding your percentage threshold, it attempts to resolve a US \u003cstrong\u003eCIK\u003c\/strong\u003e and retrieves recent \u003cstrong\u003eSEC EDGAR submission\u003c\/strong\u003e data, then fetches related \u003cstrong\u003eGoogle News\u003c\/strong\u003e via \u003cstrong\u003eSerpAPI\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates evidence-based explanation\u003c\/strong\u003e: combines price move + SEC filings + news context, then asks \u003cstrong\u003eOpenAI (GPT-5)\u003c\/strong\u003e to produce a \u003cstrong\u003eTelegram-ready HTML\u003c\/strong\u003e explanation grounded in the retrieved evidence.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends and logs\u003c\/strong\u003e: posts the formatted alert to your \u003cstrong\u003eTelegram\u003c\/strong\u003e chat and appends a summary (timestamp, movers, preview) to the \u003cstrong\u003eGoogle Sheets “finance_alert”\u003c\/strong\u003e tab.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eGet timely alerts when stocks in your Sheets portfolio swing beyond your configured threshold.\u003c\/li\u003e\n  \u003cli\u003eAutomatically attach SEC EDGAR and recent Google News context to help explain why a move happened.\u003c\/li\u003e\n  \u003cli\u003eMaintain an auditable alert history directly in Google Sheets.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eIntegrations: \u003cstrong\u003eTelegram\u003c\/strong\u003e, \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, \u003cstrong\u003eYahoo Finance\u003c\/strong\u003e, \u003cstrong\u003eFrankfurter\u003c\/strong\u003e, \u003cstrong\u003eSerpAPI (Google News)\u003c\/strong\u003e, \u003cstrong\u003eSEC EDGAR\u003c\/strong\u003e, \u003cstrong\u003eOpenAI (GPT-5)\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003en8n nodes used (from workflow): \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003etelegram\u003c\/strong\u003e, \u003cstrong\u003ehttp request\u003c\/strong\u003e, plus a \u003cstrong\u003esticky note\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003e\u003cstrong\u003eSetup tip:\u003c\/strong\u003e Create a Telegram bot, add Telegram credentials in n8n, set your chat ID in the \u003cstrong\u003e⚙️ Config\u003c\/strong\u003e node, and ensure your sheet contains a \u003cstrong\u003eportfolio\u003c\/strong\u003e tab (holdings) and a \u003cstrong\u003efinance_alert\u003c\/strong\u003e tab (logging).\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46081375371443,"sku":"N8N-19890","price":74.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/sW6JtVawPGl_ybxMS_Exk_2nBsTVZM.png?v=1790240598","url":"https:\/\/buyflowscripts.com\/products\/n8n-portfolio-price-alerts-google-sheets-openai-telegram","provider":"N8N Commerce","version":"1.0","type":"link"}