Automate Your Grocery List Using QR Codes

by pato_pitaluga in Living > Life Hacks

15997 Views, 39 Favorites, 0 Comments

Automate Your Grocery List Using QR Codes

coverqrtolist.png

Add a sticker with a QR code to your jars and containers. When you notice that you´re getting out of that product, scan the QR code with your smartphone and it will be added to your grocery list in a Google Spreadsheet. When you are going to the market or creating a shopping order you will have your list ready and you will never forget to buy what is missing.

If a member of your family scans the code again it will not add the product twice to the list. The quantities that you are going to buy are those that you are accustomed.

No programming skills required.

Create a IFTTT Recipe

IFTTT is a free web-based service that allows users to create events that are triggered based on changes to other web services such as Gmail, Facebook, Instagram, and Pinterest and others. IFTTT is an abbreviation of "If This Then That". If you have never used this service before, you will have to Sign In and follow the demo.

Signed in IFTTT, go to My Recipes and press Create a Recipe. Press this and search the channel called Maker. If this is your first time using the Maker channel, it will ask you to press Connect and it will open a window where you will need to press Done.

Choose the trigger Receive a web request. As the Event Name, enter the name of the product that you want to make a QR code for. For example: Coffee. Press Create Trigger.

Set the Grocery List Spreadsheet

spreadsheetsetup.jpg

Press the button "that" con set the triggered action. Search the channel Google Drive. If this is your first time using the Google Drive channel, it will ask you to Connect and it will open a popup window where you will have to Allow IFTTT to interact with your Google Drive documents.

Select the action Add row to spreadsheet. For Spreadsheet name, write "QR Grocery list" or whatever you prefer. For Formatted row just let {{EventName}}.

For Drive folder path enter "IFTTT/QR Grocery List" or whatever name and path you like, but remember this path because you will repeat the same spreadsheet name and path with every item.

Get Your Url and Create the QR Code

getkey.jpg

Go to https://ifttt.com/maker in your browser, to know your key. Copy it and open in a different tab the url: https://maker.ifttt.com/trigger/{event}/with/key/{yout_key} replacing {event} with the name of the product that you already set in a previous step, for this example it will be Coffee, and {yout_key} with the key in your clipboard. If everything is working well you will see the text "Congratulations! You've fired the Coffee event" and the spreadsheet will be created in your Google Docs.

Go to Google Drive, in the path that you previously set to see if there's a new spreadsheet with the item Coffee.

Now search Google for a QR code generator. There are many and they are very easy to use. Just paste the url that triggers the event and generate the QR code.

If you have not already done so, download an app on your smartphone to scan QR codes. Test it with the QR code on the screen. It will update the Google Spreadsheet in real time, adding a second Coffee item.

Print the QR code on a sticker and put it wherever you find it useful.

Repeat these steps for every item that you want to automate.

Before Going Shopping

coffeeqr.jpg

Whenever you want to get the final grocery list without repeated items. Write in any empty cell the function =UNIQUE(A:A).

To empty the list when you have already bought the items, just delete the cells in the first column.

Be careful not to share photos of any of your QR codes or "Maker channel key" because anyone with the url can add items to your list.

I hope you will find this useful and fun. If you find other clever uses for this idea, write it in the comments. Bye.