Create Market on Helium 10
Start by extracting a list of ASINs from your Google Sheet/Excel file, then populate a new market entry on the Helium 10 Market Tracker Tool.
After a few hours, the results will be ready - and the average monthly sold quantity within these.
After a few hours, the results will be ready - and the average monthly sold quantity within these.
Extract Data From Helium 10 Market
Drag this link to your bookmarks bar:
Get back to the Helium 10 Market Tracker Tool - depending on the size of the ASINs list, you will have a multi-page table.
Click on the H10 Extractor bookmark link and while it works do not operate in this browser's tab - let the script finish.
It will go over the pages until the very end, then a message will pop up in a modal dialog as the operation is concluded.
Click on the H10 Extractor bookmark link and while it works do not operate in this browser's tab - let the script finish.
It will go over the pages until the very end, then a message will pop up in a modal dialog as the operation is concluded.
At this stage, you can copy the textarea data to your clipboard - the format being
ASIN, AvgMonthlySoldQtyPaste Data in your sheet
Head back to your spreadsheets app and create a new sheet in your file. Import the CSV as it is, then switch to your original list.
Manipulate formulas in your
Manipulate formulas in your
Sales column using a VLOOKUP() function or similar to match data from the CSV data sheet.That's all! 🎉