GSC is one of the most valuable resources for anyone concerned with organic traffic and content optimization.
Part 1: Used to connect and run a sample query
- Free sourcecode for part 1
- Video tutorial (Free with email registration): https://datawinners.gumroad.com/l/gsc_to_bq
- Group support available (with paid upgrade on Gumroad and Discord Server)
- First Twitter announcement https://twitter.com/alton_lex/status/1611252976903139330
- Part 2 will include how to save directly to BigQuery
- Part 3 will be about automation
- Part 4 will have examples of reports in Looker
How to configure authorization https://developers.google.com/webmaster-tools/v1/how-tos/authorizing
Alternative basic end to end python example https://www.shortautomaton.com/gsc-search-analytics-all-rows/
An alternative method for connecting to GCP API https://seogreetings.com/blogs/news/use-google-inspect-url-api-with-python-to-inspect-urls-in-bulk
How to query your google search console analytics data https://developers.google.com/webmaster-tools/v1/how-tos/search_analytics
More samples of using the google api https://github.com/googleapis/google-api-python-client/tree/main/samples/searchconsole