Live Web Data in Cells with =GPT_WEB()
Pull current stock prices, market data, and real-time facts into your spreadsheet with one formula.
核心功能
在 Google Workspace 中使用 AI 更智能地工作所需的一切。
Live stock prices
Build tables with current stock prices for S&P 500 companies, crypto, or any ticker. Data refreshes when the formula recalculates.
Real-time web lookup
=GPT_WEB() searches the web and returns current answers to factual questions directly in a cell.
Research tables at scale
Combine =GPT_WEB() with ARRAYFORMULA to populate research tables with live data across hundreds of rows.
Pairs with =GPT() and =GPT_TABLE()
Use web data as input to other GPT formulas for enrichment, classification, and reporting workflows.
使用方法
几分钟即可开始使用，无需任何技术配置。
打开 Google Sheets
打开 Google Sheets ，GPT Workspace 侧边栏将出现在右侧，随时准备提供帮助。
描述您的任务
描述您想要的内容，选择语气，AI 会即时处理。一键编辑、改进或翻译。
常见问题
=GPT_WEB() fetches current information from the web into a spreadsheet cell. Ask for stock prices, exchange rates, company facts, or any time-sensitive data.
Yes. This is one of the most popular uses. Enter company names or tickers and use =GPT_WEB() to pull current prices into adjacent cells.
Results reflect web data available at the time the formula runs. Recalculate cells or set up triggers to refresh on a schedule.
Yes. Chain =GPT_WEB() output into =GPT(), =GPT_TRANSLATE(), or standard Sheets formulas for automated research pipelines.
Yes. Web lookups are available on the free plan with daily limits. Pro plans offer higher volume.