For SEO analysis, I am using Google Sheets to extract basic data from my own webpages.
I am able to access page title, description,
<h1> tags, or number of characters via
=IMPORTXML(A3, "//title/text()") =IMPORTXML(A3, "//meta[@name='description']/@content") =IMPORTXML(A3, "//h1")
However, I cannot find a way to count the number of words in
<body> (excluding html tags). I am trying to identify pages with thin content for SEO.
'entry-content clr' is the part of the page that contains main content in my WP theme.