Skip to content

Using Sheetsee.js and Tabletop.js to fetch data from a Google Spreadsheet and create a Scatterplot using D3

License

Notifications You must be signed in to change notification settings

denisemauldin/health-data

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Health Data

This is code for a survey site that uses Google Spreadsheet data to display a scatterplot using D3.

Fork -n- Go!

Here's a fun fact:

GitHub gives free hosting for every repository (see GitHub Pages).

This repo only has a gh-pages branch, the branch GitHub hosts, which means as soon as you fork it, you have a hosted and live version of it yourself! Read more about fork-n-go type of projects.

Next, create a spreadsheet with the same column headers as the original.

Click on the index.html file, click edit and change line 118 (or thereabouts) it looks like:

    document.addEventListener('DOMContentLoaded', function() {
	  	var gData
	  	var URL = "0Ao5u1U6KYND7dFVkcnJRNUtHWUNKamxoRGg4ZzNiT3c"
			Tabletop.init( { key: URL, callback: showInfo, simpleSheet: true } ) 
    }) 

Replace the existing spreadsheet URL key with your spreadsheet's key. You'll find that by clicking (in Google Spreadsheets) File > Publish to the Web > Start Publishing, it will then display the key in a window. get key

Commit those changes and LIKE WOAH you now have a version of this website hooked to a spreadsheet that you can distrubute however you'd like.

You can find your version at yourGitHubName.github.io/theReposName (in this case /hack-spots).

But How?

A Google Spreadsheet holds all the data and it is connected to this website using the goodies in sheetsee.js. Everytime you visit the website, you'll have the most up to date data that has been entered into the spreadsheet.

About

Using Sheetsee.js and Tabletop.js to fetch data from a Google Spreadsheet and create a Scatterplot using D3

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages

  • JavaScript 98.5%
  • Other 1.5%