How to Use Google Sheets as an Amazon Price Tracker

-
The prices of products listed on various Amazon shopping websites may vary every day and a simple Google Spreadsheet can help you monitor these price fluctuations via email. Just add the Amazon items in a spreadsheet and you’ll automatically get email alerts when their prices change on Amazon. You’ll thus never miss the deal again.
amazon price tracker

Track Amazon Prices with Google Sheets

The Amazon Price Tracker is easy to configure. All you have to do is add the links (URLs) of Amazon product pages inside a Google Spreadsheet. You can add monitor products across all Amazon.* websites. Here are the steps involved:

Step 1: Generate Amazon Access Keys

Open the Amazon Associates website and sign-in with your Amazon account. Next, click the Tools menu, choose Product Advertising API from the dropdown (link) and choose Manage Your Credentials under the Add Credentials section. Amazon will create an Access Key ID and a Secret Key that you’ll need in the next step.

Step 2: Copy the Google Spreadsheet

Click here to copy the Price Tracker Google Sheet in your Google Account. DO NOT change the layout of the Google Sheet as it may break the tracker.
amazon-product-links.png
Now all you have to do is enter Amazon product URLs in column A of the Google Sheet, one per line. For instance, here’s the Amazon URL for iPad
https://www.amazon.com/exec/obidos/ASIN/B07K344J3N/tajmahal020-20/
The URL contains the 10 digit ASIN code which is used by the Google Sheet to identify the specific Amazon product you are looking to monitor for price fluctuations.
In addition to prices, the Google Sheet lists several other useful attributes of Amazon Products including merchant’s name, sales rank, overall savings, Prime eligibility and whether the product qualifies for free shipping.

Step 3: Set Price Thresholds (optional)

With the Price Tracker, you can also set price thresholds for specific products and get automatic email alerts when the target price is reached. For instance, you can choose to receive alerts when the iPad price drops by 20% of the initial value. Or you can set a target price (alert when iPad drops to $399) and get automatic alerts when the price drops on Amazon.
To specify a threshold for any product, go to column B of the product row and enter the amount or percentage values as shown in the screenshot above.

Step 4: Configure Price Tracker inside Google Sheet

Inside the Google Sheets, go to the Amazon Price Tracker menu (near the Help menu) and choose Configure. You may have to authorize the Pricer Tracker script once to connect to Amazon API and send email alerts.
configure-price-tracker.png
Next enter your access keys, your email address and the time when you wish to receive the email alerts. Click Save to initialize the Amazon Price Tracker.
That’s it. You’ll receive a daily email digest with the price fluctuations as shown below.
amazon-email.png

Monitor Amazon Products for Price Drops

Amazon Price Tracker can monitor prices of all products (including Kindle ebooks) listed on Amazon.com and the country-specific websites including amazon.fr, amazon.de, amazon.es, amazon.ca, amazon.it, amazon.in, amazon.co.jp and amazon.co.uk.
Also, you can add more Amazon URLs, or delete existing products, from the Google sheet and the script will automatically pick the changes in the next run. And if you ever wish to stop receiving those email alerts, just choose the Stop Tracking option from the Price Tracker menu in the same Google sheet.
The tracker is written in Google Scripts and uses Amazon’s Product Advertising API to fetch the latest prices at fixed intervals. The Price Tracker is completely free but if you chose to upgrade to premium, you get technical support and get to use your own Amazon Associate tags.
The post How to Use Google Sheets as an Amazon Price Tracker appeared first on Digital Inspiration.


source:https://ift.tt/2iSFJ0A

Comments

Post a Comment

Popular posts from this blog

The 101 Most Useful Websites

-
Image
Presenting the 101 most useful websites on the internet. These sites, well most of them, solve at least one problem really well and they all have simple web addresses (URLs) that you can memorize thus saving you a trip to Google. The Most Useful Websites and Web Apps ctrlq.org/screenshots  – for capturing  screenshots of web pages  on mobile and desktops. dictation.io  – online voice recognition in the browser itself. zerodollarmovies.com  – find full-length movies on YouTube. screenr.com  – record movies of your desktop and send them straight to YouTube. goo.gl  – shorten long URLs and convert URLs into  QR codes . unfurlr.come  – find the original URL that’s hiding behind a short URL. qClock  – find the local time of a city using a  Google Map . copypastecharacter.com  – copy special characters that aren’t on your keyboard. postpost.com  – a better search engine for twitter. lovelycharts.com  – c...
Read more

Compare MacBook Prices Worldwide with Google Sheets

-
Image
Looking to buy the new Macbook Pro with M3 chips? Wondering if it would be cheaper to purchase a Macbook in your local Apple store, or ask a friend who is travelling from Singapore or Japan to bring one for you? Here’s a Google Sheet that can help you compare prices of MacBooks in different countries. It takes the current prices of MacBooks from Apple online stores in different countries and converts them to a common currency (US Dollars). The exchange rates are fetched directly from Google Finance so the prices will update automatically when the exchange rates change. How the Macbook Price Comparison Sheet Works I have written a Node.js script that fetches the current prices of MacBooks from the Apple website and writes them to Google Sheets. Here’s the code that scrapes the Apple website and parses the HTML to extract the prices. Get Macbook Prices from Apple Website Apple uses JSON-LD to embed structured pricing data in their web pages that can be easily parsed using che...
Read more

Interesting Websites to Visit When You’re Bored

-
The 15 Interesting Websites Dear Photograph  – The website features photographs of people holding up old pictures that were taken at the exact spot several years ago. Some of the best photographs are now compiled in a  book  (dearphotograph.me). Textastrophe  – This website is a reminder of why you shouldn’t post your cell phone number on public websites. The creator starts a text conversation with random numbers found on Craigslist ads and publishes the transcript on the internet. The chats are funny and I hope its real because  screenshots can be faked  too (textastrophe.com). Stratocam  – This is like an online self-running slideshow showcasing some of the best satellite images found on Google Maps. Run the website in full-screen mode (Ctrl+Shift+F) and you may discover pretty and unexpected place on our beautiful earth (stratocam.com). Awkward Family Photos  – This is a place where people share embarrassing pictures of their loved ones i...
Read more