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