Amazon ASIN Price Tracker Sheet

Замовник: AI | Опубліковано: 12.11.2025

I want a Google Sheet that lets me paste up to five ASINs from a single competitor and then automatically: • Pull the current Buy Box price every six hours. • Append each fetched price to a hidden “History” tab so I always have a running price history. • Highlight any change directly in the main sheet and pop an in-sheet alert (e.g., cell note, conditional-format banner, or sidebar message) whenever a price moves. No charts or graphs are needed at this stage; a clean table of live prices and the background history log is enough. The solution should run entirely inside Google Sheets using Apps Script with an installable time-based trigger, so I don’t have to keep the file open. Deliverables: 1. Ready-to-use Google Sheet template with the script attached. Accuracy and reliability are key; the six-hour fetch must stay consistent without manual intervention.