=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")
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.