Google Sheets: word count for a webpage content (url) for SEO

by Alfred Wallace   Last Updated August 01, 2020 10:03 AM - source

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 LEN():

=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.

Answers 1

=importxml(A4,"//div[@class='entry-content clr']")

'entry-content clr' is the part of the page that contains main content in my WP theme.

Priit Kallas
Priit Kallas
March 04, 2020 07:48 AM

Related Questions

Google Sheets + ImportXML

Updated September 17, 2018 20:03 PM

IMPORT XML not updating for unknown reason, any ideas?

Updated February 24, 2019 05:03 AM

How to match XPath for Sheets IMPORTXML formula?

Updated June 21, 2018 21:03 PM

Help me with a importxml query

Updated October 26, 2018 11:03 AM

Get URL from web page using IMPORTXML

Updated January 22, 2019 11:03 AM