Extract volume search from Google Keyword Planner

Features
1

Hi there, Make Community!

I need to automate the extraction of Average Monthly Searches from Google Keyword Planner (part of Google Ads), based on 4 different variables: Country of Interest (eg. Germany), Time period (eg. Last 30 days), Language (eg. English), and a Set of Seed Keywords (eg. Visit Arizona, Travel to Arizona, Flight to Arizona).

The idea would be that I can select the values for these variables from a place like a Google Sheet using drop-down menus or from a simple App interface that allows me to select the variable values, which in turn trigger Make to query Google Keyword Planner and extract the search results to a .csv file or to a Google Sheet.

I want to know:

  1. if Make is able to help with this,
  2. where can I get more support to figure out how to configure the whole process?

Thank you in advance for your advice.

Regards,
Santiago.

3

May peace be upon you @Syoantiago

I think you can use the "Watch Google Sheet " Module to trigger the automation upon the button clicked or any other value change in the Google sheet, which will also transfer the 4 selected variables.

Then you can use the Google Ads campaign management or the official API to create an GET API call for getting the search volumes using according to the 4 variables.

Then you can wither use an aggregator ( depending upon the output ) to process and save the data in a Google Sheet.

If you need further help, feel free to contact

2 Likes
4

Thank you @Automate_with_Rezwan, I will look into this and reach out if necessary. Highly appreciated!

The bottom line in any case is that it looks like there are ways to do what I am looking for using Make, right?

5

@Santiago yes it is doable using Make.com

1 Like