Web scraping Google Play Books with Nodejs
Tags: webscraping, node, serpapi, google
Published: 2022-10-31 16:41:54

<h2 id='what'>What will be scraped</h2>

![what](https://user-images.githubusercontent.com/64033139/193826526-21746ac6-f42c-476c-b4a0-93ce07889851.png)

<h2 id='full_code'>Full code</h2>

If you don't need an explanation, have a look at [the full code example in the online IDE](https://replit.com/@MikhailZub/Scrape-Google-Play-Books-with-NodeJS-SerpApi#withPuppeteer.js)

```javascript
const puppeteer = require("puppeteer-extra");
const StealthPlugin = require("puppeteer-extra-plugin-stealth");

puppeteer.use(StealthPlugin());

const searchParams = {
  hl: "en", // Parameter defines the language to use for the Google search
  gl: "us", // parameter defines the country to use for the Google search
  device: "phone", // parameter defines the search device. Options: phone, tablet, tv, chromebook
  category: null, // you can see the full list of supported categories on https://serpapi.com/google-play-books-categories
};

const URL = searchParams.category
  ? `https://play.google.com/store/books/category/${searchParams.category}?hl=${searchParams.hl}&gl=${searchParams.gl}&device=${searchParams.device}`
  : `https://play.google.com/store/books?hl=${searchParams.hl}&gl=${searchParams.gl}&device=${searchParams.device}`;

async function scrollPage(page, scrollContainer) {
  let lastHeight = await page.evaluate(`document.querySelector("${scrollContainer}").scrollHeight`);
  while (true) {
    await page.evaluate(`window.scrollTo(0, document.querySelector("${scrollContainer}").scrollHeight)`);
    await page.waitForTimeout(4000);
    let newHeight = await page.evaluate(`document.querySelector("${scrollContainer}").scrollHeight`);
    if (newHeight === lastHeight) {
      break;
    }
    lastHeight = newHeight;
  }
}

async function getBooksFromPage(page) {
  const books = await page.evaluate(() => {
    const mainPageInfo = Array.from(document.querySelectorAll("section .oVnAB")).reduce((result, block) => {
      const categoryTitle = block.querySelector(".kcen6d").textContent.trim();
      const books = Array.from(block.parentElement.querySelectorAll(".ULeU3b")).map((book) => {
        const link = `https://play.google.com${book.querySelector(".Si6A0c")?.getAttribute("href")}`;
        const bookId = link.slice(link.indexOf("?id=") + 4);
        return {
          title: book.querySelector(".hP61id div:first-child")?.getAttribute("title"),
          link,
          rating: parseFloat(book.querySelector(".LrNMN[aria-label]")?.getAttribute("aria-label").slice(6, 9)) || "No rating",
          originalPrice: book.querySelector(".LrNMN .SUZt4c")?.textContent.trim(),
          price: book.querySelector(".LrNMN .VfPpfd")?.textContent.trim(),
          thumbnail: book.querySelector(".TjRVLb img")?.getAttribute("srcset").slice(0, -3),
          bookId,
        };
      });
      return {
        ...result,
        [categoryTitle]: books,
      };
    }, {});

    return mainPageInfo;
  });
  return books;
}

async function getMainPageInfo() {
  const browser = await puppeteer.launch({
    headless: true, // if you want to see what the browser is doing, you need to change this option to "false"
    args: ["--no-sandbox", "--disable-setuid-sandbox"],
  });

  const page = await browser.newPage();

  await page.setDefaultNavigationTimeout(60000);
  await page.goto(URL);

  await page.waitForSelector(".oVnAB");

  await scrollPage(page, ".T4LgNb");

  const books = await getBooksFromPage(page);

  await browser.close();

  return books;
}

getMainPageInfo().then((result) => console.dir(result, { depth: null }));
```

<h2 id='preparation'>Preparation</h2>

First, we need to create a Node.js\* project and add [`npm`](https://www.npmjs.com/) packages [`puppeteer`](https://www.npmjs.com/package/puppeteer), [`puppeteer-extra`](https://www.npmjs.com/package/puppeteer-extra) and [`puppeteer-extra-plugin-stealth`](https://www.npmjs.com/package/puppeteer-extra-plugin-stealth) to control Chromium (or Chrome, or Firefox, but now we work only with Chromium which is used by default) over the [DevTools Protocol](https://chromedevtools.github.io/devtools-protocol/) in [headless](https://developers.google.com/web/updates/2017/04/headless-chrome) or non-headless mode.

To do this, in the directory with our project, open the command line and enter `npm init -y`, and then `npm i puppeteer puppeteer-extra puppeteer-extra-plugin-stealth`.

\*<span style="font-size: 15px;">If you don't have Node.js installed, you can [download it from nodejs.org](https://nodejs.org/en/) and follow the installation [documentation](https://nodejs.dev/learn/introduction-to-nodejs).</span>

📌Note: also, you can use `puppeteer` without any extensions, but I strongly recommended use it with `puppeteer-extra` with `puppeteer-extra-plugin-stealth` to prevent website detection that you are using headless Chromium or that you are using [web driver](https://www.w3.org/TR/webdriver/). You can check it on [Chrome headless tests website](https://intoli.com/blog/not-possible-to-block-chrome-headless/chrome-headless-test.html). The screenshot below shows you a difference.

![stealth](https://user-images.githubusercontent.com/64033139/173014238-eb8450d7-616c-42ae-8b2f-24eeb5fd5916.png)

<h2 id='process'>Process</h2>

First of all, we need to scroll through all books listings until there are no more listings loading which is the difficult part described below.

The next step is to extract data from HTML elements after scrolling is finished. The process of getting the right CSS selectors is fairly easy via [SelectorGadget Chrome extension](https://selectorgadget.com/) which able us to grab CSS selectors by clicking on the desired element in the browser. However, it is not always working perfectly, especially when the website is heavily used by JavaScript.

We have a dedicated [Web Scraping with CSS Selectors](https://serpapi.com/blog/web-scraping-with-css-selectors-using-python/#css_gadget) blog post at SerpApi if you want to know a little bit more about them.

The Gif below illustrates the approach of selecting different parts of the results using SelectorGadget.

![how](https://user-images.githubusercontent.com/64033139/193826825-8e8c4e21-10f3-4e49-8486-0a86f1034edc.gif)

<h3 id='code_explanation'>Code explanation</h3>

Declare [`puppeteer`](https://www.npmjs.com/package/puppeteer-extra) to control Chromium browser from `puppeteer-extra` library and [`StealthPlugin`](https://www.npmjs.com/package/puppeteer-extra-plugin-stealth) to prevent website detection that you are using [web driver](https://www.w3.org/TR/webdriver/) from `puppeteer-extra-plugin-stealth` library:

```javascript
const puppeteer = require("puppeteer-extra");
const StealthPlugin = require("puppeteer-extra-plugin-stealth");
```

Next, we "say" to `puppeteer` use `StealthPlugin`, write the necessary request parameters and search URL using [ternary operator](https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Operators/Conditional_Operator) (the URL may differ depending on whether the category is specified):

```javascript
const searchParams = {
  hl: "en", // Parameter defines the language to use for the Google search
  gl: "us", // parameter defines the country to use for the Google search
  device: "phone", // parameter defines the search device. Options: phone, tablet, tv, chromebook
  category: null, // you can see the full list of supported categories on https://serpapi.com/google-play-books-categories
};

const URL = searchParams.category
  ? `https://play.google.com/store/books/category/${searchParams.category}?hl=${searchParams.hl}&gl=${searchParams.gl}&device=${searchParams.device}`
  : `https://play.google.com/store/books?hl=${searchParams.hl}&gl=${searchParams.gl}&device=${searchParams.device}`;
```

If the `category` parameter is set to null, that means we use the default category (Ebooks) and the URL will look like this:

```javascript
"https://play.google.com/store/books?hl=en&gl=US";
```

Otherwise, the URL will look like this:

```javascript
"https://play.google.com/store/books/category/coll_1665?hl=en&gl=US";
```

The URL only changes when a category needs to be applied:
![GIF](https://user-images.githubusercontent.com/78694043/193994024-288bb3d0-659f-4ee6-bf34-cc3da05167fb.gif)

[The full list of supported categories](https://serpapi.com/google-play-books-categories) looks like:

```json
{
  "coll_1665": {
    "section": "Books",
    "html_structure": "rows",
    "category": "Arts & entertainment"
  },
  "subj_Art___Humor.AH_Art": {
    "section": "Books",
    "html_structure": "list",
    "category": "Arts & entertainment",
    "subcategory": "Art"
  },
  "subj_Art___Humor.AH_Drama": {
    "section": "Books",
    "html_structure": "list",
    "category": "Arts & entertainment",
    "subcategory": "Drama"
  },
  "subj_Art___Humor.AH_Humor": {
    "section": "Books",
    "html_structure": "list",
    "category": "Arts & entertainment",
    "subcategory": "Humor"
  },
  "subj_Art___Humor.AH_Music": {
    "section": "Books",
    "html_structure": "list",
    "category": "Arts & entertainment",
    "subcategory": "Music"
  },
  ...and other categories
}
```

Next, we write a function to scroll the page to load all the articles:

```javascript
async function scrollPage(page, scrollContainer) {
  ...
}
```

In this function, first, we need to get `scrollContainer` height (using [`evaluate()`](https://pptr.dev/api/puppeteer.page.evaluate) method). Then we use `while` loop in which we scroll down `scrollContainer`, wait 2 seconds (using [`waitForTimeout`](https://pptr.dev/api/puppeteer.page.waitfortimeout) method), and get a new `scrollContainer` height.

Next, we check if `newHeight` is equal to `lastHeight` we stop the loop. Otherwise, we define `newHeight` value to `lastHeight` variable and repeat again until the page was not scrolled down to the end:

```javascript
let lastHeight = await page.evaluate(`document.querySelector("${scrollContainer}").scrollHeight`);
while (true) {
  await page.evaluate(`window.scrollTo(0, document.querySelector("${scrollContainer}").scrollHeight)`);
  await page.waitForTimeout(4000);
  let newHeight = await page.evaluate(`document.querySelector("${scrollContainer}").scrollHeight`);
  if (newHeight === lastHeight) {
    break;
  }
  lastHeight = newHeight;
}
```

Next, we write a function to get books data from the page:

```javascript
async function getBooksFromPage(page) {
  ...
}
```

In this function, we get information from the page context and save it in the returned object. Next, we need to get all HTML elements with `"section .oVnAB"` selector ([`querySelectorAll()`](https://developer.mozilla.org/en-US/docs/Web/API/Document/querySelectorAll) method). Then we use [`reduce()`](https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Array/reduce) method (it's allow to make the object with results) to iterate an array that built with [`Array.from()`]() method:

```javascript
const books = await page.evaluate(() => {
  const mainPageInfo = Array.from(document.querySelectorAll("section .oVnAB")).reduce((result, block) => {
      ...
    }, {});

    return mainPageInfo;
});
return books;
```

And finally, we need to get `categoryTitle`, and `title`, `link`, `rating`, `originalPrice`, `price`, `thumbnail` and `bookId`(we can cut it from`link` using [`slice()`](https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/String/slice) and [`indexOf()`](https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/String/indexOf) methods) of each app from the selected category ([`querySelectorAll()`](https://developer.mozilla.org/en-US/docs/Web/API/Document/querySelectorAll), [`querySelector()`](https://developer.mozilla.org/en-US/docs/Web/API/Document/querySelector), [`getAttribute()`](https://developer.mozilla.org/en-US/docs/Web/API/Element/getAttribute), [`textContent`](https://developer.mozilla.org/en-US/docs/Web/API/Node/textContent) and [`trim()`](https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/String/trim) methods.

On each itaration step we return previous step result (using [`spread syntax`](https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Operators/Spread_syntax)) and add the new category with name from `categoryTitle` constant:

```javascript
const categoryTitle = block.querySelector(".kcen6d").textContent.trim();
const books = Array.from(block.parentElement.querySelectorAll(".ULeU3b")).map((book) => {
  const link = `https://play.google.com${book.querySelector(".Si6A0c")?.getAttribute("href")}`;
  const bookId = link.slice(link.indexOf("?id=") + 4);
  return {
    title: book.querySelector(".hP61id div:first-child")?.getAttribute("title"),
    link,
    rating: parseFloat(book.querySelector(".LrNMN[aria-label]")?.getAttribute("aria-label").slice(6, 9)) || "No rating",
    originalPrice: book.querySelector(".LrNMN .SUZt4c")?.textContent.trim(),
    price: book.querySelector(".LrNMN .VfPpfd")?.textContent.trim(),
    thumbnail: book.querySelector(".TjRVLb img")?.getAttribute("srcset").slice(0, -3),
    bookId,
  };
});
return {
  ...result,
  [categoryTitle]: books,
};
```

Next, write a function to control the browser, and get information:

```javascript
async function getMainPageInfo() {
  ...
}
```

In this function first we need to define `browser` using `puppeteer.launch({options})` method with current `options`, such as `headless: true` and `args: ["--no-sandbox", "--disable-setuid-sandbox"]`.

These options mean that we use [headless](https://developers.google.com/web/updates/2017/04/headless-chrome) mode and array with [arguments](https://peter.sh/experiments/chromium-command-line-switches/) which we use to allow the launch of the browser process in the online IDE. And then we open a new `page`:

```javascript
const browser = await puppeteer.launch({
  headless: true, // if you want to see what the browser is doing, you need to change this option to "false"
  args: ["--no-sandbox", "--disable-setuid-sandbox"],
});

const page = await browser.newPage();
```

Next, we change default ([30 sec](https://github.com/puppeteer/puppeteer/blob/2a0eefb99f0ae00dacc9e768a253308c0d18a4c3/src/common/TimeoutSettings.ts#L17)) time for waiting for selectors to 60000 ms (1 min) for slow internet connection with [`.setDefaultNavigationTimeout()`](https://pptr.dev/api/puppeteer.page.setdefaultnavigationtimeout) method, go to `URL` with [`.goto()`](https://pptr.dev/api/puppeteer.page.goto) method and use [`.waitForSelector()`](https://pptr.dev/api/puppeteer.page.waitforselector) method to wait until the selector is load:

```javascript
await page.setDefaultNavigationTimeout(60000);
await page.goto(URL);
await page.waitForSelector(".oVnAB");
```

And finally, we wait until the page was scrolled, save books data from the page in the `books` constant, close the browser, and return the received data:

```javascript
await scrollPage(page, ".T4LgNb");

const books = await getBooksFromPage(page);

await browser.close();

return books;
```

Now we can launch our parser:

```bash
$ node YOUR_FILE_NAME # YOUR_FILE_NAME is the name of your .js file
```

<h2 id='output'>Output</h2>

```json
{
   "Start a new series":[
      {
         "title":"Magic Lessons: The Prequel to Practical Magic",
         "link":"https://play.google.com/store/books/details/Alice_Hoffman_Magic_Lessons?id=sejNDwAAQBAJ",
         "rating":4.7,
         "price":"$12.99",
         "thumbnail":"https://books.google.com/books/publisher/content/images/frontcover/sejNDwAAQBAJ?fife=w512-h512",
         "bookId":"sejNDwAAQBAJ"
      },
      ... and other results
   ],
   "New to rent":[
      {
         "title":"The Forever War",
         "link":"https://play.google.com/store/books/details/Joe_Haldeman_The_Forever_War?id=SUFOBQAAQBAJ",
         "rating":4.5,
         "originalPrice":"$2.99",
         "price":"$2.69",
         "thumbnail":"https://books.google.com/books/publisher/content/images/frontcover/SUFOBQAAQBAJ?fife=w512-h512",
         "bookId":"SUFOBQAAQBAJ"
      },
      ... and other results
   ],
   ... and other categories
}
```

<h2 id='serp_api'>Using<a href="https://serpapi.com/google-play-books"> Google Play Books Store API </a>from SerpApi</h2>

This section is to show the comparison between the DIY solution and our solution.

The biggest difference is that you don't need to create the parser from scratch and maintain it.

There's also a chance that the request might be blocked at some point from Google, we handle it on our backend so there's no need to figure out how to do it yourself or figure out which CAPTCHA, proxy provider to use.

First, we need to install [`google-search-results-nodejs`](https://www.npmjs.com/package/google-search-results-nodejs):

```bash
npm i google-search-results-nodejs
```

Here's the [full code example](https://replit.com/@MikhailZub/Scrape-Google-Play-Books-with-NodeJS-SerpApi#withSerpApi.js), if you don't need an explanation:

```javascript
const SerpApi = require("google-search-results-nodejs");
const search = new SerpApi.GoogleSearch(process.env.API_KEY); //your API key from serpapi.com

const params = {
  engine: "google_play", // search engine
  gl: "us", // parameter defines the country to use for the Google search
  hl: "en", // parameter defines the language to use for the Google search
  store: "books", // parameter defines the type of Google Play store
  store_device: "phone", // parameter defines the search device. Options: phone, tablet, tv, chromebook, watch, car
  // if you need to find books from one of the categories you need to uncomment the "books_category" parameter
  // books_category: "audiobooks", // you can see the full list of supported categories on https://serpapi.com/google-play-books-categories
};

const getJson = () => {
  return new Promise((resolve) => {
    search.json(params, resolve);
  });
};

const getResults = async () => {
  const json = await getJson();
  const booksResults = json.organic_results.reduce((result, category) => {
    const { title: categoryTitle, items } = category;
    const books = items.map((book) => {
      const { title, link, rating = "No rating", original_price, price, thumbnail, product_id } = book;
      const returnedBook = {
        title,
        link,
        rating,
        price,
        thumbnail,
        movieId: product_id,
      };
      if (original_price) returnedBook.originalPrice = original_price;
      return returnedBook;
    });
    return {
      ...result,
      [categoryTitle]: books,
    };
  }, {});
  return booksResults;
};

getResults().then((result) => console.dir(result, { depth: null }));
```

<h3 id='serp_api_code_explanation'>Code explanation</h3>

First, we need to declare `SerpApi` from [`google-search-results-nodejs`](https://www.npmjs.com/package/google-search-results-nodejs) library and define new `search` instance with your API key from [SerpApi](https://serpapi.com/manage-api-key):

```javascript
const SerpApi = require("google-search-results-nodejs");
const search = new SerpApi.GoogleSearch(API_KEY);
```

Next, we write the necessary parameters for making a request (if you want to set search category you need to uncomment the `books_category` parameter):

```javascript
const params = {
  engine: "google_play", // search engine
  gl: "us", // parameter defines the country to use for the Google search
  hl: "en", // parameter defines the language to use for the Google search
  store: "books", // parameter defines the type of Google Play store
  store_device: "phone", // parameter defines the search device. Options: phone, tablet, tv, chromebook, watch, car
  // if you need to find books from one of the categories you need to uncomment the "books_category" parameter
  // books_category: "audiobooks", // you can see the full list of supported categories on https://serpapi.com/google-play-books-categories
};
```

[The full list of supported categories](https://serpapi.com/google-play-books-categories) looks like:

```json
{
  "coll_1665": {
    "section": "Books",
    "html_structure": "rows",
    "category": "Arts & entertainment"
  },
  "subj_Art___Humor.AH_Art": {
    "section": "Books",
    "html_structure": "list",
    "category": "Arts & entertainment",
    "subcategory": "Art"
  },
  "subj_Art___Humor.AH_Drama": {
    "section": "Books",
    "html_structure": "list",
    "category": "Arts & entertainment",
    "subcategory": "Drama"
  },
  "subj_Art___Humor.AH_Humor": {
    "section": "Books",
    "html_structure": "list",
    "category": "Arts & entertainment",
    "subcategory": "Humor"
  },
  "subj_Art___Humor.AH_Music": {
    "section": "Books",
    "html_structure": "list",
    "category": "Arts & entertainment",
    "subcategory": "Music"
  },
  ...and other categories
}
```

Next, we wrap the search method from the SerpApi library in a promise to further work with the search results:

```javascript
const getJson = () => {
  return new Promise((resolve) => {
    search.json(params, resolve);
  });
};
```

And finally, we declare the function `getResult` that gets data from the page and return it:

```javascript
const getResults = async () => {
  ...
};
```

In this function first, we get `json` with results, then we need to iterate `organic_results` array in the received `json`. To do this we use [`reduce()`](https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Array/reduce) method (it's allow to make the object with results). On each itaration step we return previous step result (using [`spread syntax`](https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Operators/Spread_syntax)) and add the new category with name from `categoryTitle` constant:

```javascript
  const json = await getJson();
  const booksResults = json.organic_results.reduce((result, category) => {
    ...
    return {
      ...result,
      [categoryTitle]: books,
    };
  }, {});
  return booksResults;
```

Next, we destructure `category` element, redefine `title` to `categoryTitle` constant, and itarate the `items` array to get all books from this category. To do this we need to destructure the `book` element, set default value "No rating" for `rating` and return this constants:

```javascript
const { title: categoryTitle, items } = category;
const books = items.map((book) => {
  const { title, link, rating = "No rating", original_price, price, thumbnail, product_id } = book;
  const returnedBook = {
    title,
    link,
    rating,
    price,
    thumbnail,
    movieId: product_id,
  };
  if (original_price) returnedBook.originalPrice = original_price;
  return returnedBook;
});
```

After, we run the `getResults` function and print all the received information in the console with the [`console.dir`](https://nodejs.org/api/console.html#consoledirobj-options) method, which allows you to use an object with the necessary parameters to change default output options:

```javascript
getResults().then((result) => console.dir(result, { depth: null }));
```

<h2 id='serp_api_output'>Output</h2>

```json
{
   "New releases":[
      {
         "title":"The Golden Enclaves: A Novel",
         "link":"https://play.google.com/store/books/details/Naomi_Novik_The_Golden_Enclaves?id=7qBSEAAAQBAJ",
         "rating":4.7,
         "price":"$13.99",
         "thumbnail":"https://books.google.com/books/publisher/content/images/frontcover/7qBSEAAAQBAJ?fife=w256-h256",
         "movieId":"7qBSEAAAQBAJ"
      },
        ... and other results
   ],
   "Advice for a better life":[
      {
         "title":"How to Stop Feeling Like Sh*t: 14 Habits that Are Holding You Back from Happiness",
         "link":"https://play.google.com/store/books/details/Andrea_Owen_How_to_Stop_Feeling_Like_Sh_t?id=ekfiDQAAQBAJ",
         "rating":4.4,
         "price":"$11.99",
         "thumbnail":"https://books.google.com/books/publisher/content/images/frontcover/ekfiDQAAQBAJ?fife=w256-h256",
         "movieId":"ekfiDQAAQBAJ"
      },
        ... and other results
   ],
   ... and other categories
}
```

<h2 id='links'>Links</h2>

- [Code in the online IDE](https://replit.com/@MikhailZub/Scrape-Google-Play-Books-with-NodeJS-SerpApi#index.js)
- [Google Play Movies Store API](https://serpapi.com/google-play-books)

If you want to see some projects made with SerpApi, [write me a message](mailto:miha01012019@gmail.com).

---

<p style="text-align: center;">Join us on <a href="https://twitter.com/serp_api">Twitter</a> | <a href="https://www.youtube.com/channel/UCUgIHlYBOD3yA3yDIRhg_mg">YouTube</a></p>
<p style="text-align: center;">Add a  <a href="https://github.com/serpapi/public-roadmap/issues">Feature Request</a>💫 or a <a href="https://github.com/serpapi/public-roadmap/issues">Bug</a>🐞</p>