This n8n workflow automates the process of generating a personalized daily stock market intelligence report tailored to your investment portfolio stored in Google Sheets. It triggers daily at 10 AM to fetch the latest market news, analyze the impact on your holdings, and deliver actionable insights via Telegram. The workflow integrates advanced AI models, including GPT-4 and Perplexity AI, to summarize market headlines, identify investment opportunities, and flag risks. Key nodes include a Schedule Trigger, Google Sheets for portfolio data, AI-powered analysis, Perplexity for web research, and Telegram for delivering the report. This automation is especially useful for active investors, financial advisors, and traders seeking timely, data-driven market updates and trade ideas.

Node Count	11 – 20 Nodes
Nodes Used	@n8n/n8n-nodes-langchain.agent, @n8n/n8n-nodes-langchain.lmChatOpenAi, @n8n/n8n-nodes-langchain.memoryBufferWindow, googleSheetsTool, perplexityTool, scheduleTrigger, stickyNote, telegram