=PERPLEXITY() — web-aware AI answers in Google Sheets
=PERPLEXITY() is different from the other model functions: Perplexity answers with live web knowledge, which makes it the go-to formula for research and data enrichment — the kind of company lookups people otherwise do in tools like Clay.
Syntax
=PERPLEXITY(prompt, [value])
| Parameter | Required | Description |
|---|---|---|
prompt |
yes | The question or research instruction. |
value |
no | Extra input appended to the prompt — e.g. a company name or domain. |
Examples
Enrich a company list (A2 = domain):
=PERPLEXITY("What does this company do? One sentence, no fluff:", A2)
Find the latest funding round:
=PERPLEXITY("Latest funding round and amount for "&A2&". Answer in the form: Round, Amount, Year")
Check employee count for lead scoring:
=PERPLEXITY("Approximate employee count for "&A2&". Return only a number or range.")
Verify a prospect’s current job title before outreach:
=PERPLEXITY("Current job title of "&A2&" at "&B2&". Return only the title.")
Tips
- Ask for a fixed answer format — it keeps columns consistent and easy to split.
- Combine with =SERP() when you need raw Google results instead of a synthesized answer.
- For emails and contacts, see the lead enrichment template.
- Drag the formula down to enrich a whole list, then use Replace all GPT formulas with results in the sidebar so lookups are not re-run on refresh.
Related functions
- =GPT_WEB_SEARCH() — web-grounded answers via search-enabled GPT models
- =SERP() — raw search results with titles and links
- =GPT() — pure model knowledge, no web access