Research, enrich and write inside Google Sheets™ with simple formulas. Type =GPT, =PPLX, =SCRAPE or =SERP into a cell, drag it down, and a whole list fills itself.
TRY IT FREE
Every provider includes 10 free uses per user, no card needed. After that, a single $19 payment unlocks lifetime use with your own API keys. You pay the AI providers directly at their rates. No subscription, ever.
AI MODELS (always current)
- OpenAI: GPT-6 Astra, GPT-6.1 Sol and Terra, GPT-6 Luna, GPT-5.6. =GPT() uses gpt-6.1-terra by default; =OpenAI() takes any model ID.
- Google Gemini: Gemini 4 Argon, 3.8 Flash, 3.1 Pro, 3.5 Flash-Lite. =GEMINI() takes any model ID.
- Perplexity: answers grounded in live web search with citations. =PPLX, =PPLX_PRO, =PPLX_REASONING, =PPLX_AGENT with selectable effort.
- Retired model names keep working: old spreadsheets using GPT4o, GPT5, O3, Gemini15Pro and similar are mapped to current models automatically.
WEB SCRAPING (Bright Data Web Unlocker)
- =SCRAPE(url) returns the page as markdown, =SCRAPE_HTML(url) returns raw HTML.
- =SCRAPE_TITLE, =SCRAPE_DESCRIPTION, =SCRAPE_KEYWORDS, =SCRAPE_LANGUAGE, =SCRAPE_LINKS, =SCRAPE_STATUS.
- =BRIGHTDATA(url, output, render, country) for JavaScript-heavy pages or a specific country.
- Handles blocks, CAPTCHAs and rendering. Bright Data's free tier gives 5,000 requests a month.
WEB SEARCH (Exa)
- =SERP(query) returns URLs, =SERP_DOMAIN returns domains, =SERP_TEXT_RESULT returns page text.
- =SERP_COMPANY(query) returns company websites only. Filter any search by company, news, people, publication and more.
- Exa's free tier gives $10 of credits a month.
TEXT UTILITIES
- =EXTRACT_INFO(text, "what to extract", "number") pulls one field out of any text, as a string, number, date, link or list.
- =SUMMARIZE_BULLETS(text), =LIST_STUFF(noun, count).
CHAIN THEM INTO A PIPELINE
A2: =SERP_COMPANY("B2B CRM startups", 10)
B2: =SCRAPE(A2)
C2: =EXTRACT_INFO(B2, "company name")
D2: =PPLX("Latest funding round of " & C2)
BUILT FOR
Marketers, sales teams, founders and researchers: lead lists, competitor pricing, content briefs, investor and company research, product catalogs. Anything that starts with a list of names or URLs and ends with structured data.
GOOD TO KNOW
- Results are cached, so recalculating a sheet never re-bills the same request.
- Works in any spreadsheet you open. Licensed features require you to be the owner of the spreadsheet.
- Full guide and formula reference: https://gptsheetsplus.com/guides/guide/
- Support: use the Contact Support item in the add-on menu.