Fetch real-time stock quotes to Google Sheets with OpenAI, Octagon and GitHub
UnknownUnknown. This template uses community nodes we can't verify statically. Uses community nodes that can't be verified statically (unverified community packages are off by default in 3.0). Static check, last run 2026-10-19.
Community nodes
These come from third-party npm packages. In n8n 3.0 unverified community packages are off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
n8n-nodes-octagon(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
What it does
Quick overview Automates real-time stock quote enrichment in Google Sheets using n8n, OpenAI, and the Octagon Agent. Reads ticker symbols from a spreadsheet, fetches a live quote Skill from GitHub, and writes structured market data back to the sheet. How it works 1. Fetches the live SKILL.md file from GitHub using the provided skillsurl. 2. Reads ticker rows from Google Sheets and loops through each ticker symbol. 3. OpenAI acts as a prompt builder, creating a clean, ticker-specific Octagon Agent prompt. 4. The Octagon Agent executes the real-time stock quote request. 5. A code node parses the Octagon response into structured fields. 6. Google Sheets is updated with quote data such as current price, change, volume, day range, 52-week range, market cap, exchange, date, and the full Octagon response. Setup 1. Connect your Google Sheets, OpenAI, and Octagon credentials in n8n. 2. Provide the skillsurl pointing to the live stock-quote SKILL.md file on GitHub. 3. Point the Google Sheets nodes at your spreadsheet, ensuring it has a ticker symbol column. 4. Map the output columns (price, change, volume, ranges, market cap, exchange, etc.) to your sheet. 5. Run the workflow to populate real-time quote data. Requirements - Google Sheets account and credentials - OpenAI credentials - Octagon Agent credentials - A GitHub skillsurl pointing to the stock-quote SKILL.md file - A spreadsheet with a ticker symbol column Customization - Add or remove ticker symbols in the sheet to track different stocks - Adjust which data fields (price, change, volume, ranges, market cap, exchange, etc.) get written back - Modify the OpenAI prompt-builder step to tailor the Octagon Agent query