From the course: Scripting for Testers

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Create a Google Sheets service account

Create a Google Sheets service account - Python Tutorial

From the course: Scripting for Testers

Start my 1-month free trial

Create a Google Sheets service account

“

- [Instructor] In the last couple of videos we learned how to create charts using Google Charts. Charts are a powerful way to display data. Another powerful tool for analyzing data is the spreadsheet. In many cases you can just directly import data into a spreadsheet, but sometimes it's more powerful to be able to read and write data directly into a spreadsheet from a script. For this course we're going to use Google Spreadsheets and so you will need a Google account in order to follow along. Before we go too far though, we'll need to give our script access to the spreadsheets. We can do that with something called a Google Service Account. The first thing you'll need to do is to go to the developer console for Google, which I've got open here. Once you're here, the first thing you need to do is create a project. Now I've already created one, so you can see test project, but if you wanted to you could click on that and then you could click on the plus button here to create a project…

Contents