Fetch live commodity quotes with Octagon, OpenAI (GPT-5.4 Mini) and Google Sheets
UnknownWhat this workflow does
This AI workflow has 11 nodes and runs manually, when you click “Execute workflow”. Along the way it connects OpenAI, Google Sheets and Octagon (community).
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Set Commodities Task and Skill URL (Edit Fields (Set)): sets 2 fields: task, skills_url
- Fetch Commodities Skill from GitHub (HTTP Request): calls an HTTP API
- Read Commodity Symbols in Sheets (Google Sheets): uses Google Sheets
- Filter: keeps only the items that match a condition
- Loop Over Commodity Symbols (Loop Over Items (Split in Batches)): loops over the items in batches
- Create Commodities Quote Prompt (OpenAI): uses OpenAI
- Execute Octagon Agent (Octagon Agents): uses Octagon Agents
- Parse Commodities Quote Response (Code): runs custom JavaScript code
- Update Commodities in Sheets (Google Sheets): update
- Wait: waits 1 seconds
Services it uses
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that n8n-nodes-octagon is verified or supports 3.0 (used in Execute Octagon Agent).
Nodes used (10)
- Manual Trigger
n8n-nodes-base.manualTrigger - Edit Fields (Set)
n8n-nodes-base.set - Filter
n8n-nodes-base.filter - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - OpenAI
@n8n/n8n-nodes-langchain.openAi - Octagon Agents
n8n-nodes-octagon.octagonAgents - Google Sheets
n8n-nodes-base.googleSheets - Wait
n8n-nodes-base.wait - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code
From the author
Quick overview Automatically fetches live commodity quotes (gold, silver, crude oil, natural gas, and more) using an Octagon AI Agent, then writes prices, changes, ranges, volume, and moving averages back to a Google Sheet. How it works 1. Reads commodity…