GET_SEARCH_VOLUME_FROM_GOOGLE
Get Google Ads keyword data: search volume, competition, and CPC.
=GET_SEARCH_VOLUME_FROM_GOOGLE(keywords, [location], [language])Returns: 2D array with columns: Keyword, Search Volume, Competition, CPC
Overview
GET_SEARCH_VOLUME_FROM_GOOGLE retrieves keyword metrics directly from Google's Keyword Planner data, including monthly search volume, competition level, and cost-per-click (CPC) estimates. This is the same data that advertisers use to plan Google Ads campaigns, now available directly in your Google Sheets without needing a Google Ads account.
Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
keywords | string or range | Yes | A single keyword string or a range of cells containing keywords to look up. |
location | string | No (United States) | The geographic location for volume data. |
language | string | No (English) | The language for keyword data. |
Examples
Check volume for a single keyword
Get search volume, competition, and CPC for a single keyword.
=GET_SEARCH_VOLUME_FROM_GOOGLE("project management software")Output
| Keyword | Search Volume | Competition | CPC |
| project management software | 33100 | High | $12.50 |
Bulk keyword research from a range
Pass a range of cells containing multiple keywords to get data for all of them in one call.
=GET_SEARCH_VOLUME_FROM_GOOGLE(A2:A10)Input
| email marketing |
| email marketing software |
| email marketing tools |
| best email marketing platform |
| email automation |
Output
| Keyword | Search Volume | Competition | CPC |
| email marketing | 40500 | High | $8.20 |
| email marketing software | 12100 | High | $15.30 |
| email marketing tools | 8100 | High | $11.75 |
| best email marketing platform | 2900 | High | $14.00 |
| email automation | 6600 | Medium | $9.50 |
Get volume for a specific country
Check search volume for an auto insurance keyword in the Mexican market.
=GET_SEARCH_VOLUME_FROM_GOOGLE("seguros de auto", "Mexico", "Spanish")Output
| Keyword | Search Volume | Competition | CPC |
| seguros de auto | 49500 | High | $2.80 |
Research low-competition long-tail keywords
Analyze long-tail keyword variations to find opportunities with lower competition.
=GET_SEARCH_VOLUME_FROM_GOOGLE(A2:A6)Input
| how to start a podcast |
| how to start a podcast on spotify |
| how to start a podcast for free |
| podcast equipment for beginners |
| podcast hosting platforms |
Output
| Keyword | Search Volume | Competition | CPC |
| how to start a podcast | 27100 | Medium | $2.10 |
| how to start a podcast on spotify | 8100 | Low | $1.50 |
| how to start a podcast for free | 4400 | Low | $1.80 |
| podcast equipment for beginners | 6600 | Medium | $3.20 |
| podcast hosting platforms | 3600 | Medium | $5.40 |
Compare keyword volumes across markets
Check the search demand for fintech keywords in the Indian market.
=GET_SEARCH_VOLUME_FROM_GOOGLE("online banking", "India", "English")Output
| Keyword | Search Volume | Competition | CPC |
| online banking | 135000 | High | $0.85 |
Use Cases
Keyword research and content planning
Analyze search volumes for hundreds of potential blog post topics. Prioritize content creation based on search demand, competition level, and the commercial value indicated by CPC. Build a data-driven editorial calendar.
PPC campaign planning and budgeting
Estimate campaign costs by multiplying search volume by CPC for target keywords. Identify high-volume, low-CPC keywords for efficient ad spend. Compare keyword costs across different markets to optimize budget allocation.
Market sizing and demand analysis
Use search volume as a proxy for market demand. Analyze total search volume across a keyword cluster to estimate market size. Compare volumes across countries to identify the largest addressable markets for a product category.
SEO opportunity scoring
Create keyword opportunity scores by combining search volume with competition data. High-volume, low-competition keywords represent the best opportunities. Score and rank hundreds of keywords to prioritize SEO efforts.
Product naming and positioning research
Compare search volumes for different ways people describe your product category. Choose product naming and messaging that aligns with how your target audience actually searches.
Seasonal trend analysis
Track search volumes for seasonal keywords across different months. Plan inventory, marketing campaigns, and content releases around periods of peak search demand.
Pro Tips
Always pass keywords as a range (e.g., A2:A100) rather than individual cells with separate formulas. This uses a single SERP credit for all keywords instead of one credit per keyword, saving you hundreds of credits.
Sort results by Search Volume descending and then filter by Competition = "Low" to quickly find high-potential keyword opportunities that are easier to rank for.
Calculate an "opportunity score" by dividing Search Volume by CPC. Keywords with high volume and low CPC often represent underserved niches where you can capture valuable traffic efficiently.
Combine with AI_KEYWORDS or SUGGEST_QUERIES to first generate keyword ideas, then pass them to GET_SEARCH_VOLUME_FROM_GOOGLE to validate which ideas have actual search demand.
When comparing markets, run the same keyword set for different locations. This reveals which markets have the highest demand for your product or service category.
Search volume represents the average monthly number of searches for a keyword on Google. This metric is essential for keyword research, content prioritization, and market sizing. High-volume keywords indicate strong demand, while low-volume keywords may represent niche opportunities with less competition.
The competition metric shows how competitive the paid advertising landscape is for each keyword, rated as Low, Medium, or High. While this reflects ad competition rather than organic SEO difficulty, it correlates with commercial intent. Keywords with high competition tend to be more commercially valuable and harder to rank for organically as well.
CPC (cost-per-click) shows the estimated cost an advertiser would pay for a click on a Google Ad for that keyword. This metric is useful even for SEO-focused teams because it indicates the monetary value of ranking organically. A keyword with a $50 CPC represents significant value if you can capture that traffic through organic rankings instead of paid ads.
One of the most powerful features of this function is its ability to accept multiple keywords at once. You can pass a range of cells containing keywords, and the function will return data for all of them in a single call using just one SERP credit. This makes it extremely efficient for bulk keyword research, allowing you to analyze hundreds of keywords quickly.
The location and language parameters let you get volume data for specific markets. Search volume varies dramatically by country, so specifying the correct market is crucial for accurate data.
Common Errors
#REF! - Spill errorCause: The output array cannot expand because adjacent cells contain data.
Fix: Clear the cells below and to the right of the formula. For N keywords, you need N+1 rows (header + one row per keyword) and 4 columns (Keyword, Search Volume, Competition, CPC).
#ERROR - SERP credit limit reachedCause: Your monthly SERP credit balance has been exhausted.
Fix: Upgrade to Business for 10,000 monthly credits. Since bulk lookups use only one credit, this function is rarely the cause of credit exhaustion. Check if other SERP functions are consuming your credits.
#ERROR - Invalid keyword rangeCause: The range reference contains empty cells or non-text values mixed with keywords.
Fix: Ensure the range contains only text values (keywords) without empty rows or numeric values. Remove any blank cells from the middle of the range, or use a filtered range that excludes blanks.
Frequently Asked Questions
You can pass a range of cells containing up to several hundred keywords in a single call. The function processes all keywords in the range and returns data for each one. This bulk capability uses only one SERP credit regardless of the number of keywords, making it very efficient for large-scale keyword research.
The data comes from Google's Keyword Planner, the same source that Google Ads advertisers use to plan campaigns. This ensures the search volume, competition, and CPC figures are as accurate as Google's own data.
The function returns Google's estimated average monthly search volume. Google provides rounded figures (e.g., 1000, 1300, 1600, 2400, 2900) rather than precise numbers. For most use cases, these estimates are sufficiently accurate for keyword comparison and prioritization.
Competition (Low, Medium, or High) reflects how many advertisers are bidding on the keyword in Google Ads. It does not directly measure SEO difficulty. However, high advertising competition often correlates with keywords that are also competitive in organic search because they have clear commercial value.
CPC represents the estimated cost-per-click for a Google Ads top-of-page bid. It is the approximate amount an advertiser would need to bid to appear at the top of paid results. This value fluctuates based on auction dynamics but provides a useful benchmark for keyword value.
GET_SEARCH_VOLUME_FROM_GOOGLE returns current average monthly volumes. It does not provide historical trend data or month-by-month breakdowns. For trend analysis, you would need to log the data periodically in your spreadsheet or use complementary tools.
No. Whether you pass a single keyword or a range of 200 keywords, the function uses just one SERP credit. This makes bulk lookups extremely cost-effective compared to checking keywords one at a time.
Keywords with very low or no measurable search volume will return a search volume of 0. This does not necessarily mean nobody searches for the term. It may mean the volume is too low for Google to provide a reliable estimate (typically under 10 searches per month).
Related Functions
AI_KEYWORDS
Generate keyword ideas with metadata from a seed keyword using AI
SUGGEST_QUERIES
Get Google autocomplete suggestions for a search query
GET_KEYWORD_POSITION
Get ranking position of a domain in Google search results for a keyword.
CLUSTERIZE
Cluster keywords by common word stems for SEO content planning and analysis.
Start using GET_SEARCH_VOLUME_FROM_GOOGLE today
Install Unlimited Sheets to get GET_SEARCH_VOLUME_FROM_GOOGLE and 41 other powerful functions in Google Sheets.