{"id":1256,"date":"2024-06-29T18:21:13","date_gmt":"2024-06-29T18:21:13","guid":{"rendered":"https:\/\/nerdax.com\/?p=1256"},"modified":"2024-06-29T18:21:16","modified_gmt":"2024-06-29T18:21:16","slug":"zennoposter-download-data-from-google-search-console","status":"publish","type":"post","link":"https:\/\/nerdax.com\/en\/zennoposter-download-data-from-google-search-console\/","title":{"rendered":"Zennoposter \u2013 download data from Google Search Console"},"content":{"rendered":"<div class=\"kk-star-ratings kksr-auto kksr-align-left kksr-valign-top\"\n    data-payload='{&quot;align&quot;:&quot;left&quot;,&quot;id&quot;:&quot;1256&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;top&quot;,&quot;ignore&quot;:&quot;&quot;,&quot;reference&quot;:&quot;auto&quot;,&quot;class&quot;:&quot;&quot;,&quot;count&quot;:&quot;0&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;0&quot;,&quot;starsonly&quot;:&quot;&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;5&quot;,&quot;greet&quot;:&quot;Rate this post&quot;,&quot;legend&quot;:&quot;0\\\/5 - (0 votes)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;Zennoposter \u2013 download data from Google Search Console&quot;,&quot;width&quot;:&quot;0&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} - ({count} {votes})&quot;,&quot;font_factor&quot;:&quot;1.25&quot;}'>\n            \n<div class=\"kksr-stars\">\n    \n<div class=\"kksr-stars-inactive\">\n            <div class=\"kksr-star\" data-star=\"1\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"2\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"3\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"4\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"5\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n    \n<div class=\"kksr-stars-active\" style=\"width: 0px;\">\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n<\/div>\n                \n\n<div class=\"kksr-legend\" style=\"font-size: 19.2px;\">\n            <span class=\"kksr-muted\">Rate this post<\/span>\n    <\/div>\n    <\/div>\n<p>Automation of activities with Zennoposter.<\/p>\n<p>Today we will create a template that will be responsible for downloading data from Google Search Console. We&rsquo;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&rsquo;s link status is changing.<\/p>\n<p>Let&rsquo;s get started!<\/p>\n<p>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 \u00ab\u00a0Go to page\u00a0\u00bb module, you can enter the following URL: https:\/\/accounts.google.com\/signin<\/p>\n<p>If you don&rsquo;t remember how to create the module responsible for opening the selected URL, right click &gt; Add Action &gt; Tabs &gt; Go to page.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-88\" src=\"https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/1.jpg\" alt=\"\" width=\"721\" height=\"300\" srcset=\"https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/1.jpg 721w, https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/1-480x200.jpg 480w\" sizes=\"(min-width: 0px) and (max-width: 480px) 480px, (min-width: 481px) 721px, 100vw\" \/><\/p>\n<p>Next, in the URL field we enter our address in your Google account.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-89\" src=\"https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/2.jpg\" alt=\"\" width=\"439\" height=\"164\" srcset=\"https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/2.jpg 439w, https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/2-300x112.jpg 300w, https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/2-18x7.jpg 18w, https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/2-50x19.jpg 50w\" sizes=\"(max-width: 439px) 100vw, 439px\" \/><\/p>\n<p>Therefore, our initial module should look like this:<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-90\" src=\"https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/3.jpg\" alt=\"\" width=\"452\" height=\"251\" srcset=\"https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/3.jpg 452w, https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/3-300x167.jpg 300w, https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/3-18x10.jpg 18w, https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/3-50x28.jpg 50w\" sizes=\"(max-width: 452px) 100vw, 452px\" \/><\/p>\n<p>The next step is to create a module that will connect to your Google account.<\/p>\n<p>Start Recording mode (the button is in the upper left corner). Click PPM in the connection field, select Set value in profile &gt; Connection. The program will assign us a random login for the form field and create a new module for us.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-91\" src=\"https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/4.jpg\" alt=\"\" width=\"451\" height=\"420\" srcset=\"https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/4.jpg 451w, https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/4-300x279.jpg 300w, https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/4-13x12.jpg 13w, https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/4-50x47.jpg 50w\" sizes=\"(max-width: 451px) 100vw, 451px\" \/><\/p>\n<p>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&rsquo;t work.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-92\" src=\"https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/5.jpg\" alt=\"\" width=\"490\" height=\"272\" srcset=\"https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/5.jpg 490w, https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/5-480x266.jpg 480w\" sizes=\"(min-width: 0px) and (max-width: 480px) 480px, (min-width: 481px) 490px, 100vw\" \/><\/p>\n<p>If you have already entered your login (email address), click PPM on the Next button and select To action designer. Next, let&rsquo;s check that in the Search section, the element is the selected attribute: class and value pointing to the button. Let&rsquo;s not forget to set the Rise option in the Select action section and click Add to project.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-93\" src=\"https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/6.jpg\" alt=\"\" width=\"431\" height=\"208\" srcset=\"https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/6.jpg 431w, https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/6-300x145.jpg 300w, https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/6-18x9.jpg 18w, https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/6-50x24.jpg 50w\" sizes=\"(max-width: 431px) 100vw, 431px\" \/><\/p>\n<p>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.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-94\" src=\"https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/7.jpg\" alt=\"\" width=\"457\" height=\"294\" srcset=\"https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/7.jpg 457w, https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/7-300x193.jpg 300w, https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/7-18x12.jpg 18w, https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/7-50x32.jpg 50w\" sizes=\"(max-width: 457px) 100vw, 457px\" \/><\/p>\n<p>The first stage of the project is behind us, it&rsquo;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&rsquo;s GSC, select the \u00ab\u00a0search traffic\u00a0\u00bb tab from the menu and go to \u00ab\u00a0Links to your website\u00a0\u00bb. Here we copy our URL, which will have the following structure:<\/p>\n<p>https:\/\/www.google.com\/webmasters\/tools\/external-links?hl=en&amp;siteUrl=<strong>http:\/\/example.com<\/strong><\/p>\n<p>You must now create the \u00ab\u00a0Go to page\u00a0\u00bb 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.<\/p>\n<p>To download the above value, we follow the following steps:<\/p>\n<ul>\n<li>Select \u00ab\u00a04\u00a0\u00bb and click on PPM by selecting \u00ab\u00a0To action designer\u00a0\u00bb.<\/li>\n<li>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.<\/li>\n<li>In the Select action section, select Get to download the value displayed by the GSC.<\/li>\n<li>The attribute can be set to innertext, which returns the value \u00ab\u00a04\u00a0\u00bb.<\/li>\n<li>Click Add to project.<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-95\" src=\"https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/8.jpg\" alt=\"\" width=\"435\" height=\"296\" srcset=\"https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/8.jpg 435w, https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/8-300x204.jpg 300w, https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/8-18x12.jpg 18w, https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/8-50x34.jpg 50w\" sizes=\"(max-width: 435px) 100vw, 435px\" \/><\/p>\n<p>We are editing the created module and we can see that the number of GSC links will be saved in the variable \u00ab\u00a0Variable1\u00a0\u00bb. Of course we can change the name, but that&rsquo;s not necessary at the moment.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-96\" src=\"https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/9.jpg\" alt=\"\" width=\"434\" height=\"330\" srcset=\"https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/9.jpg 434w, https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/9-300x228.jpg 300w, https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/9-16x12.jpg 16w, https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/9-50x38.jpg 50w\" sizes=\"(max-width: 434px) 100vw, 434px\" \/><\/p>\n<p>Download information about downloaded and indexed links<\/p>\n<p>In Google Search Console, go to the Explore tab &gt; sitemaps and copy the URL. It will take the following form:<\/p>\n<p>https:\/\/www.google.com\/webmasters\/tools\/sitemap-list?hl=fr&amp;siteUrl=<strong>http:\/\/example.com\/<\/strong>#MAIN_TAB=0&amp;CARD_TAB=0&amp;CARD_TAB=-1<\/p>\n<p>We create the \u00ab\u00a0Go to page\u00a0\u00bb module and place the above link to our website there instead of http:\/\/example.com\/.<\/p>\n<p>In order to add information about URLs sent to the CGC, we follow the following steps:<\/p>\n<ul>\n<li>Select the current value of sent links, click on PPM and choose the \u00ab\u00a0To action designer\u00a0\u00bb option.<\/li>\n<li>By default, you will define the classLabelwmt&#8230; thread.<\/li>\n<li>Select the value \u00ab\u00a02\u00a0\u00bb in the Search option. So the program takes the value of the second class with the same name.<\/li>\n<li>In the Select action section, select GET to download the value<\/li>\n<li>Set the attribute to innertext.<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-97\" src=\"https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/10.jpg\" alt=\"\" width=\"429\" height=\"257\" srcset=\"https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/10.jpg 429w, https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/10-300x180.jpg 300w, https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/10-18x12.jpg 18w, https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/10-50x30.jpg 50w\" sizes=\"(max-width: 429px) 100vw, 429px\" \/><\/p>\n<p>We do the same thing with information on indexed pages. The only difference is that the search option is set to \u00ab\u00a03\u00a0\u00bb. We remember that the value \u00ab\u00a02\u00a0\u00bb corresponded to the number of URLs sent.<\/p>\n<p>Now our module should look like this. I also added a 3 second interval between downloading the number of links reported and indexed.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-98\" src=\"https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/11.jpg\" alt=\"\" width=\"211\" height=\"218\" srcset=\"https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/11.jpg 211w, https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/11-12x12.jpg 12w, https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/11-48x50.jpg 48w\" sizes=\"(max-width: 211px) 100vw, 211px\" \/><\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-99\" src=\"https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/12.jpg\" alt=\"\" width=\"345\" height=\"119\" srcset=\"https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/12.jpg 345w, https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/12-300x103.jpg 300w, https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/12-18x6.jpg 18w, https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/12-50x17.jpg 50w\" sizes=\"(max-width: 345px) 100vw, 345px\" \/><\/p>\n<p>I have already created two variables:<\/p>\n<ul>\n<li>Number of links declared<\/li>\n<li>Indexed quantities<br \/>\nFor these variables, I will download the values \u200b\u200bfrom Google Search Console. We can also change our first variable which uploaded the number of links to our website. Instead of Variable0, let&rsquo;s create the variable How many links.<\/li>\n<\/ul>\n<p>Your template is finished, test it by clicking on the restart button in the main menu.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-100\" src=\"https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/13.jpg\" alt=\"\" width=\"419\" height=\"68\" srcset=\"https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/13.jpg 419w, https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/13-300x49.jpg 300w, https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/13-18x3.jpg 18w, https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/13-50x8.jpg 50w\" sizes=\"(max-width: 419px) 100vw, 419px\" \/><\/p>\n<p>Then select the Windows &gt; Variables tab from the main menu. We will see a new window with the variables we created earlier.<\/p>\n<p>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.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-101\" src=\"https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/14.jpg\" alt=\"\" width=\"407\" height=\"81\" srcset=\"https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/14.jpg 407w, https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/14-300x60.jpg 300w, https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/14-18x4.jpg 18w, https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/14-50x10.jpg 50w, https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/14-400x81.jpg 400w\" sizes=\"(max-width: 407px) 100vw, 407px\" \/><\/p>\n<p>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&rsquo;ll describe this in a few simple steps:<\/p>\n<ol>\n<li>Create a new excel file in Zennoposter by clicking on PPM in the bottom bar of the program and selecting \u00ab\u00a0Add table\u00a0\u00bb.<\/li>\n<\/ol>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-102\" src=\"https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/15.jpg\" alt=\"\" width=\"424\" height=\"235\" srcset=\"https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/15.jpg 424w, https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/15-300x166.jpg 300w, https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/15-18x10.jpg 18w, https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/15-50x28.jpg 50w\" sizes=\"(max-width: 424px) 100vw, 424px\" \/><\/p>\n<ol>\n<li>Click PPM in the workspace and select Add action &gt; Tables &gt; Table processing<\/li>\n<\/ol>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-103\" src=\"https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/16.jpg\" alt=\"\" width=\"410\" height=\"300\" srcset=\"https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/16.jpg 410w, https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/16-300x220.jpg 300w, https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/16-16x12.jpg 16w, https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/16-50x37.jpg 50w\" sizes=\"(max-width: 410px) 100vw, 410px\" \/><\/p>\n<ol>\n<li>add to which row and column the first variable should be written (Variable How many links)<\/li>\n<\/ol>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-104\" src=\"https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/17.jpg\" alt=\"\" width=\"463\" height=\"340\" srcset=\"https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/17.jpg 463w, https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/17-300x220.jpg 300w, https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/17-16x12.jpg 16w, https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/17-50x37.jpg 50w\" sizes=\"(max-width: 463px) 100vw, 463px\" \/><\/p>\n<ol>\n<li>We follow the same procedure with the reported quantity and the variables indexed by quantity. As a result, we should get the following module.<\/li>\n<\/ol>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-105\" src=\"https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/18.jpg\" alt=\"\" width=\"193\" height=\"164\" srcset=\"https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/18.jpg 193w, https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/18-14x12.jpg 14w, https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/18-50x42.jpg 50w\" sizes=\"(max-width: 193px) 100vw, 193px\" \/><\/p>\n<ol>\n<li>Launch the modules with the Play button, so that green crosses appear on the left to indicate that the task is completed.<\/li>\n<\/ol>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-106\" src=\"https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/19.jpg\" alt=\"\" width=\"184\" height=\"171\" srcset=\"https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/19.jpg 184w, https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/19-13x12.jpg 13w, https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/19-50x46.jpg 50w\" sizes=\"(max-width: 184px) 100vw, 184px\" \/><\/p>\n<ol>\n<li>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.<\/li>\n<\/ol>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-107\" src=\"https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/20.jpg\" alt=\"\" width=\"318\" height=\"365\" srcset=\"https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/20.jpg 318w, https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/20-261x300.jpg 261w, https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/20-10x12.jpg 10w, https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/20-44x50.jpg 44w\" sizes=\"(max-width: 318px) 100vw, 318px\" \/><\/p>\n<ol>\n<li>Our file appeared on the desktop, after opening it looks like this:<\/li>\n<\/ol>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-108\" src=\"https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/21.jpg\" alt=\"\" width=\"243\" height=\"130\" srcset=\"https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/21.jpg 243w, https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/21-18x10.jpg 18w, https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/21-50x27.jpg 50w\" sizes=\"(max-width: 243px) 100vw, 243px\" \/><\/p>\n<p>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 <a href=\"https:\/\/nerdax.com\/y\/formationzenno\/\" target=\"_blank\" rel=\"noopener\"><span style=\"color: #339966\"><strong>form correctly by clicking HERE. <\/strong><\/span><\/a><\/p>\n<p>It&rsquo;s below for the training \ud83d\ude42<\/p>\n<p><a href=\"https:\/\/nerdax.com\/y\/formationzenno\/\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-83\" src=\"https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/formation-zennoposter.jpeg\" alt=\"\" width=\"800\" height=\"100\" srcset=\"https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/formation-zennoposter.jpeg 800w, https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/formation-zennoposter-300x38.jpeg 300w, https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/formation-zennoposter-768x96.jpeg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/a><\/p>\n<p>To download the trial version:<\/p>\n<p><a href=\"https:\/\/nerdax.com\/y\/zenno\/\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" class=\"aligncenter size-full wp-image-84\" src=\"https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/t%C3%A9l%C3%A9charger-zennoposter.jpeg\" alt=\"\" width=\"800\" height=\"100\"><\/a><\/p>","protected":false},"excerpt":{"rendered":"<p>Automation of activities with Zennoposter. Today we will create a template that will be responsible for downloading data from Google Search Console. We&rsquo;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 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":77,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_seopress_robots_primary_cat":"","_seopress_titles_title":"","_seopress_titles_desc":"","_seopress_robots_index":"","_seopress_analysis_target_kw":"","_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[491],"tags":[],"class_list":["post-1256","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-zennoposter-en"],"wppr_data":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Zennoposter \u2013 download data from Google Search Console - Nerdax.com<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/nerdax.com\/en\/zennoposter-download-data-from-google-search-console\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Zennoposter \u2013 download data from Google Search Console - Nerdax.com\" \/>\n<meta property=\"og:description\" content=\"Automation of activities with Zennoposter. Today we will create a template that will be responsible for downloading data from Google Search Console. We&rsquo;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 [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/nerdax.com\/en\/zennoposter-download-data-from-google-search-console\/\" \/>\n<meta property=\"og:site_name\" content=\"Nerdax.com\" \/>\n<meta property=\"article:published_time\" content=\"2024-06-29T18:21:13+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-06-29T18:21:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/zennoposter-couverture.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"475\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"kaostyl\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"kaostyl\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/nerdax.com\\\/en\\\/zennoposter-download-data-from-google-search-console\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/nerdax.com\\\/en\\\/zennoposter-download-data-from-google-search-console\\\/\"},\"author\":{\"name\":\"kaostyl\",\"@id\":\"https:\\\/\\\/nerdax.com\\\/en\\\/#\\\/schema\\\/person\\\/30ede66829f168e56cb219eb83d3b0b8\"},\"headline\":\"Zennoposter \u2013 download data from Google Search Console\",\"datePublished\":\"2024-06-29T18:21:13+00:00\",\"dateModified\":\"2024-06-29T18:21:16+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/nerdax.com\\\/en\\\/zennoposter-download-data-from-google-search-console\\\/\"},\"wordCount\":1254,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/nerdax.com\\\/en\\\/zennoposter-download-data-from-google-search-console\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/nerdax.com\\\/wp-content\\\/uploads\\\/2018\\\/04\\\/zennoposter-couverture.png\",\"articleSection\":[\"Zennoposter\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/nerdax.com\\\/en\\\/zennoposter-download-data-from-google-search-console\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/nerdax.com\\\/en\\\/zennoposter-download-data-from-google-search-console\\\/\",\"url\":\"https:\\\/\\\/nerdax.com\\\/en\\\/zennoposter-download-data-from-google-search-console\\\/\",\"name\":\"Zennoposter \u2013 download data from Google Search Console - Nerdax.com\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/nerdax.com\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/nerdax.com\\\/en\\\/zennoposter-download-data-from-google-search-console\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/nerdax.com\\\/en\\\/zennoposter-download-data-from-google-search-console\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/nerdax.com\\\/wp-content\\\/uploads\\\/2018\\\/04\\\/zennoposter-couverture.png\",\"datePublished\":\"2024-06-29T18:21:13+00:00\",\"dateModified\":\"2024-06-29T18:21:16+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/nerdax.com\\\/en\\\/#\\\/schema\\\/person\\\/30ede66829f168e56cb219eb83d3b0b8\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/nerdax.com\\\/en\\\/zennoposter-download-data-from-google-search-console\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/nerdax.com\\\/en\\\/zennoposter-download-data-from-google-search-console\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/nerdax.com\\\/en\\\/zennoposter-download-data-from-google-search-console\\\/#primaryimage\",\"url\":\"https:\\\/\\\/nerdax.com\\\/wp-content\\\/uploads\\\/2018\\\/04\\\/zennoposter-couverture.png\",\"contentUrl\":\"https:\\\/\\\/nerdax.com\\\/wp-content\\\/uploads\\\/2018\\\/04\\\/zennoposter-couverture.png\",\"width\":1024,\"height\":475},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/nerdax.com\\\/en\\\/zennoposter-download-data-from-google-search-console\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/nerdax.com\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Zennoposter \u2013 download data from Google Search Console\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/nerdax.com\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/nerdax.com\\\/en\\\/\",\"name\":\"Nerdax.com\",\"description\":\"Cr\u00e9er un Site Affiliation Adulte, Rencontre, Argent internet\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/nerdax.com\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/nerdax.com\\\/en\\\/#\\\/schema\\\/person\\\/30ede66829f168e56cb219eb83d3b0b8\",\"name\":\"kaostyl\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/819e2e348cfe3b78cd4e1286be548370590867c9a451d24c3da894144e15f791?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/819e2e348cfe3b78cd4e1286be548370590867c9a451d24c3da894144e15f791?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/819e2e348cfe3b78cd4e1286be548370590867c9a451d24c3da894144e15f791?s=96&d=mm&r=g\",\"caption\":\"kaostyl\"},\"url\":\"https:\\\/\\\/nerdax.com\\\/en\\\/author\\\/kaostyl\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Zennoposter \u2013 download data from Google Search Console - Nerdax.com","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/nerdax.com\/en\/zennoposter-download-data-from-google-search-console\/","og_locale":"en_US","og_type":"article","og_title":"Zennoposter \u2013 download data from Google Search Console - Nerdax.com","og_description":"Automation of activities with Zennoposter. Today we will create a template that will be responsible for downloading data from Google Search Console. We&rsquo;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 [&hellip;]","og_url":"https:\/\/nerdax.com\/en\/zennoposter-download-data-from-google-search-console\/","og_site_name":"Nerdax.com","article_published_time":"2024-06-29T18:21:13+00:00","article_modified_time":"2024-06-29T18:21:16+00:00","og_image":[{"width":1024,"height":475,"url":"https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/zennoposter-couverture.png","type":"image\/png"}],"author":"kaostyl","twitter_card":"summary_large_image","twitter_misc":{"Written by":"kaostyl","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/nerdax.com\/en\/zennoposter-download-data-from-google-search-console\/#article","isPartOf":{"@id":"https:\/\/nerdax.com\/en\/zennoposter-download-data-from-google-search-console\/"},"author":{"name":"kaostyl","@id":"https:\/\/nerdax.com\/en\/#\/schema\/person\/30ede66829f168e56cb219eb83d3b0b8"},"headline":"Zennoposter \u2013 download data from Google Search Console","datePublished":"2024-06-29T18:21:13+00:00","dateModified":"2024-06-29T18:21:16+00:00","mainEntityOfPage":{"@id":"https:\/\/nerdax.com\/en\/zennoposter-download-data-from-google-search-console\/"},"wordCount":1254,"commentCount":0,"image":{"@id":"https:\/\/nerdax.com\/en\/zennoposter-download-data-from-google-search-console\/#primaryimage"},"thumbnailUrl":"https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/zennoposter-couverture.png","articleSection":["Zennoposter"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/nerdax.com\/en\/zennoposter-download-data-from-google-search-console\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/nerdax.com\/en\/zennoposter-download-data-from-google-search-console\/","url":"https:\/\/nerdax.com\/en\/zennoposter-download-data-from-google-search-console\/","name":"Zennoposter \u2013 download data from Google Search Console - Nerdax.com","isPartOf":{"@id":"https:\/\/nerdax.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/nerdax.com\/en\/zennoposter-download-data-from-google-search-console\/#primaryimage"},"image":{"@id":"https:\/\/nerdax.com\/en\/zennoposter-download-data-from-google-search-console\/#primaryimage"},"thumbnailUrl":"https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/zennoposter-couverture.png","datePublished":"2024-06-29T18:21:13+00:00","dateModified":"2024-06-29T18:21:16+00:00","author":{"@id":"https:\/\/nerdax.com\/en\/#\/schema\/person\/30ede66829f168e56cb219eb83d3b0b8"},"breadcrumb":{"@id":"https:\/\/nerdax.com\/en\/zennoposter-download-data-from-google-search-console\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/nerdax.com\/en\/zennoposter-download-data-from-google-search-console\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/nerdax.com\/en\/zennoposter-download-data-from-google-search-console\/#primaryimage","url":"https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/zennoposter-couverture.png","contentUrl":"https:\/\/nerdax.com\/wp-content\/uploads\/2018\/04\/zennoposter-couverture.png","width":1024,"height":475},{"@type":"BreadcrumbList","@id":"https:\/\/nerdax.com\/en\/zennoposter-download-data-from-google-search-console\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/nerdax.com\/en\/"},{"@type":"ListItem","position":2,"name":"Zennoposter \u2013 download data from Google Search Console"}]},{"@type":"WebSite","@id":"https:\/\/nerdax.com\/en\/#website","url":"https:\/\/nerdax.com\/en\/","name":"Nerdax.com","description":"Create an Adult Affiliate Site, Dating, Internet Money","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/nerdax.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/nerdax.com\/en\/#\/schema\/person\/30ede66829f168e56cb219eb83d3b0b8","name":"kaostyl","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/819e2e348cfe3b78cd4e1286be548370590867c9a451d24c3da894144e15f791?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/819e2e348cfe3b78cd4e1286be548370590867c9a451d24c3da894144e15f791?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/819e2e348cfe3b78cd4e1286be548370590867c9a451d24c3da894144e15f791?s=96&d=mm&r=g","caption":"kaostyl"},"url":"https:\/\/nerdax.com\/en\/author\/kaostyl\/"}]}},"_links":{"self":[{"href":"https:\/\/nerdax.com\/en\/wp-json\/wp\/v2\/posts\/1256","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nerdax.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nerdax.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nerdax.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/nerdax.com\/en\/wp-json\/wp\/v2\/comments?post=1256"}],"version-history":[{"count":1,"href":"https:\/\/nerdax.com\/en\/wp-json\/wp\/v2\/posts\/1256\/revisions"}],"predecessor-version":[{"id":1265,"href":"https:\/\/nerdax.com\/en\/wp-json\/wp\/v2\/posts\/1256\/revisions\/1265"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/nerdax.com\/en\/wp-json\/wp\/v2\/media\/77"}],"wp:attachment":[{"href":"https:\/\/nerdax.com\/en\/wp-json\/wp\/v2\/media?parent=1256"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nerdax.com\/en\/wp-json\/wp\/v2\/categories?post=1256"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nerdax.com\/en\/wp-json\/wp\/v2\/tags?post=1256"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}