Jose Luis Hernando

Been meaning to revisit a few of my old projects and this is the first (public) one I wanted to do so. Presenting. --> Google Index Checker 2.0 web app. jlhernando.com/blog/google-in… Login with your Google account, choose your property, paste the urls and get the results. Enjoy!

If you already live in Google Sheets, Apps Script is the natural next step into automation. Same tool, no setup. Custom formulas, scheduled reports, BigQuery queries. All inside the spreadsheet you and your team already use. This is the intro I wish I had when I got started. jlhernando.com/blog/intro-goo… #seo #automation

@GastonRiera Gracias :) Estas cosas se salen fuera de la zona de control asi que mejor seguir para adelante y ya se vera

@jlhernando shit, adevinta being acquired... That's big. Ojalá vos, tu equipo y los equipos con los que trabajas estén a salvo, siempre que hay una acquisition hay team shuffles or layoffs

Recently we had to migrate our GSC bulk data export to a completely different GCP project after Adevinta Spain was acquired by EQT Group. I couldn't find much info in the official docs about this specific scenario, so together with the data engineering team we worked out a process that kept every day of data intact and it's now running without issue in our infra. I've put together a guide with the full steps we followed in case anyone runs into the same thing. jlhernando.com/blog/gsc-bulk-…

@GastonRiera @googlesearchc @JohnMu @danielwaisberg Seems like it fixed itself and the data has been back filled. Trust in the system restored 😜

@jlhernando @googlesearchc @JohnMu José, just FYI I doubt they'll respond over twitter. You have better chances over Linkedin or bluesky Also, for GSC situations your best point of contact is @danielwaisberg ;)

@googlesearchc @JohnMu I'm seeing an issue with url_impression bulk export tables missing 2 days. However i got the data from 2 days ago... site_impression tables are fine. Nothing has changeed from our end. Any issue detected from GSC? Any chance this data will be backfilled?

SEO Automation is more accesible than ever. If you know me, you know I have a clear favourite (despite its reputation in SEO...) JavaScript! I wrote about how easy and practical it is to get started. Browser, Nodejs or Apps Script. Choose you own adventure! jlhernando.com/blog/javascrip…

"LLMs favor content that does X" is not a thing! LLMs don't favor anything. They're not information retrieval systems; they're next-token predictors. They guess the most statistically likely response based on patterns in training data. The search engine layer bolted on top via RAG? That's IR (Information Retrieval)!! The base LLM model? Not even close. During training, LLMs process text from across the web, but they don't log URLs, store sources, or remember where anything came from. What's left is a frozen statistical snapshot (Gao et al., 2023). Not an index. Not a database. Search engines do the crawling, indexing, and retrieval. LLMs lean on them heavily to surface real-time info (because on their own, they can't). Stop optimizing for 'AI.' Optimize for search engines (so retrieval-based AI can cite you) + earn third-party coverage (so the model already knows you before the prompt is typed).

@Marc0dev Nice, sounds like a good automation! Did you open source it?

gsc has insane data locked behind a ui from 2015. one click extraction is smart. i went a step further and connected an agent directly to the gsc api so it pulls index status, rankings, and gaps all in one conversation. the manual clicking through properties is the part that should've been automated years ago.

Made a chrome extension to grab all Index status data from your Google Search Console in one click, for all your properties. Couldn't do a big write up explaining (it was my birthday on Sunday 😅) but i've tried to put all the essentials there. jlhernando.com/blog/gsc-index… Toodles!

@MontseCano Gracias Montse!

@jlhernando Happy belated birthday!

@antoineripret next in the pipeline is Dataform (now in easy mode😬)

If you ever wanted to get into SEO automation this is the time. Go wild! My new stack for SEO Automation: Claude Code + Apps Script jlhernando.com/blog/claude-co…

I like Search Console’s Compare view. BUT I hate doing the maths in the UI. So I built a tiny Chrome extension that overlays absolute and % change directly on the scorecards. No more mental calculations or spreadsheets. Try it. Let me know! jlhernando.com/blog/search-co…

@estevecastells Careful you might be reported to AIHR

Working with AI in 2025:

Hola SEOs! Anyone else seeing 22nd of Apr as the latest available date in Bulk Export? @estevecastells @antoineripret @JohnMu @danielwaisberg @rustybrick #seo #searchconsole

@estevecastells Esa es la manera de empezar un proyecto nuevo si señor!

Esta @jlhernando se la sabe 🤣 SQL powah!

Cuando tu nuevo cliente con 5 millones de URLs con tráfico tiene exportados más de 500 días de GSC BigQuery Bulk Export

@stonetatara New version shipped 🚀 Wanted to make some improvements to the login process since I was already touching the code. LMK if you run into any issues again.

@jlhernando Niiiiice ! 😃 I hadn't thought of creating several properties: that's a good idea. Thank you to you to answer my requests🙏 We keep in touch!

@jlhernando Hi, I've some question about your script jlhernando.com/blog/index-cov… Possible to talk about? #Thx !

@stonetatara Found the bug. I've made a few fixes in the code. I'll push it tomorrow. The script will allow you to get more than 1000 URLs if you create multiple GSC properties/paths for the same domain. This has given me some ideas for future scripts so thank you.

@jlhernando Last but not least, in the converage csv, I have only 1000 rows: I believed the script extracted more than 1000 rows. Have I misunderstood? Thx

@stonetatara Hi! Yeah I hope I can take a look over the weekend and see if we can nail the issue

@jlhernando Hi, I tested it again, I keep having the same problem: Do you see my last request on your Git repositery? Thank you so much!