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.
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.
- Create a new Google Sheet: If you're logged into Google, type
sheet.newin your browser to quickly create a new sheet. - Set up tab one: Add your ASIN numbers into the first tab, column A.
- 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.
Add a 'Read data from a Google Sheet' step and configure.
- 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.
Add a 'Go to page' step to load the Cerebro landing page with the search field.
- Enter URL: The URL will look something like this:
"members.helium10.com/cerebro/amazon/view/xxxxxxxx?accountId=xxxxxxx"

- Enter URL: The URL will look something like this:
Add a 'Loop through data' step.
- Loop through data: Click 'Insert Data' and select 'google-sheet-data'. The loop step will now iterate through the ASINs in the Google Sheet.
Add an 'Enter text' sub-step.
- 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.

Add a 'Press key(s)' sub-step to submit the search value.
- Key: Press 'Record', then 'Tab'.
Outside of the loop step, add a 'Click element' step to click "Get Keywords."
- 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."
To close the pop-up, add a 'Click element' step to click "Run new search" or "Load from history."
- 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.

- Select: Click 'Select', then click on "Custom" and insert
Add a 'Wait' step to pause the bot and allow data to load.
- Wait time: Insert "7000" to make the bot wait 7 seconds. You may need to experiment with wait time.
Add a 'Click element' step to open the export drop-down menu.
- Select: Click 'Select', then click on "Custom" and insert:
"#cerebro-amazon-single-com_wrapper button[data-testid="exportdata"]"

- Select: Click 'Select', then click on "Custom" and insert:
Add a 'Download file' step to export the CSV.
- Select: Click 'Select', then click "Custom" and tick "Use element text instead of HTML." Insert "...as a CSV file." Finally, click "Complete."
- Folder: Set a Folder path to download into.
- File name: Enter a name to save the file as.
Add a 'Wait' step to allow time for the file to download.
- Wait time: Insert "4000" to make the bot wait 4 seconds. You may need to experiment with wait time.
Add an 'Import CSV File' step to upload the CSV.
- Import CSV: Insert the Folder path, then click "Insert Data" and select "File-download-data" to add the file name to the path.

- Import CSV: Insert the Folder path, then click "Insert Data" and select "File-download-data" to add the file name to the path.
Add a 'Write data to a Google Sheet' step.
- 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.
Add a 'Delete rows from a Google Sheet' step to remove processed ASIN numbers.
- 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.
Add a 'Jump to another step' 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.
# 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:
- Click elements not found: If elements are not being clicked, you may need to reselect them. Changing marketplaces can sometimes affect selectors.
- 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:
- Step 1: Add your own Google Sheet.
- Step 2: Insert the URL to the Cerebro landing page.
- Step 8: Insert the download path and file name.
- Step 10: Set the import path, including the download file token (contains the file name).
- 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.