How to download ASIN data from Cerebro into a Google Sheet

Cerebro is a tool from Helium10 that allows Amazon sellers to conduct reverse ASIN lookups. It helps identify keywords for which a competitor's product is ranking, providing insights into keyword volume. Extracting keywords is tedious, but a bot can automate it for you, ensuring you get the most out of your Helium10 subscription.

Atuomate data entry into the Cerebro search field.

In this guide, you'll learn how to use a bot to load the Cerebro homepage, enter 10 ASINs into the search field, and click "Get Keywords." The bot will then scroll the page, click "Export," and download the CSV file. After that, it will import the CSV and write the data to a Google Sheet. Once the bot completes its first loop, it will delete the processed ASINs and repeat the loop with a new set of ASINs.

We also chose to export the data rather than scrape it directly from the page because exporting is significantly faster than scraping page by page if we want all the data.

Check out our other Helium10 guides if you're interested in automating Black Box or Magnet.

Getting started

To begin, create a Google Sheet and add two tabs: one for ASINs and another for storing extracted data.

  1. Create a new Google Sheet: If you're logged into Google, type sheet.new in your browser to quickly create a new sheet.
  2. Set up tab one: Add your ASIN numbers into the first tab, column A.
  3. Set up tab two: Name the second tab "ASIN data" and leave it blank.

How to automate extracting the ASIN data

To start building your bot, open axiom.ai and click "New Automation" to launch the no-code bot builder. Then, click "Add First Step" and follow the guide.

Download the template we created for this scraper. Click to learn how to upload it.

  • 1.0 Read data from a Google Sheet
    • Spreadsheet: Search for and add the Google Sheet you created.
    • Sheet name: Choose the tab containing the ASINs.
    • Last cell: Enter 10, the maximum number of ASINs we can search per loop.
  • 2.0 Go to page
    • Enter URL: The URL will look something like this: "members.helium10.com/cerebro/amazon/view/xxxxxxxx?accountId=xxxxxxx". axiom.ai using the go-to page step to load the Cerebro tool
  • 3.0 Loop through data
    • Loop through data: Click Insert Data and select google-sheet-data. The loop step will now iterate through the ASINs in the Google Sheet.
  • 4.0 Enter text
    • Text: Click Insert Data and select google-sheet-data to pass the ASIN numbers from the sheet.
    • Select column: Choose column A in the preview. axiom.ai using the enter text step to enter ASINs in the Cerebro search field
  • 5.0 Press key(s)
    • Key: Press Record, then Tab.
  • 6.0 Click element
    • Select: Click Select, then click on the Get Keywords button.
    • Custom: In the selector tool, click Custom, then tick Use element text instead of HTML. Finally, click Complete.
  • 7.0 Click element
    • Select: Click Select, then click on Custom and insert [data-testid="runnewsearch"] or [data-testid="loadfromhistory"].
    • Optional Click: Tick this option, as the pop-up does not always appear. axiom.ai interacting with dialog in Cerebro during bot run
  • 8.0 Wait
    • Wait time: Insert 7000 to make the bot wait 7 seconds. You may need to experiment with wait time.
  • 9.0 Click element
    • Select: Click Select, then click on Custom and insert #cerebro-amazon-single-com_wrapper button[data-testid="exportdata"].
  • 10.0 Download file
    • Select: Click Select, then click Custom and tick Use element text instead of HTML. Insert "...as a CSV file." Then click Complete.
    • Folder: Set a folder path to download into.
    • File name: Enter a name to save the file as.
  • 11.0 Wait
    • Wait time: Insert 4000 to make the bot wait 4 seconds. You may need to experiment with wait time.
  • 12.0 Import CSV File
    • Import CSV: Insert the folder path, then click Insert Data and select File-download-data to add the file name to the path. axiom.ai setting file path to import CSV
  • 13.0 Write data to a Google Sheet
    • Spreadsheet: Select your Google Sheet.
    • Sheet Name: Choose the tab where you want to write the ASIN data.
    • Data: Click Insert Data and choose Imported-csv.
    • Write Options: Select Add to Existing Data to append new data without deleting the existing data.
  • 14.0 Delete rows from a Google Sheet
    • Spreadsheet: Select your Google Sheet.
    • Sheet Name: Choose the tab containing the ASIN numbers.
    • First Row to Delete: Leave this set to 1.
    • Last Row to Delete: Set to 10.
  • 15.0 Jump to another step
    • Jump to step: Select your Google Sheet.
    • Maximum cycles: Set the maximum number of times the bot should repeat the process.

The Cerebro automation, when completed, should resemble the diagram below.

axiom.ai design pattern for building a bot to automate dat extraction from helium10 tool Cerebro

Testing your Cerebro automation

Once you have saved your Helium10 automation, click "Run" within the axiom.ai extension to start extracting ASIN data.

Issues you may encounter:

  1. Click elements not found: If elements are not being clicked, you may need to reselect them. Changing marketplaces can sometimes affect selectors.
  2. Keyword data not loading in time: Cerebro can sometimes be slow to load data. You may need to adjust the wait time in Step 8.

Try the Cerebro template

While creating this guide and testing axiom.ai on Helium10, we also built a template. If you choose to use the template, you will need to do the following:

  1. Step 1: Add your own Google Sheet.
  2. Step 2: Insert the URL to the Cerebro landing page.
  3. Step 8: Insert the download path and file name.
  4. Step 10: Set the import path, including the download file token (contains the file name).
  5. Steps 11 and 12: Add your own Google Sheet.

Please note that this template is a starting point, and you may need to customize it.

Click to download the Cerebro template.

Wrapping up

Extracting data in Cerebro isn’t always straightforward, but it's possible with automation. For example, changing marketplaces can affect the CSS selectors used to click on elements. I also found that, due to the large quantity of data, it's faster to download the CSV and import it into a Google Sheet rather than scrape the data page by page.

If you need help automating Helium10, reach out to support@axiom.ai, and we’ll help you create an automation.

Testing was completed on January 22, 2025. Features in Helium10 or axiom.ai may change over time, and updates may be needed.

On this page