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!)
Join My Newsletter!
Get access to my personal python scripts, GSC data visualization, analytics, insights, prompts and more!
Upcoming Topics
- Accessing Unlimited Rows of Google Search Console data from Last 16 months
- Unique Keywords Ranking
- Unique URLs Ranking
- Unique Query Count by Page
- CTR Curve
- Branded vs Non-branded Clicks & Impressions
- Keywords in GSC Impressions but missing from Page
Video Tutorial Series
1. Basics of GSC API : GCP Project Setup, Authorization, Fetching the Data
2. Accessing Last 16 Months of Data & Using Dimension Filters
3. GSC Visualizations : Unique Keywords & URLs Ranking
Coming soon! Subscribe to the Newsletter to receive the video series in the email!
What this project is all about?
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.
- 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 useful. In this case, you should look for other available resources.
I am not going to explain a secret, this is just my attempt to simply and make it more understandable so it can be widely used.
This guide will help you:
- explain the needed python code so you could use GSC API using Google Colab
- explain how to do authentication and authorization
- connect to Google Search Console API
- Access the data from more than 25000 rows(theoretically unlimited!)
- build pandas data frame so you could manipulate it
I am not sure if this will be completely free. I am seeing this in two phases.
Phase 1:
The part where you learn to operate GSC API using basic concepts of python will be free.
Also because there are already tutorials available on the web. I am just attempting to simple explanation here.
Phase 2:
If I add more advanced scripts going forward, then I might charge for that.
We will see I haven’t thought about it much, but I plan to monetize this initiative in future for sure.
13 Responses
hi i want to this app
Please sign up.
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.
Hi Adeel, I just read your comments. I do think we can achieve all three. I will cover those use cases.
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).
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.
Hello
I am very interested
Feel free to signup.
Hi Mihir, I tried to join but on click I am not getting any confirmation for registration. Could you please help
I could see you successfully subscribed. But just in case you still didn’t receive it, please checkout your spam folder.
Thanks for Sharing your Experience Naik
It going to be Solid👊
M also SEO guy, i went through ur Api, i will love to learn more about it. So can u help me regarding same?
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