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:

Click here to make a copy of the Apple Tracker sheet in your Google Drive.
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.
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.
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.

Comments

How to Identify the Gender of your Twitter Followers??

Do you ever wonder what is the demographics of people who follow you on Twitter. How many of your Twitter friends are men? Or women? Or random colored eggs, people who are either too lazy to change their default avatar or maybe they are Twitter bots . The Graph Search of Facebook can provide deep insights into the demographics of people who are connected with you on the social network. For instance, you can write a natural language query like “ My friends who are older than 30 ” or “ My female friends who live in Delhi ” and the answer will be available instantly. Such granular data is however not available for Twitter users. Who Follows You? Males, Females or Eggs How do you programmatically determine the gender of a person on Twitter? The Twitter API doesn’t provide the gender information but there’s a workaround. You can take the profile picture of a Twitter user, feed it into Siftr’s Vision API and it will detect the gender of the most prominent face in the photogr

5 real-world events which ‘prove’ that time travel actually exists

In Back to the Future, you need an expensive car, and a conveniently placed lightning bolt – but what if time travel was easier than that? What if time travellers were ALL AROUND US? The ‘time travelling hipster’ (above) is one of the creepier pieces of evidence touted as proof that time travel exists – but we’ve picked out some of the best below, including several people from black-and-white films who appear to be using mobile phones. Nigel Watson, paranormal expert and author of the UFO Investigations Manual, ‘Would time travelers from the future really be using mobile phones? Wouldn’t they use something more sophisticated and less visible? Then again Dr Who still uses a sonic screwdriver and that is so 20th Century…’ Entry by Cervus Entry by Chan Teik Onn Entry by GordonHaid Entry by gicusudoru

How to Make Phone Numbers Callable in Google Sheets?

How to Insert Clickable Phone Numbers in Web Pages We use the simple tel protocol to convert a plain text phone number on a web page into a clickable telephone link For instance, if you click this link on a mobile phone, it will open the phone dialer prefilled with the specified number. There’s no need to copy-paste numbers. How to Type Phone Numbers in a Google Sheet It is a bit tricky to type phone numbers inside Google Spreadsheets. Here’s why: Phone numbers are mostly made of digits preceded by the plus (+) symbol. The problem is as soon as add the plus sign in the spreadsheet cell, it assumes that you entering a math formula and tries to calculate the value. There are two simple workarounds to this problem. You can enclose the phone number inside double quotes (“) and precede it with an equal to (=) sign. An even easier alternative is to use the single quote (‘) before the phone number. Google Sheets will then interpret the cell’s value as text and

Digital Inspiration

Search This Blog