=SERP() — Google search results in Google Sheets

=SERP() fetches live Google search results for a query and returns them into your sheet — titles, links and snippets. It is the workhorse behind SEO research, competitor monitoring and list building in GPT for Sheets.

Syntax

=SERP(query, [limit])

Parameter	Required	Description
`query`	yes	The search query, string or cell reference. At least 3 characters.
`limit`	no	How many results to return. Default: 20.

Examples

Top results for a keyword in A2:

=SERP(A2, 10)

Who ranks for your money keyword, then summarize angles with GPT:

=SERP("gpt for google sheets", 10)
=GPT("Based on these titles, what content angle is missing?", B2:B11)

Monitor brand mentions — search your brand name from A2:

=SERP(A2&" review", 20)

Common errors

Query not provided or too short. — the query must be at least 3 characters.
Function can only be called once every 20 seconds. — SERP is rate-limited; wait between calls instead of recalculating the whole sheet at once.
Results spill into multiple cells — keep the area below the formula empty or Sheets shows #REF!.

=GOOGLE_SEARCH_API(query, contextId, apiKey, [pages])

The same idea through the official Google Custom Search API with your own key — for higher volumes and stable quotas.

=GPT_WEB_SEARCH() — a synthesized answer instead of raw results
=PERPLEXITY() — web-aware research answers
=GPT() — process the results you fetched

Try it

Copy the template or install GPT for Sheets. Guide: Search the web from Google Sheets.