Skip to main content

Check iPhone Stock in nearby Apple Stores with a Google Sheet

You are planning to buy a new iPhone 7 but the model you want to have, the premium jet black finish with 128GB, is neither available at Apple stores in your area nor at any of the online shopping sites. Now the Apple website does have a simple tool to help you check the availability of iPhone, or iPad or any other Apple product, at their retail stores but you still need to perform these inventory checks manually.
Wouldn’t it be easier if these checks could be automated? You specify the iPhone model you wish to own, your preferred color, capacity, your area zip code, your desired carrier and the tool would send you an email alert when iPhone is back in stock at any of the Apple retail stores in your area. It’s like having someone check the Apple website for iPhone availability every few hours.

Check iPhone Availability by Zip 


What we have here simple Google Spreadsheet, that resides in your Google Drive, and it will monitor the Apple store in the background for iPhone availability.  When any of the iPhone models in your watchlist are back in stock at any of the nearby Apple Stores, you’ll get an email alert.
The email alerts (see sample alert) will also include a directly reservation link to help you book the device online for in-store pickup rather than having to drive down to the store.

Monitor iPhone Stock with Google Sheets

Here’s how you can use the Google Script based Apple Tracker tool for automatically tracking iPhone inventory at Apple Stores in your locality:
  1. Click here to make a copy of the Apple Tracker sheet in your Google Drive.
  2. The sheet has a list of every possible iPhone variant available at Apple Stores. Put your ZIP code, or your locality, against any iPhone model that you wish to monitor for availability.
  3. Go to the Apple Store menu (near Help menu), choose Start Tracker and authorize the script. You only need to do this once, the script is open-source and none of your data ever leaves your Google account.
  4. The Google Script will check the inventory of all Apple Stores in the specified zip code and will send email alerts if it finds a store where your favorite Apple iPhone model is available for pick up. The email alert will also include the Apple store’s address and phone number.
    Later, if you need to completely disable tracking, open your Google sheet and choose Uninstall from the Apple menu. If you need to remove tracking from certain iPhone models, just clear the corresponding ZIP column for that row.
Labels:

Comments

Post a Comment

Popular posts from this blog

10 MOST HAUNTED PLACES IN THE WORLD

It seems that one of the most enduring aspects of cultural similarity found throughout the world involves the supernatural.  No matter where you go across the globe, you’re going to hear various legends and ghost stories…except some of these carry significantly more weight than your average campfire story.  People seem to be somewhat obsessed with what goes on after death, especially in regards to whether or not the spirits of the departed stick around.  It would be easy to say that such attention can be blamed on vivid, Hollywood inspired imaginations, but documented reports of supernatural disturbances go back several centuries in many places, underlining the fact that no matter the time period or society involved, the paranormal remains on people’s minds. Sure, many places in the world that are reputedly haunted seem more far-fetched than realistic, but there are those that have a tendency to make even the most hardened skeptic stop and reconsider.  Listed he...
Post a Comment
Read more

What is Bitcoin?

Bitcoin is a form of digital currency, created and held electronically. No one controls it. Bitcoins aren’t printed, like dollars or euros – they’re produced by people, and increasingly businesses, running computers all around the world, using software that solves mathematical problems. It’s the first example of a growing category of money known as cryptocurrency. What makes it different from normal currencies? Bitcoin can be used to buy things electronically. In that sense, it’s like conventional dollars, euros, or yen, which are also traded digitally. However, bitcoin’s most important characteristic, and the thing that makes it different to conventional money, is that it is  decentralized . No single institution controls the bitcoin network. This puts some people at ease, because it means that a large bank can’t control their money. Who created it? A software developer called Satoshi Nakamoto proposed bitcoin, which was an electronic payment sys...
Post a Comment
Read more

Is Alien UFO Invasion Fleet Will Reach Earth In September 2017?

A new bizarre “report” circulating in the conspiracy theory blogosphere claims that a leaked top-secret Kremlin document has revealed details of a recent top-secret meeting between President Vladimir Putin of Russia and U.S. Vice President Joe Biden. During the meeting, Biden delivered to Putin a message from President Barack Obama, requesting Russia’s cooperation to establish an “Earth-wide” missile defense system to protect our planet from an impending alien UFO invasion expected to occur in September of 2017. The move by the Obama administration to seek the support and cooperation of Kremlin to ward off the threat of an alien military invasion of planet Earth came after NASA satellites reportedly detected a massive “miles-wide” alien UFO invasion fleet that entered our solar system. The massive fleet is believed to be heading toward Earth and will arrive in September of 2017. The bizarre report appearing on multiple alien and UFO conspiracy theory blog...
Post a Comment
Read more