Cuiar
Sign inDownload

Watch the Amazon best sellers in my category

New products and big rank moves in a best sellers list, with the price and the review count.

  • On a schedule: Every day at 9:30
Use in CuiarRun from your AI agent

What it does

The task

Open the Amazon Best Sellers list for category on marketplace and read the top 100. For each product, record the rank, the title, the brand, the price, the rating and the number of reviews. Compare with the last run in the Google Sheet sheet url, and add today's values. Send me the products that are new in the top 100, the ones that moved 20 places or more, and the new brands, with a link for each.

  • It works in Amazon and Google Sheets, in the workspace you pick, and signs in with passwords from your Cuiar vault.
  • As a routine it runs every day at 9:30 (cron 30 9 * * *).

What you give it

BlankWhat to giveExample
categoryThe category path, as Amazon shows itKitchen, Coffee Grinders
marketplaceThe Amazon siteamazon.de
sheet urlThe sheet that keeps the historydocs.google.com/spreadsheets/d/1Bs8...

What you get back

An example run with the example values above. Your run uses your own data.

Best Sellers, Coffee Grinders, amazon.de, 28 Oct

New in the top 100:

  • #34 Brewline Mini electric grinder, 49.99 EUR, 4.4 (212 reviews), a new brand, link
  • #71 Kova 2 hand grinder, 64.90 EUR, 4.6 (1,048 reviews), link

Moved 20 places or more:

  • Halden burr grinder: #58 to #22, the price went down from 89 EUR to 69 EUR, link
  • Nordic Press grinder set: #19 to #47, link

Sheet updated: 100 rows

Run it in Cuiar

  1. 01

    Open it

    Click Use in Cuiar on this page. The side panel opens with the task in the composer.

  2. 02

    Fill in 3 blanks

    Type category, marketplace and sheet url. Tab moves to the next blank.

  3. 03

    Run it, then repeat it

    Run sends it once. To run it every day at 9:30, make a routine on cuiar.com/routines or with the CLI below.

As a routine, from the terminal

cuiar routines create "Watch the Amazon best sellers in my category" --schedule "30 9 * * *" --time-zone Europe/Berlin \
  "Open the Amazon Best Sellers list for Kitchen, Coffee Grinders on amazon.de and read the top 100. For each product, record the rank, the title, the brand, the price, the rating and the number of reviews. Compare with the last run in the Google Sheet docs.google.com/spreadsheets/d/1Bs8..., and add today's values. Send me the products that are new in the top 100, the ones that moved 20 places or more, and the new brands, with a link for each."

Run it from your AI agent

Claude Code, Codex, Cursor and other MCP clients reach Cuiar at https://mcp.cuiar.com/mcp. Add the server one time, then ask for the task in plain words, or call create_routine yourself.

1. Add Cuiar to Claude Code

claude mcp add --transport http cuiar https://mcp.cuiar.com/mcp

2. Ask your agent

Use the Cuiar tool create_routine to run my "Watch the Amazon best sellers in my category" template with category = Kitchen, Coffee Grinders; marketplace = amazon.de; sheet url = docs.google.com/spreadsheets/d/1Bs8....

Setup for other agents: AI agents.

The tool call

{
  "name": "create_routine",
  "arguments": {
    "name": "Watch the Amazon best sellers in my category",
    "task": "Open the Amazon Best Sellers list for Kitchen, Coffee Grinders on amazon.de and read the top 100. For each product, record the rank, the title, the brand, the price, the rating and the number of reviews. Compare with the last run in the Google Sheet docs.google.com/spreadsheets/d/1Bs8..., and add today's values. Send me the products that are new in the top 100, the ones that moved 20 places or more, and the new brands, with a link for each.",
    "schedule": "30 9 * * *",
    "time_zone": "Europe/Berlin"
  }
}

Related templates

All monitoring templates

  • Monitoring

    Track competitor prices in a sheet

    Each competitor's price and stock for your products, updated daily, with an alert on big moves.

    On a schedule: Every day at 6:00
    • Google Sheets
    • Any online store
    • Amazon

  • Data

    Export your product reviews into a sheet

    Each review of your product with date, rating, text and theme, plus counts and averages for each theme.

    You start it: When you start it
    • App Store
    • Google Play
    • Amazon
    • +1 more: Google Sheets

  • ShoppingAsks first

    Order supplies in bulk at the best unit price

    Unit prices at your quantities from three suppliers in one sheet, and the order at the best one.

    You start it: When you start it
    • Amazon
    • Any online store
    • Google Sheets

  • Monitoring

    Find new public tenders for my business

    New government tenders that match your services, with the value, the deadline and the documents.

    On a schedule: Every weekday at 7:00
    • Any government site
    • Google Sheets

  • Monitoring

    Find new grants my organization can apply for

    New grants that fit your mission and size, with the amount, the rules and the deadline.

    On a schedule: Every Monday at 9:00
    • Any government site
    • Any website
    • Google Sheets

  • Monitoring

    Watch new reviews of my app

    New App Store and Google Play reviews, grouped into bugs, requests and praise, with the app version.

    On a schedule: Every day at 8:00
    • App Store
    • Google Play
    • Google Sheets