Sometimes you would require to find the number of pages in a website for a huge number of websites. For this, you can use the IMPORTXML inbuilt into Google sheets.
Steps-
- Open a Google sheet.
- In column A, enter the list of URLs for which you want to find the number of pages.
- In column B, create a site:website.com bing search URL. example, use the concatenate function for this.
- =concatenate(“https://www.bing.com/search?q=site:”,A1)
- In column C, have a IMPORTXML formula that crawls and gets the number of pages into google sheets.
- =IMPORTXML(B2, “//span[@class=’sb_count’]”)