Google Sheets
Google Sheets
Autobook Icon
Save Amazon best seller products to Google Sheets
Google Sheets
Save Amazon best seller products to Google Sheets
Save Amazon best seller products to Google Sheets
Save Amazon best seller products to Google Sheets

Save Amazon best seller products to Google Sheets

This playbook will extract a list of products from Amazon best sellers page and save the data to Google Sheets.

Bardeen automates your repetitive tasks without code.
Install the Chrome extension for free.

The first step to making sales and earning customers is offering something people want. Doing this almost always comes down to doing good research. The Amazon best sellers page can help you identify the most in-demand products in any category or subcategory.

And this automation will be your secret weapon!

It will extract the list of products from an Amazon best sellers page and save them into a Google Sheets spreadsheet with information like price, link to the product, and product name.

Looking at a best sellers page isn't enough to show you trends on a large scale. For more long-term insights, you'll want to use more sophisticated methods to get deeper into the data. 

With Google Sheets, you can create customized charts and views that take the category, average price, and product type into account, turning the data into sophisticated reports that will help you make sound decisions.

You can also track how prices change over time to give you more insight into trends for a specific category.

Let’s set the automation up!

Step 1: Pin the playbook and integrate Google Sheets

First, click the “Pin it” button at the top of this page to save this automation. You will be redirected to download the browser extension when you run it for the first time. Bardeen will also prompt you to integrate Google Sheets if you haven’t done so already.

Step 2: Run the playbook to save Amazon best seller products to Google Sheets

Press Option + B on your keyboard to launch Bardeen. Click on the playbook card and enter the Google Sheets spreadsheet that will contain the product information. 

You can also create a new Google Sheets spreadsheet right from the playbook. To do that, type “Create Google Sheet” and choose the option “Create Google Sheet with name [title]. Then enter the name of the Google sheet that you want to create.

Run the playbook for any Amazon best sellers page. You can enter the URL of the page or run the playbook when you are on the page.

It will scrape all the product information, capture the product name, link, rating, and image, and save them as new rows in Google Sheets.

💪Pro tip: You can also edit the playbook and add your following action to customize the automation further. For example, you can swap Google Sheets for a different database like Notion or Airtable. You can even send the data as an email!

Locate more integration possibilities for Amazon integrations, Google Sheets automations and both Google Sheets and Amazon, or modify the playbook to better suit your specific workflow needs.

Discover more about the awesome data-sourcing integrations, marketing automations, and sales and prospecting automations available.

Action Flow


When running a Play- or Autobook you'll be asked for following information:

You can also edit the playbook and add your next action to further customize the automation.

Read more about how to connect Amazon and .

Discover more website data scraping possibilities with ready to use instant data scrapers, or learn how to scrape website data.

Creator Avatar
Last update:
September 15, 2023

Related & similar Playbooks

Related articles

Why our users love Bardeen

Little Rocket Ship

Launch your productivity boost today.

By clicking “Accept All Cookies”, you agree to the storing of cookies. View our Privacy Policy for more information.