getSearchVolumeFromGoogle
Overview
Get the monthly search volume and the seasonality per month of a keyword directly from Google Ads Keyword Planner.
This function accepts 1000 keywords per request, so it is recommended to split the keywords in groups of 1000.
DON'T execute this function cell by cell or you'll consume your API credits very fast.
Credits cost per execution
This function spends 200 credits per execution
Video example
Arguments
keywords: The list of keywords to get the search volume for
languageCode: The language code where to do the search (i.e.
en
for English)locationName: The location where to do the search (i.e.
United States
). Check the full list of locations availables here
Optional arguments
skipHeader: If true, the first row of the results will be skipped
skipMonthlySearches: If true, the monthly searches (seasonality) will be skipped
searchEngine: The search engine to use (By default is used
Google
)searchPartners: If true, the search will be done with the partners search engines
dateFrom: The date from where to do the search. (By default is the
last 12 months
)dateTo: The date to where to do the search. (By default is
yesterday
)sortBy: use these parameters to sort the results b:
relevance (By default is used relevance)
searchvolume
competitionindex
lowtopofpagebid
hightopofpagebid
Expected output
Array: The list of keywords with their search volume and seasonality
Text example
Use cases
Improve your keyword research using Google Sheets
Get keyword search volume in Google Spreadsheets
Get keyword seasonality per month in Sheets
Last updated