Xpath to extract resultStats from Google SERP

[paolobi]

Hello guys,
I'm trying to extract the results stats from a Google search engine results page. With "results stats" I mean the value inside the red box in the image above.

I'm using this formula XPathOnUrl(D1;"//div[@id='resultStats']/text()";"div") - where D1 contains the serp's URL - but I have back an empty cell. Can you help me?

Thank you very much

[nielsbosma]

This is exactly what the googleresults connector is doing: https://seotoolsforexcel.com/google-search/

[WolfeDen]

Leave the attribute param blank - try this instead:

XPathOnUrl(D1; "//div[@id='resultStats']/text()"; "")