Automate Commodity Sentiment Analysis with n8n & Google Sheets

Automate Commodity Sentiment Analysis with n8n & Google Sheets

Empower 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.

What this workflow does

• Runs every day at 10:00 based on a scheduled trigger.
• Fetches the latest articles from OilPrice and Invezz commodities RSS feeds, selecting the five most recent from each source.
• Merges and structures the feed data uniformly, including title, link, date, content, snippet, and source.
• Utilizes the Groq-hosted chat model to classify each article's sentiment, commodity focus, and impact level, returning a structured JSON.
• Appends the processed data to a specified Google Sheets worksheet with details such as article URL, title, source, and timestamp.
• Calculates 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.
• Delivers immediate Slack alerts when significant sentiment deviations are detected.

Use cases

• Stay ahead in the commodity trading business by leveraging daily insights from trusted news sources like OilPrice and Invezz.
• Enhance your financial analysis and forecasting by integrating real-time sentiment classification into your market strategy.
• Automate your alert system to keep your team informed of significant market movements directly via Slack.

Technical details

• Integrations: Google Sheets, Slack, Groq API.
• n8n Nodes: if, set, code, no op, sort, limit.