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

getSearchVolumeFromGoogle(A1:A3, "ES", "Spain", false, true") 
// keyword    search volume   high top of page bid    low top of page bid 11/2021 10/2021 9/2021  8/2021  7/2021  6/2021  5/2021  4/2021  3/2021  2/2021  1/2021  12/2020
// seo    22200   3,08    0,63    33100   27100   27100   27100   27100   22200   18100   14800   22200   22200   27100   22200
// link building    1000    6,86    1,36    1300    1300    1300    1000    1000    1000    1000    720 880 1000    1000    1300
// seo agency    170 6,21    2,14    170 90  110 260 390 260 210 140 110 170 170 140

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