\n<\/strong>Here are the things you are going to need to set this up
\n– A fitbit API key (there are lots of guides like this one<\/a> to request an API key)
\n– An understanding in Web Technologies (HTML, CSS, Javascript) and more importantly a web programming language – I will be using PHP
\n– A web server that supports your languages of choice.
\n– You have a google account which you can use google drive on<\/p>\n
Step 1 – Outsourcing Oauth to Google Drive<\/span> Step 1.1 – Information Step 1.2 – Make a (depreciated) google spreadsheet<\/strong><\/p>\n We need to make a google drive spreadsheet, but it needs to be the old version of sheets, \u00a0 you NEED to request an old sheet with this link –\u00a0https:\/\/g.co\/oldsheets<\/a> – Request a new spreadsheet with the URL above (https:\/\/g.co\/oldsheets<\/a>) Step 1.3 – Add\u00a0the\u00a0script to your Google Spreadsheet Go to your new spreadsheet we made in the last step (Should still be open) If the “first time” Google Apps Script menu pops up, cancel making sure you select “Dont show again” and “close” to close all dialog popup boxes,\u00a0You should now be looking at an empty page, or a blank JavaScript function currently in the script editor.<\/p>\n This is where we need to place the script that will do all the oAuth work for us. Press the save button and name the script if necessary<\/p>\n Step 1.4 – Run the functions to configure the script<\/strong><\/p>\n From the “Select Function” drop down 1.4.1 – Run the\u00a0Authorize Function<\/span> 1.4.2 – Run the\u00a0Setup Function<\/span> Once you see the above popup on the Spreadsheet tab, Enter: 1.4.3 – Run the Sync Function<\/span> All your data should now be in the spreadsheet.<\/p>\n Step 1.5 –\u00a0Add an automated trigger to your script Your spreadsheet will now stay updated!<\/p>\n Step 1.6 – Set your spreadsheets share settings to Public<\/strong> Step 2 – Show the Google Docs Data on your Website<\/strong><\/span><\/p>\n Step 2.1 – Upload my API to your site<\/strong> Step 2.2 – Configure my PHP API<\/strong> Step 2.4 – Load the page in a browser<\/strong> Step 2.3 – Consider application design and page load speed<\/strong> Done!<\/strong><\/p>\n In theory we have now included fitbit data on your website!<\/p>\n","protected":false},"excerpt":{"rendered":" So someone on the \/r\/fitbit page asked a general question about how to get fitbit steps on your personal website. I had previously asked this question before, and answered it myself. However since then my solution has changed, and I failed to document it. I promised I would update him, and here I go. Assumptions […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"_links":{"self":[{"href":"https:\/\/p337.info\/blog\/wp-json\/wp\/v2\/posts\/88"}],"collection":[{"href":"https:\/\/p337.info\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/p337.info\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/p337.info\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/p337.info\/blog\/wp-json\/wp\/v2\/comments?post=88"}],"version-history":[{"count":7,"href":"https:\/\/p337.info\/blog\/wp-json\/wp\/v2\/posts\/88\/revisions"}],"predecessor-version":[{"id":140,"href":"https:\/\/p337.info\/blog\/wp-json\/wp\/v2\/posts\/88\/revisions\/140"}],"wp:attachment":[{"href":"https:\/\/p337.info\/blog\/wp-json\/wp\/v2\/media?parent=88"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/p337.info\/blog\/wp-json\/wp\/v2\/categories?post=88"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/p337.info\/blog\/wp-json\/wp\/v2\/tags?post=88"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n<\/strong><\/p>\n
\n<\/strong>I am not a web developer, I make websites as something fun to do, so naturally, oAuth scares me. luckily there is a Google Apps script that does all this for me.
\nAll of this step 1 is dedicated to whomever wrote this article http:\/\/quantifiedself.com\/2013\/02\/how-to-download-fitbit-data-using-google-spreadsheets\/<\/a><\/p>\n
\nThis is because the sharing functionality in the older spreadsheets are superior to new spreadsheets. Hopefully google never fully deprecate these spreadsheets styles, because the whole of this process\u00a0relies on old versions of google sheets.<\/p>\n
\n– Give them a valid reason you are using an old sheet style (they seem to be asking for it now)
\n– Name the spreadsheet something meaningful
\n– Save the spreadsheet<\/p>\n
\n<\/strong>Google drive spreadsheets (in this case sheets) have the ability to program back end scripts in javascript, The next few steps will be dealing with what is called “Google Apps Script” which link to our Google Spreadsheet.<\/p>\n
\nGo to Tools > Script Editor<\/p>\n![\"http:\/\/i.imgur.com\/R1Xucdp.png\"](\"http:\/\/i.imgur.com\/R1Xucdp.png\")
<\/p>\n
\nDelete everything in the script box (there should be a blank function – make sure you have a blank script)
\nThen paste the FitbitDownload.gs script (Found Here: Original GitHuB Source<\/a>\u00a0or Rehosted on Pastebin<\/a>) so that it is the only thing in your new google apps script code area.<\/p>\n
\nYou want to run the functions in this order order<\/p>\n
\n(Note: This will allow Fitbit access to your google apps data)
\nSelect\u00a0“authorize”\u00a0from the drop down
\nclick the button that looks like a “Play” button
\n(Which is 2 buttons to the left of the “Select Function” drop down)
\nonce you run the function, a popup box will appear.
\nclick authorize and login with your fitbit account to finish this step.<\/p>\n![\"\"](\"http:\/\/i.imgur.com\/9bj3m0G.png\")
<\/p>\n
\nNext run “setup” function with the same method as the above step
\n(NOTE: you will have to alt tab back to your Google Drive spreadsheet,
\nbecause a popup opens\u00a0there asking for more details.- see below)
\n![\"http:\/\/i.imgur.com\/Y2X8Vpb.png\"](\"http:\/\/i.imgur.com\/Y2X8Vpb.png\")
<\/p>\n
\na. Your API key – This need to be filled out with a valid key – unlike mine seen above.
\nb. Make sure you enter today’s date, unlike my screenshot above (setting a super old date will result in an error because these details are not longer request-able from fitbit)
\nc. Make sure you select all of the “Data Elements” by using CTRL when you click.
\n(Make sure they are highlighted)
\nThen click “Save Setup”<\/p>\n
\nAfter you have successfully configured “Setup”
\nGo back to your script and run “Sync”<\/p>\n
\n<\/strong>We now need to tell google scripts to run the “sync” function every 15-30 minutes (up to you)
\nYou should still have the script editor open in a tab. Go back to it
\n(if not, go to Tools > Script Editor on your spreadsheet)
\nClick on the speech bubble looking icon, when hoevered over the icon will say “Current Projects Triggers”
\nOn the dialog menu, select “Add a new trigger”
\nAnd set “Sync” to run every 15 minutes.
\n![\"http:\/\/i.imgur.com\/ZJH0Nbe.png\"](\"http:\/\/i.imgur.com\/ZJH0Nbe.png\")
<\/p>\n
\nNavigate back to your Google Spreadsheet, (you may close the script editor if you like.)
\nFrom the “File” menu, select “Publish to the Web”
\nA popup should appear, Make sure “All Sheets” is selected before you click “Start Publishing”
\nYou should now be able to “Get a link to the Published Data” which is a web link.
\nMake sure that link works in a browser. if it does we are ready to do some web coding!<\/p>\n
\nGo to pastebin and get my API \u00a0–\u00a0http:\/\/pastebin.com\/GrA7xUVd
\nThis API basically reads in the google spreadsheet
\nUsing string manipulation, it finds the values for todays step values (using the server date)<\/p>\n
\nThere are 3 variables you want to configure in my API, I have detailed them pretty clearly.
\n1. The location to your google spreadsheet, this is obvious, the API needs to know the URL of the spreadsheet we set up earlier.
\n2. If you want the API to output JSON or not
\n3. Set your timezone – Setting your timezone is crucial to ensuring you get todays step total.
\n![\"\"](\"http:\/\/i.imgur.com\/rXZRKIy.png\")
<\/p>\n
\nOnce you’ve configured the settings,
\nAnd uploaded the page to your web server
\nYou should be able to load the page in your browser!
\nnavigate to the URL of where you uploaded the php page
\nAnd remember to add ?ddos=1 to the end of the PHP URL address, because that’s how I avoid web crawlers pulling fitbit data accidentally.
\nan example of your URL would be http:\/\/website\/directory\/fitbit_and_gdocs_api.php?ddos=1<\/em><\/p>\n![\"\"](\"http:\/\/i.imgur.com\/e0Bc2wD.png\")
<\/p>\n
\nthe API I have provided is not designed for fast page loads.
\nIf you include this code in your homepage, it will slow your site load times down considerably, as you are now not only requesting your homepage, but also loading a google spreadsheet every page load.
\nI run this\u00a0page and load the values into a MYSQL table once every 15 minutes.
\nBecause a Mysql table statement is 100 times quicker than loading a google spreadsheet.<\/p>\n