{"product_id":"automate-commodity-sentiment-analysis-with-n8n-google-sheets","title":"Automate Commodity Sentiment Analysis with n8n \u0026 Google Sheets","description":"\u003ch3\u003eAutomate Commodity Sentiment Analysis with n8n \u0026amp; Google Sheets\u003c\/h3\u003e\n\n\u003cp\u003e\nEmpower your commodity market insights with a streamlined workflow designed for real-time sentiment analysis. Run daily at 10:00, this n8n automation effortlessly aggregates and analyzes data from OilPrice and Invezz RSS feeds, using advanced machine learning to classify sentiment and update Google Sheets. When significant sentiment shifts are detected, instant Slack alerts keep you informed, enabling proactive decision-making.\n\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\n\u003cul\u003e\n  \u003cli\u003eRuns every day at 10:00 based on a scheduled trigger.\u003c\/li\u003e\n  \u003cli\u003eFetches the latest articles from OilPrice and Invezz commodities RSS feeds, selecting the five most recent from each source.\u003c\/li\u003e\n  \u003cli\u003eMerges and structures the feed data uniformly, including title, link, date, content, snippet, and source.\u003c\/li\u003e\n  \u003cli\u003eUtilizes the Groq-hosted chat model to classify each article's sentiment, commodity focus, and impact level, returning a structured JSON.\u003c\/li\u003e\n  \u003cli\u003eAppends the processed data to a specified Google Sheets worksheet with details such as article URL, title, source, and timestamp.\u003c\/li\u003e\n  \u003cli\u003eCalculates and aggregates average sentiment scores for each commodity, preparing Slack messages with trends and summary links whenever sentiment shifts notably above 0.3 or below -0.3.\u003c\/li\u003e\n  \u003cli\u003eDelivers immediate Slack alerts when significant sentiment deviations are detected.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\n\u003cul\u003e\n  \u003cli\u003eStay ahead in the commodity trading business by leveraging daily insights from trusted news sources like OilPrice and Invezz.\u003c\/li\u003e\n  \u003cli\u003eEnhance your financial analysis and forecasting by integrating real-time sentiment classification into your market strategy.\u003c\/li\u003e\n  \u003cli\u003eAutomate your alert system to keep your team informed of significant market movements directly via Slack.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\n\u003cul\u003e\n  \u003cli\u003eIntegrations: Google Sheets, Slack, Groq API.\u003c\/li\u003e\n  \u003cli\u003en8n Nodes: if, set, code, no op, sort, limit.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45568668205235,"sku":"N8N-16265","price":20.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/jGhdWh344vgwsKNghkUci_f89b46e826fb42619ec61956debc9080.jpg?v=1781168580","url":"https:\/\/buyflowscripts.com\/products\/automate-commodity-sentiment-analysis-with-n8n-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}