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. Add a 'Read data from a Google Sheet' step and configure.

    1. Spreadsheet: Search for and add the Google Sheet you created.
    2. Sheet name: Choose the tab containing the ASINs.
    3. Last cell: Enter 10, the maximum number of ASINs we can search per loop.
  2. Add a 'Go to page' step to load the Cerebro landing page with the search field.

    1. 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. Add a 'Loop through data' step.

    1. 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. Add an 'Enter text' sub-step.

    1. Text: Click 'Insert Data' and select 'google-sheet-data' to pass the ASIN numbers from the sheet.
    2. Select column: Choose column ‘A’ in the preview.
      Axiom.ai using the enter text step to enter ASINs in the Cerebro search field
  5. Add a 'Press key(s)' sub-step to submit the search value.

    1. Key: Press 'Record', then 'Tab'.
  6. Outside of the loop step, add a 'Click element' step to click "Get Keywords."

    1. Select: Click 'Select', then click on the "Get Keywords" button.
    2. Custom: In the selector tool, click "Custom," then tick "Use element text instead of HTML." Finally, click "Complete."
  7. To close the pop-up, add a 'Click element' step to click "Run new search" or "Load from history."

    1. Select: Click 'Select', then click on "Custom" and insert "[data-testid="runnewsearch"]" or "[data-testid="loadfromhistory"]".
    2. Optional Click: Tick this option, as the pop-up does not always appear.
      Axiom.ai interacting with dialog in Cerebro during bot run
  8. Add a 'Wait' step to pause the bot and allow data to load.

    1. Wait time: Insert "7000" to make the bot wait 7 seconds. You may need to experiment with wait time.
  9. Add a 'Click element' step to open the export drop-down menu.

    1. Select: Click 'Select', then click on "Custom" and insert:
      "#cerebro-amazon-single-com_wrapper button[data-testid="exportdata"]"
      Axiom.ai interacting with dropdown menu to automate CSV download
  10. Add a 'Download file' step to export the CSV.

    1. Select: Click 'Select', then click "Custom" and tick "Use element text instead of HTML." Insert "...as a CSV file." Finally, click "Complete."
    2. Folder: Set a Folder path to download into.
    3. File name: Enter a name to save the file as.
  11. Add a 'Wait' step to allow time for the file to download.

    1. Wait time: Insert "4000" to make the bot wait 4 seconds. You may need to experiment with wait time.
  12. Add an 'Import CSV File' step to upload the CSV.

    1. 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. Add a 'Write data to a Google Sheet' step.

    1. Spreadsheet: Select your Google Sheet.
    2. Sheet Name: Choose the tab where you want to write the ASIN data.
    3. Data: Click 'Insert Data' and choose 'Imported-csv.'
    4. Write Options: Select 'Add to Existing Data' to append new data without deleting the existing data.
  14. Add a 'Delete rows from a Google Sheet' step to remove processed ASIN numbers.

    1. Spreadsheet: Select your Google Sheet.
    2. Sheet Name: Choose the tab containing the ASIN numbers.
    3. First Row to Delete: Leave this set to 1.
    4. Last Row to Delete: Set to 10.
  15. Add a 'Jump to another step' step.

    1. Jump to step: Select your Google Sheet.
    2. 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.