How to Write to Google Sheets with AWS IoT Button

4,233 views · Published 10 October 2017 · 13:04 · Indexed 27 October 2026

Channel: Caroline Dunn · 2017 · Travel & Events

Watch on YouTube

How to write to a Google Sheet with an AWS IoT Button
UPDATE: at 10:53 you now have to search SHEETS instead of DRIVE (IFTTT change after I made the video) 

This tutorial shows you how to setup an AWS IoT Button to record a timestamp to your Google Sheet each time the button is pressed.

For example: 
Sleep Tracker - Push the button each time you go to sleep and each time you wake up to track your sleep hours.
Consulting Timesheet - If you bill clients by the hour, push the button each time you start or stop working on your client's project to record the time spent.
Commute time - Push the button each time you leave the house and when you get to your desk at work to track your daily commute times

For the project, you'll need:
AWS IoT Button - https://amzn.to/2PZbIdX (please do not discard the box)
AWS Account - https://aws.amazon.com/ (you'll need a credit card to create an account)
IFTTT Account - http://ifttt.com/ (free to create)
Source Code - https://www.hackster.io/blankalpha/aws-iot-button-ifttt-s-maker-channel-476bd9
Mobile device to download and install the AWS IoT Mobile app - https://aws.amazon.com/iotbutton/getting-started/
Computer with Internet access (Windows or Mac)

This is NOT a paid endorsement. I purchased the AWS IoT Button with my own funds.

More from this channel