Automate Stock Quotes in Google Sheets with n8n & OpenAI

Transform your Google Sheets into a powerful stock market data hub with this automated n8n workflow that combines OpenAI's intelligent prompt generation with real-time stock quote retrieval through Octagon Agent.

What this workflow does

This comprehensive automation streamlines stock market data collection by reading ticker symbols from your Google Sheets and automatically populating them with live market information. The workflow fetches the latest stock quote skill from GitHub, processes your ticker list, and leverages OpenAI to generate optimized queries for the Octagon Agent. Each stock request returns structured data including current price, daily changes, trading volume, price ranges, market capitalization, and exchange information—all automatically written back to your spreadsheet.

Key workflow steps

• Retrieves live SKILL.md file from GitHub using the provided skills URL
• Reads ticker symbol rows from your Google Sheets document
• Loops through each ticker symbol for batch processing
• Uses OpenAI as an intelligent prompt builder to create optimized Octagon Agent queries
• Executes real-time stock quote requests through Octagon Agent
• Parses responses into structured fields via custom code node
• Updates Google Sheets with comprehensive market data including price, volume, day range, 52-week range, market cap, exchange, and timestamps

Use cases

Perfect for portfolio managers tracking multiple investments, financial analysts requiring automated market data updates, SaaS operators building client dashboards, or automation engineers creating stock monitoring systems. This workflow eliminates manual data entry while ensuring your spreadsheets always contain current market information.

Technical details

Built with essential n8n nodes including HTTP Request for API calls, Code nodes for data parsing, Set nodes for variable management, Filter nodes for data processing, Wait nodes for rate limiting, and Sticky Note nodes for workflow documentation. Integrates seamlessly with Google Sheets, OpenAI API, GitHub, and Octagon Agent for a robust stock quote automation solution.