Accessing Google Search Console API using Python

  • Get started with GSC API using ready python scripts.
  • Develop full understanding with clear explanations.
  • Uncover 25k+ rows with few lines of code.
  • Data Visualizations never seen before.
  • Continuous addition of scripts(hopefully!)
Mihir Naik Landing Page Image

Join My Newsletter!

Get access to my personal python scripts, GSC data visualization, analytics, insights, prompts and more!

cropped-Mihir-Naik-SEO-Consulting-e1621823981974.png

Project Details

I have personally gotten frustrated a lot with understanding different pieces like Google Developer Console, Cloud Projects, Google Search Console API, Request Body, Authentication, Authorization, learning python and much more!

These challenges made me spend more time on figuring out how to access the GSC data, and less time on creative problem-solving I could do using this data. I am sure, you are also likely facing similar struggles.

I truly believe you should be armed with easy access to Google Search Console data so that you can use it the way you like in your analysis, discovery and soluting.

Is this for you?

If you are a beginner at learning GSC API.

  • You want to access GSC API but you find it too complex.
  • You know the limitation of GSC UI and/or Data Studio.
  • You want to access more than 25k rows of data.
  • You want to learn to build visualizations on top of GSC data.

 

If you already know how to connect to GSC API and make calls with pagination then you won’t find this helpful. In this case, you should look for other available resources. 

I am not going to explain any secrets, this is my attempt to simply make it more understandable so it can be widely used.

Will this be FREE?

I see two parts to this.

One part:

There are simple Python scripts that help you analyze and visualize GSC data. This will always remain free. The scripts are and will be available in my Github Repositories.

The other part:

If I add more advanced scripts going forward, then I might offer you those scripts somewhere between $9-$49. 

We will see I haven’t thought about it much, but I plan to monetize this initiative in future for sure.

Video Tutorial Series

1. Basics of GSC API : GCP Project Setup, Authorization, Fetching the Data

Play Video

2. Accessing Last 16 Months of Data & Using Dimension Filters

Play Video

3. Plot Unique Query Count & URL Count By Date

Play Video

4. Visualize Branded vs Non-Branded Queries 🚀

Play Video

5. Organic CTR Curve for Brand vs Non-Brand Queries

Play Video

6. Check the Indexing Status of Sitemap URLs in Bulk - GSC URL Inspection API

Play Video about How to Check Indexing Status of Sitemap URLs in Bulk using GSC URL Inspection API?

Share Your Feedback Here!

15 Responses

  1. Hi.

    I am deeply interested in becoming a part of this.

    I would also suggest adding API to:

    1 – Compare brand VS non brand query trends

    2 – page level query trends over time

    3 – page level query trends for too 20 position over last 16 months (or since GSC was active.

  2. I know there´s a few working scripts out there that leverage the benefits of the GSC API integration but one of my biggest pain points is despite all that documentation I haven´t been able to troubleshoot some issues with the API (not the script).

    1. I understand, that’s exactly why I thought to make this video series. Honestly, I was in the same place as you but I figure it out. I think I can save countless hours if everyone knows how to do it easily, in one go.

  3. M also SEO guy, i went through ur Api, i will love to learn more about it. So can u help me regarding same?

  4. Hi,
    I’m always struggling with authentication.
    Further I’d like to know of it’s possible to easily compare metrics across different properties.

    Best,
    Seb

  5. hello, have a nice day, thanks for your videos, it’s amazing, i just wanted to say, i’m from vietnam. I would like to ask if there is a way to render Crawl stats in GSC, especially
    Crawl requests: Moved permanently (301), I’m often being harassed by my opponent, so I often come here to find 301 links and check the url back to see which domains are referred, I want to extract the domains that cause the problem. that status. Do you have a similar guide? Thank you !

  6. Thank you for the great tutorials. How can we export large data from GSC into Bigquery. Writing to Excel is not possible because of the big size

Leave a Reply

Your email address will not be published. Required fields are marked *