https docs google spreadsheets 1ozhzm edit

Video instructions and help with filling out and completing https docs google spreadsheets 1ozhzm edit

So you're building a simple internal app and you think I'm going to need a database right well not so fast as this tweet points out Google sheets might be all you need let's see how we can use Python to access Google sheets to kick things off will first create a project inside of Google's API manager I'm going to name the project legislators because we'll be working with a spreadsheet that contains the contact information for members of Congress in 2017 next I'll add the Google Drive API to this project which will allow us to access spreadsheets inside of Google sheets for our account once that's added we need to create some credentials to access the API since we'll be doing it from a web server we'll add the web server option and give it access to application data next we'll create a service account called legislators and assign it the role project editor which will allow it to access and edit data within the API clicking continue this will generate a JSON file that I will rename and add to the project as client underscore secret Jason if we open up that file in a text editor we'll find an email address property called client underscore email if we copy that and take it over to our spreadsheet we can share the spreadsheet to that email address to give us access to the spreadsheet from the API heading back to the terminal will use pip to install G spread and oo auth to client packages and then we'll create a file called spreadsheet dot pi and you can open that in your favorite text editor first thing we'll do here is import the G spread library as well as the service account credentials from both to client then we'll create a scope on spreadsheets google.com slash feeds and create some credentials using that scope and the contents of client underscore secret jason that we looked at earlier then we'll create a G spread client authorizing it using those credentials now we can access our Google sheets we'll call client dot open on legislators 2017 and get access to sheet number one then we'll set our legislators equal to all of the records inside of that sheet and print them out to the terminal let's take a look at what that looks like so we'll run Python spreadsheet PI and get this glorious list of perfectly formatted content we can clean up the formatting of the results by bringing in pythons P print module using that module we'll create a pretty printer that we can use to display results for the rest of the screencast any much nicer more formatted way by calling P P P print on those results heading back over to the terminal and running it you'll see we get much nicer formatting on our results since we're going to be working with more generic results moving forward I will change legislators to