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

What it does

The task

Open the Google Sheet sheet url. Each row has my product, my price and the links to the same product at competitor stores. Open each link and read the price, the shipping cost, the stock status and any promotion. Write the values with today's date in new columns, and keep the old columns. Read at most 200 links in one run. Send me only the rows where a competitor's price moved by more than threshold, or where a competitor is now cheaper than me.

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

What you give it

BlankWhat to giveExample
sheet urlA sheet with your products, prices and competitor linksdocs.google.com/spreadsheets/d/1Kp9...
thresholdThe smallest price move to report5%

What you get back

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

Price changes on 28 Oct: 4 of 62 products

ProductYour priceCompetitorWasNow
Kova 2 hand grinder64.90 EURBrewline69.90 EUR59.90 EUR, cheaper than you
Aurex S7 robot vacuum379 EURKestrel Electronics389 EUR349 EUR, promotion until 2 Nov
Lumo Duo stroller549 EURAmazon, Lumo store549 EUR499 EUR, cheaper than you
Corvex 27-inch monitor299 EURBrightline Techin stockout of stock

Sheet updated: 62 rows, 174 links read

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 2 blanks

    Type sheet url and threshold. Tab moves to the next blank.

  3. 03

    Run it, then repeat it

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

As a routine, from the terminal

cuiar routines create "Track competitor prices in a sheet" --schedule "0 6 * * *" --time-zone Europe/Berlin \
  "Open the Google Sheet docs.google.com/spreadsheets/d/1Kp9.... Each row has my product, my price and the links to the same product at competitor stores. Open each link and read the price, the shipping cost, the stock status and any promotion. Write the values with today's date in new columns, and keep the old columns. Read at most 200 links in one run. Send me only the rows where a competitor's price moved by more than 5%, or where a competitor is now cheaper than me."

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 "Track competitor prices in a sheet" template with sheet url = docs.google.com/spreadsheets/d/1Kp9...; threshold = 5%.

Setup for other agents: AI agents.

The tool call

{
  "name": "create_routine",
  "arguments": {
    "name": "Track competitor prices in a sheet",
    "task": "Open the Google Sheet docs.google.com/spreadsheets/d/1Kp9.... Each row has my product, my price and the links to the same product at competitor stores. Open each link and read the price, the shipping cost, the stock status and any promotion. Write the values with today's date in new columns, and keep the old columns. Read at most 200 links in one run. Send me only the rows where a competitor's price moved by more than 5%, or where a competitor is now cheaper than me.",
    "schedule": "0 6 * * *",
    "time_zone": "Europe/Berlin"
  }
}
All monitoring templates
  • Monitoring

    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
    • Amazon
    • Google Sheets
  • 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