Google provides a wide range of APIs allowing developers to integrate its services into their applications. In this article, you will learn how to generate a credential key to manage your Google Spreadsheet.
Step 1: Create a Google Cloud account.
Step 2: Click the NEW PROJECT button.
Step 3: Enter the name of your project and click CREATE.
Step 4: Go to Google Drive API and Google Sheets API, and click the ENABLE button.
Step 5: Click the MANAGE button.
Step 6: Click the Manage service accounts link in the bottom-right corner.
Step 7: Press the CREATE SERVICE ACCOUNT button.
Step 8: Enter the Service account name and jot down its email address. The email address will be used later.
Step 9: Select Editor as the Role.
Step 10: Click the DONE button after configuration.
Step 11: Select Manage Keys.
Step 12: Press the Create new key button.
Step 13: Down the private key. It can be used for Python automation later.
Congratulation, you have created a credentail.json file. You can now use the private key to manage your Google Spreadsheet.
The following article will teach you how to share a Google Spreadsheet with your Google Cloud service account.