Click Manage of you aren’t already in the Google Sheets developer console. When you clicked the “Enable” button it should have taken you into the “Google Sheets API Console” but sometimes I’ve noticed the button just turns into “Manage”. It is also able to update these sheets right from PowerShell! It is able to create new spreadsheets and give permissions for others to view them without requiring user consent since the service account will own the spreadsheet sidestepping the private user data issue. This type of account uses a certificate to validate your identity instead of a username/password. The kind of account we want to create to work with Google Sheets using scripts is a service account. Some types of them require user consent but can access private user data. There is a lot of security built into Google’s APIs. To enable the Google Drive API follow the same steps we did in the “Acquiring Google Sheets API” but choose “Google Drive” from the G-Suite options instead. This will be needed for some access/permission controls later. Now enable the Google Drive API using the exact same steps. Google Developer Console – Add API Menu Google Sheets – API Enable Button Enable Google Drive API From here we are going to scroll down to the G-Suite section and click on “Google Sheets” and then choose the “Enable” button. This will bring up a page showing all the different Google APIs available. It looks like this: Google Sheets Dashboard – Enable APIs and Services From here we are going to click “ENABLE APIS AND SERVICES” at the top of the page. I called mine Scripts-jamesachambers.Īfter creating a project it should take you to the main dashboard. If you have never used the Google API before go ahead and create a new project. Acquiring Google Sheets APIįirst head to the official Google Developers Console. In this guide we’ll explore how to create a Google API key then and use PowerShell to create a new spreadsheets and upload a CSV file into Google Sheets. I recently had a need to interact with a Google Sheets spreadsheet and it turned out to be pretty easy and worked very well! I wanted to write this post to share what I learned and hopefully it can help some others out there.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |