Monitors Amazon products listed in Google Sheets and notifies on Telegram when the price drops
Stop wasting time refreshing pages—get real-time discounts for your tracked products, automagically updated in your Google Sheets.
Manually tracking Amazon product prices is a time-consuming nightmare—checking each ASIN daily, updating spreadsheets, and risking missed price drops that could cost you savings or leave you stuck paying more than necessary. The tedious grind of switching between Google Sheets and Amazon means valuable offers can slip by, costing you both money and visibility, especially if you manage multiple products or share updates with a team or community.
This Botize formula automates the entire process by periodically checking batches of up to 10 Amazon products listed in your Google Sheet. Whenever it detects a price drop, the automation updates your sheet with the new price and instantly sends a custom notification to your chosen Telegram group or channel. No more manual checks or fears of missing out—automation keeps you (and your audience) quickly informed and always one step ahead of the market.
Ready to eliminate hassle and capture every deal? Set up this formula to monitor exactly the products you care about, tweak update frequency, fine-tune message content, and direct alerts wherever you want. Follow the step-by-step guide to customize each detail, or jump in with Botize’s ready-to-use template and start automating in minutes—your time, savings, and peace of mind are just a click away.
Automate this task with 9 simple prompts
Copy and paste the following prompts into Botize's AI task editor
-
1
Access the Botize automated task editor.
-
2
Select the AI editing tool.
-
3
Create a trigger so the automation runs on a schedule.
Copy and paste this prompt into the AI editing tool.
Set up the automation to run automatically every hour. ⤵
Click the 'Apply this task' button to confirm.
-
4
Get a batch of product rows from Google Sheets to minimize API calls.
Copy and paste this prompt into the AI editing tool.
Read the next 10 rows from the first sheet in the specified Google Sheets document. Return columns: row number (A), ASIN (B), and price (C). ⤵
Click the 'Apply this task' button to confirm.
-
5
Retrieve product information from Amazon using the ASINs from Google Sheets.
Copy and paste this prompt into the AI editing tool.
Using the batch of ASINs from the previous step, request their current data (including price) from Amazon. ⤵
Click the 'Apply this task' button to confirm.
-
6
Match sheet rows to Amazon products by ASIN for easier comparison.
Copy and paste this prompt into the AI editing tool.
Combine the Google Sheets data and the Amazon product info by matching ASIN values. Keep only the records that match. ⤵
Click the 'Apply this task' button to confirm.
-
7
Process each matched product individually for further checks and updates.
Copy and paste this prompt into the AI editing tool.
Go through each matched product one by one to check and update information as needed. ⤵
Click the 'Apply this task' button to confirm.
-
8
Prepare the current and previous price as separate variables for comparison.
Copy and paste this prompt into the AI editing tool.
For each product, create two tags: one with the current Amazon price and one with the stored price from the sheet. ⤵
Click the 'Apply this task' button to confirm.
-
9
Decide if a price drop has occurred and needs attention.
Copy and paste this prompt into the AI editing tool.
For each product, check if there is a stored price and if the new price is lower than the old price. ⤵
Click the 'Apply this task' button to confirm.
-
10
If the price dropped, update Google Sheets with the new price.
Copy and paste this prompt into the AI editing tool.
Update the price column in the correct row in the Google Sheets document with the new Amazon price. ⤵
Click the 'Apply this task' button to confirm.
-
11
Notify a Telegram group or channel about the price drop.
Copy and paste this prompt into the AI editing tool.
Send a message to the specified Telegram chat showing the product title, the old price, and the new lower price. Include a button linking to the Amazon product page. ⤵
Click the 'Apply this task' button to confirm.
-
12
Your automation is ready to use. Click the 'Save changes' button.
Save changes
Never Miss an Amazon Deal: Price Drop Alerts Straight to Your Telegram
Add your favorite product ASINs to a simple Google Sheet. Our system checks their prices every hour in smart batches (so Amazon doesn’t get grumpy), updates your sheet when prices drop, and—best of all—sends a friendly Telegram alert to your group or channel with all the juicy details. No more FOMO. No more manual checking. Just deals, delivered.
| Manual | Botize | |
|---|---|---|
| Check 10 product prices manually | 15 | 0 Minutes |
| Update prices in Google Sheets | 5 | 0 Minutes |
| Send price drop message to Telegram manually | 5 | 0 Minutes |
| Repeat hourly, 24 times/day | 600 | 0 Minutes |
| Total | 625 | 0 Minutes |
Looking to watch Amazon prices in Google Sheets and get instant Telegram alerts when something drops? This is the exact solution you need—no fluff, no code, pure results.
Deal Hunter Lifehack
Ana tracks 60 tech gadgets for Black Friday. Instead of endless tab-switching, she gets all price drop alerts in her Telegram channel and updates her Google Sheet in real time.
Instant Alerts
Get notified in real time—never miss a price drop again.
Zero Manual Work
Forget tedious copy-pasting. Set it & live your life.
Your Data, Updated
Google Sheets becomes your living, breathing deals dashboard.
Amazon Flipping Pro
Carlos resells gaming gear. When prices slide, Telegram notifies him immediately—he buys low, lists high, profits faster. Zero manual checking—the system does it all.
⌾︎ Perfect if you track Amazon prices in spreadsheets and want effortless alerts.
⌾︎ Ideal for bargain hunters, resellers, or anyone who loves scoring the best Amazon deals before everyone else.
✕ Not useful if you never buy on Amazon or don’t care about price changes.
✕ Makes no sense if you don’t already use (or want to use) Google Sheets or Telegram.
✓ Choose which sheet or tab tracks your products—any structure that fits your flow.
✓ Craft hyper-personalized Telegram alerts: add emojis, links, or unique calls to action.
✓ Adjust the check frequency—go even faster or save API calls depending on your urgency.
This automation checks Amazon products listed in a Google Sheets document in batches of 10 to minimize calls to the Amazon API. When a price drop is detected, it updates the new price in Google Sheets and sends a notification to a Telegram group or channel. The automation assumes you have a Google Sheets file where column A contains the row ID (using the =ROW() formula), column B contains the ASIN of each product, and column C stores the current price of each product. In the task setup, you must specify the Google Sheets URL, the Telegram chat where notifications will be sent, and customize the message content.
