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
| Blank | What to give | Example |
|---|---|---|
| sheet url | A sheet with your products, prices and competitor links | docs.google.com/spreadsheets/d/1Kp9... |
| threshold | The smallest price move to report | 5% |
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
| Product | Your price | Competitor | Was | Now |
|---|---|---|---|---|
| Kova 2 hand grinder | 64.90 EUR | Brewline | 69.90 EUR | 59.90 EUR, cheaper than you |
| Aurex S7 robot vacuum | 379 EUR | Kestrel Electronics | 389 EUR | 349 EUR, promotion until 2 Nov |
| Lumo Duo stroller | 549 EUR | Amazon, Lumo store | 549 EUR | 499 EUR, cheaper than you |
| Corvex 27-inch monitor | 299 EUR | Brightline Tech | in stock | out of stock |
Sheet updated: 62 rows, 174 links read
Run it in Cuiar
- 01
Open it
Click Use in Cuiar on this page. The side panel opens with the task in the composer.
- 02
Fill in 2 blanks
Type sheet url and threshold. Tab moves to the next blank.
- 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/mcp2. 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"
}
}Related templates
All monitoring templatesMonitoring
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- AAmazon
- 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
- AAmazon
- +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- AAmazon
- 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