Octagon Stock Quote Skill → Google Sheets

Automate real-time stock quote enrichment in Google Sheets using n8n, OpenAI, and Octagon Agent. This workflow reads ticker symbols from a spreadsheet, fetches the live stock-quote Skill from GitHub, uses an OpenAI prompt-builder step to generate the best Octagon Agent query, executes the quote request through Octagon, then writes structured market data back into Google Sheets.

How this n8n workflow works

1. Fetches the live SKILL.md file from GitHub using the provided skills_url.
2. Reads ticker rows from Google Sheets.
3. Loops through each ticker symbol.
4. OpenAI acts as a prompt builder and creates a clean, ticker-specific Octagon Agent prompt.
5. Octagon Agent executes the real-time stock quote request.
6. A code node parses the Octagon response into structured fields.
7. 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.