Research top-selling Amazon products into a sheet
A sheet of top-selling Amazon products in a niche with prices, reviews, ranks, and gaps
Research top-selling Amazon products in [category or niche, e.g. kitchen storage or children's picture books] on [marketplace, e.g. amazon.com or amazon.co.uk] into a Google Sheet. Start from that category's Best Sellers page, then search for [search terms, e.g. bamboo drawer organizer] and add the top organic results. Skip sponsored listings. Stop at [number, e.g. 50] products. For each product capture: rank, title, brand, ASIN, price, star rating, review count, Best Sellers Rank with its category, date first available if shown, and the product link. Open the product page when the list view hides details. Remove duplicates by ASIN. Add a summary tab: top brands by listing count, price range, average rating, and 3 to 5 gaps worth a look, each with a one-line reason. If I list [trend keywords, e.g. the main search term], check Google Trends over 12 months and note whether interest is rising or falling. Tell me the product count and any pages that wouldn't load.