Zennoposter – download data from Google Search Console

Automation of activities with Zennoposter.

Today we will create a template that will be responsible for downloading data from Google Search Console. We’ll focus on two variables: links to your site and the number of links reported to the sitemap versus indexed links. All data will be automatically saved in an Excel file. This will help us monitor the basic parameters of our website and track how our website’s link status is changing.

Let’s get started!

The first step will be to create a new project and provide a URL to connect to our Google account where we have verified the domains. In the « Go to page » module, you can enter the following URL: https://accounts.google.com/signin

If you don’t remember how to create the module responsible for opening the selected URL, right click > Add Action > Tabs > Go to page.

Next, in the URL field we enter our address in your Google account.

Therefore, our initial module should look like this:

The next step is to create a module that will connect to your Google account.

Start Recording mode (the button is in the upper left corner). Click PPM in the connection field, select Set value in profile > Connection. The program will assign us a random login for the form field and create a new module for us.

Edit the created module and you will see the {-Profile.Login-} variable in the What field. You need to change it with your real Google account, otherwise your login won’t work.

If you have already entered your login (email address), click PPM on the Next button and select To action designer. Next, let’s check that in the Search section, the element is the selected attribute: class and value pointing to the button. Let’s not forget to set the Rise option in the Select action section and click Add to project.

After entering your ID and selecting a new button, Google will ask you to enter your password. We follow the same procedure as for the login by creating new modules. As a result, our current diagram should look like the one in the screenshot below. You should also add pauses every time you select Next. Otherwise, the program may start typing your password before you load the form.

The first stage of the project is behind us, it’s time to create a mechanism that will allow us to download data from Google Search Console. At the very beginning, we need to choose one of our websites from which we want to download data on the number of links and indexed pages. So we enter our website’s GSC, select the « search traffic » tab from the menu and go to « Links to your website ». Here we copy our URL, which will have the following structure:

https://www.google.com/webmasters/tools/external-links?hl=en&siteUrl=http://example.com

You must now create the « Go to page » module, which will redirect you to the search console of http://example.com. Now is the time to write down your first CGC value. We are interested in information regarding the total number of links for our website.

To download the above value, we follow the following steps:

• Select « 4 » and click on PPM by selecting « To action designer ».
• The default setting is Attribute name: class i value:primary. It is a fixed class in GSC and thanks to this we will be able to download the number of links every day.
• In the Select action section, select Get to download the value displayed by the GSC.
• The attribute can be set to innertext, which returns the value « 4 ».
• Click Add to project.

We are editing the created module and we can see that the number of GSC links will be saved in the variable « Variable1 ». Of course we can change the name, but that’s not necessary at the moment.

Download information about downloaded and indexed links

In Google Search Console, go to the Explore tab > sitemaps and copy the URL. It will take the following form:

https://www.google.com/webmasters/tools/sitemap-list?hl=fr&siteUrl=http://example.com/#MAIN_TAB=0&CARD_TAB=0&CARD_TAB=-1

We create the « Go to page » module and place the above link to our website there instead of http://example.com/.

In order to add information about URLs sent to the CGC, we follow the following steps:

• Select the current value of sent links, click on PPM and choose the « To action designer » option.
• By default, you will define the classLabelwmt… thread.
• Select the value « 2 » in the Search option. So the program takes the value of the second class with the same name.
• In the Select action section, select GET to download the value
• Set the attribute to innertext.

We do the same thing with information on indexed pages. The only difference is that the search option is set to « 3 ». We remember that the value « 2 » corresponded to the number of URLs sent.

Now our module should look like this. I also added a 3 second interval between downloading the number of links reported and indexed.

I have already created two variables:

• Number of links declared
• Indexed quantities
  For these variables, I will download the values ​​from Google Search Console. We can also change our first variable which uploaded the number of links to our website. Instead of Variable0, let’s create the variable How many links.

Your template is finished, test it by clicking on the restart button in the main menu.

Then select the Windows > Variables tab from the main menu. We will see a new window with the variables we created earlier.

The Name field corresponds to the name of the variable, while the Value field is a value that is stored in the variable and corresponds to the data extracted from the CGC.

Having already completed the project with the correct download of the CGC data, it may be smart to consider automatically saving it to an Excel file. I’ll describe this in a few simple steps:

1. Create a new excel file in Zennoposter by clicking on PPM in the bottom bar of the program and selecting « Add table ».

1. Click PPM in the workspace and select Add action > Tables > Table processing

1. add to which row and column the first variable should be written (Variable How many links)

1. We follow the same procedure with the reported quantity and the variables indexed by quantity. As a result, we should get the following module.

1. Launch the modules with the Play button, so that green crosses appear on the left to indicate that the task is completed.

1. Open our excel file from the bottom menu and select two options: Load from file and Save changes in table to file (thanks to this, our variables will be saved in the excel file). Additionally, you should choose the path where you want to save your file and the name of your choice. I saved it to my desktop and named it DataGSC.xlsx.

1. Our file appeared on the desktop, after opening it looks like this:

I encourage you to further develop the model and I hope I have not lost you too much, if this is not clear I strongly invite you to look at everything that Zennoposter can offer you if you form correctly by clicking HERE.

It’s below for the training 🙂

To download the trial version: