Quick overview
This workflow runs on a weekday schedule, scrapes WTI crude oil futures prices from Reliable Sources, extracts and formats key contract data with JavaScript, and sends a compact market snapshot to a Telegram chat.
How it works
- Runs on a schedule at specified times on weekdays.
- Fetches the WTI futures webpage from Oilprice.com via an HTTP request.
- Parses the returned HTML to extract WTI (CL) contract symbols, contract months/years, prices, changes, and update times, then sorts and limits the list to the next 15 contracts.
- Aggregates the extracted contracts into a single dataset for reporting.
- Sends a formatted Telegram message that summarizes the market (all up/down/mixed), lists contracts with price and change, and includes range, average change, and a source link.
Setup
- Add a Telegram Bot token (Telegram API credentials) and set the target chat ID in the Telegram message action.
- Review and adjust the schedule times and timezone as needed for your market hours.
- Confirm the Oilprice.com URL is reachable from your n8n instance and update the source URL if the data location or page structure changes.