Spreadsheet Tasker Plugin

I collect various types of data on my phone such as sleep data using Tasker. Traditionally, I've saved the data to a local file on my phone (typically a csv) and then used an app to transfer that data file to Google Drive.

I recently found a Tasker plugin app called Spreadsheet Tasker Plugin that will communicate directly with a Google spreadsheet. This approach is much easier.

In the case of my sleep data, each time I complete a sleep instance, it adds a row to a Google sheet with the data.

I have my phone set up via Tasker to start a sleep instance when the phone is oriented face-down and end the sleep instance when it no longer orients face down. I have a timer built in so that it only records the data after 30 minutes to avoid accidental downward orientations or instances where I haven't fallen asleep yet.

The paid version offers off-line buffering which stores the data if you aren't connected until a connection is made.

Google Play Store: Spreadsheet Tasker Plugin

Fitbit Data to Google Spreadsheet Via IFTTT

In a previous post, I described a method I've been using to collect Fitbit data into a Google spreadsheet for use in things like R.

Since then, I've found two things that make that process even easier.

One is an R package, googlesheets, that easily loads data from a Google spreadsheet into an R dataframe. More on that in another post.

The other is the use of IFTTT to load connect to my Fitbit account and send the data to a Google spreadsheet. IFTTT has connections to both Fitbit and Google Drive. It makes it easy to set up a connection for both activity data and sleep data. I currently have two IFTTT recipes, one for activity data and one for sleep data.