fbpx
5/5 - (16 votes)

Automation of activities with Zennoposter.

Today we will create a template that will be responsible for downloading data from Google Search Console. We will 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 metrics of our website and keep track of how our website is doing in terms of links.

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 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.

Then, 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 the Recording mode (the button is in the upper left corner). Click on PPM in the login field, select Set Value in Profile > Login. 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 variable {-Profile.Login-} in the What field. You have to change it with your real Google account, otherwise your login will not work.

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

After entering your login 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 each time you select Next. Otherwise, the program may start typing your password before you load the form.

The first step of the project is behind us, it is 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

Now you need to create the "Go to page" module, which will redirect you to the search console of http://example.com. Now it's time to record your first GSC value. We are interested in information about the total number of links for our website.

To download the above value, we follow these steps:

  • Select "4" and click on PPM by selecting "To action designer".
  • The default setting is Attribute name: class i value:primary. This is a fixed class in GSC and thanks to this we will be able to download the number of links each 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 on 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 it is not necessary at the moment.

Download information on downloaded and indexed links

In the Google Search Console, go to the Explore > sitemaps tab 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 in its place at http://example.com/.

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

  • Select the current value of the sent links, click on PPM and choose the "To action designer" option.
  • By default, you will define the thread classLabel\wmt....
  • Select the value "2" in the Search option. Thus, 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 the information about the indexed pages. The only difference is that the search option is set to "3". We remember that the value "2" was the number of URLs sent.

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

Open the first module Get value[innertext] and check which variable is added to it (an automatic Variable2 should be created). If not, enter the module, expand the "Put tu variable" list and select "New....." from the list.

I have already created two variables:

  • Number of links reported
  • Indexed quantities
    For these variables, I will download the values from Google Search Console. We can also change our first variable that downloaded 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 tab > Variables from the main menu. We will see a new window with the variables we created earlier.

The Name field is 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 GSC.

Having already completed the project with the correct upload of the GSC data, it may be smart to consider automatically saving it to an Excel file. I will 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 on 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 quantity-indexed variables. As a result, we should obtain 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 finished.

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

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

I encourage you to develop the model further and I hope I haven't lost you too much, if it's not clear I strongly invite you to look at everything Zennoposter can offer you if you are form correctly by clicking HERE. 

It's below for the training 🙂

To download the trial version:

en_USEnglish
Receive my news

Receive my news

Sign up to receive my tips ;)

Go to your mailbox to validate your registration ;)

%d bloggers like this: