How to automate finding number of pages in a website using Bing and IMPORTXML

google sheets / By

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-

  1. Open a Google sheet.
  2. In column A, enter the list of URLs for which you want to find the number of pages.
  3. 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)
  4. In column C, have a IMPORTXML formula that crawls and gets the number of pages into google sheets.
    • =IMPORTXML(B2, “//span[@class=’sb_count’]”)