Fetch real-time stock quotes to Google Sheets with OpenAI, Octagon and GitHub

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