GPTSheetsPlus
Buy license Install free

Updated October 2026: GPT-6, Gemini 4 and the Perplexity Agent API

AI, web scraping and search,
as plain Sheets formulas

Type =GPT(), =SCRAPE() or =SERP() in any cell. GPTSheetsPlus brings the latest OpenAI, Gemini and Perplexity models, Bright Data web scraping and Exa web search into Google Sheets. Free trial, then $19 once. Bring your own API keys.

Add to Google Sheets Buy lifetime license, $19 Read the docs

No subscription. No account. Keys stay inside your Google account.

  • OpenAI GPT-6
  • Google Gemini 4
  • Perplexity
  • Bright Data
  • Exa search
  • Firecrawl

AI models

Always the latest models, one formula away

Every function takes a prompt and an optional system prompt. Retired model names are mapped to their replacements automatically, so sheets you built last year keep working.

OpenAI

GPT-6 and GPT-5.6 families

  • =GPT() gpt-6.1-terra, default
  • =GPT6() gpt-6-astra, most capable
  • =GPT61() gpt-6.1-sol
  • =GPT6mini() gpt-6-luna, cheapest
  • =GPT56() gpt-5.6-sol
  • =OpenAI(p, s, model) any OpenAI model
Full reference →

Google Gemini

Gemini 4, 3.8 Flash and 3.1 Pro

  • =GEMINI() gemini-3.8-flash, default
  • =Gemini4() gemini-4-argon, flagship
  • =Gemini31Pro() gemini-3.1-pro
  • =Gemini38Flash() gemini-3.8-flash
  • =Gemini35FlashLite() fastest, cheapest
  • =GEMINI(p, s, model) any Gemini model
Full reference →

Perplexity

Agent API with live web search

  • =PPLX() fast answer with citations
  • =PPLX_PRO() light multi-step research
  • =PPLX_REASONING() multi-hop research
  • =PPLX_AGENT(p, s, effort) fast to xhigh
  • =EXTRACT_INFO() utility, uses GPT
  • =SUMMARIZE_BULLETS() utility, uses GPT
Full reference →
fx =GPT("Write a one-line tagline for " & A2, "You are a copywriter") → "Notion: one workspace for every thought."

Workflow

Chain formulas into a research pipeline

Search, scrape, extract, enrich. Every step is a cell, so you can drag it down a column and let the sheet do the work.

  1. 1 · Search =SERP("CRM startups", 5) Exa web search returns URLs
  2. 2 · Scrape =SCRAPE(A2) Bright Data fetches the page
  3. 3 · Extract =EXTRACT_INFO(B2, "founder") GPT pulls out one field
  4. 4 · Enrich =PPLX("What does " & A2 & " do?") Perplexity adds live context

Web scraping

Scrape any page into a cell

Powered by Bright Data Web Unlocker, which handles blocks, CAPTCHAs and JavaScript-heavy pages. Results are cached for 6 hours, so recalculating a sheet never burns extra credits.

  • 10 free scrapes to try, then your own Bright Data key
  • Markdown or raw HTML, truncated to fit a cell
  • Title, description, keywords, language, links and status from one request
  • Force browser rendering or pick a proxy country when you need to
Scraping reference
=SCRAPE(url) page as markdown
=SCRAPE_HTML(url) raw HTML
=SCRAPE_TITLE(url) page title
=SCRAPE_DESCRIPTION(url) meta description
=SCRAPE_KEYWORDS(url) meta keywords
=SCRAPE_LANGUAGE(url) page language
=SCRAPE_LINKS(url) every link on the page
=SCRAPE_STATUS(url) HTTP status code
=BRIGHTDATA(url, out, render, country) full control
=Firecrawl(url) with your Firecrawl key

Pricing

Your keys, your costs. No subscription.

Try everything for free. Then one payment unlocks lifetime use with your own API keys.

Free trial

$0no card needed

  • 10 free uses of the GPT functions
  • 10 free uses of the Gemini functions
  • 10 free uses of the Perplexity functions
  • 10 free web scrapes and 10 free web searches
  • Runs on our keys, nothing to configure
Install from the Marketplace
Most popular

Lifetime license

$19once, forever

  • Unlimited sheets, rows and formulas
  • All AI, scraping and search functions
  • Use your own OpenAI, Gemini, Perplexity, Bright Data, Exa and Firecrawl keys
  • Pay providers directly, at cost, with no markup
  • Every future model update included
Buy the lifetime license

Secure checkout via Lemon Squeezy. Your key arrives by email.

FAQ

Questions, answered

Do I need my own API keys?

During the free trial, no. You get 10 free uses each of the OpenAI, Gemini, Perplexity, scraping and search functions on our keys. After that you activate the $19 lifetime license and paste your own keys from OpenAI, Google AI Studio, Perplexity, Bright Data, Exa or Firecrawl. You pay those providers directly, at cost, with no markup.

Is it really a one-time payment?

Yes. $19 once, for lifetime use of the add-on, including future model updates. There is no subscription and no account to create. The only ongoing cost is what you pay the AI and scraping providers for your own usage.

Which spreadsheets does the license work in?

The license and your API keys are stored against your Google account, so they work in every spreadsheet you open. Activate the license from a spreadsheet you own.

Why do I get the same answer when I re-run a formula?

Responses are cached by prompt so that recalculating a sheet does not burn credits or trial uses. Pass TRUE as the ignore_cache argument, for example =GPT("prompt", "", TRUE), to force a fresh call. Scrapes are cached for 6 hours.

My sheet still uses =GPT4o() or =Gemini25Flash(). Will it break?

No. Retired function and model names are mapped to their current replacements automatically. =GPT5() now runs gpt-5.6-sol, =GPT4o() runs gpt-6-luna, and so on. See the legacy names page in the docs for the full list.

Does GPTSheetsPlus see my data?

There is no login and we do not collect personal information. Your prompts go to the provider you chose, using your own key once you are licensed. API keys are stored by Google in your account’s add-on properties, not on our servers.

Ready to put AI in your spreadsheet?

Install in a minute. Your first formulas are free.

Add to Google Sheets Getting started guide