=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. |
limit |
no | How many results to return. |
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)
Related
=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.
Try it
Copy the template or install GPT for Sheets. Guide: Search the web from Google Sheets.