I’m working on a specific use case and could use some advice.
If you’ve worked with Google Search Console reports, you know how much time it takes to download and analyze them manually. I have to generate multiple reports regularly, and I was wondering —
👉 Is there a way to schedule Google Search Console report downloads automatically,👉 extract key metrics like:
- Number of keywords containing a specific term (e.g., “dentist”)
- Clicks generated by those keywords
- Average position
…and then send all that data automatically to a Google Doc or Sheet?
If anyone has done something similar — maybe using n8n, and the Search Console API — I’d really appreciate some guidance or examples! 🙏