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.

FitBit Data to Google Spreasheet

I received a FitBit for Christmas and while the website provides access to a lot of data a graphs, I wanted a way to access the data in a format to process with R (statistics).

I found the following blog post which points to the use of a Google script that accesses the data via the developer API and populates a Google spreadsheet.

http://citizen-statistician.org/2012/09/30/getting-data-from-fitbit/

It was pretty straight forward since I've worked a bit with Google scripts before.

It provides daily summary data across a dozen or so categories. What would be nice is more granular data.