Google Sheets API
Last updated on
- Go to gSuite Additional Google services
- Search for
Google Cloud Platform
and click the checkbox
- Click
on
in the blue bar that appears above
Enable Google Drive API
- Go to Google Developers Console.
- If you see
Google Drive API
in the list of APIs at the bottom of the screen, click it and skip the remaining steps.
- Otherwise, click on
ENABLE APIS AND SERVICES
.
- Search for
Google Drive API
and click on it.
- Click on
Enable
.
Create API Credentials
- Click on
CREATE CREDENTIALS
- Select the options as shown below:

- Click on
What credentials do I need?
.
- Enter the details similar to shown below (name the service account after the client):

- Click
Continue
and save the downloaded JSON key file.
Access Google Sheets workbook
- Open the Google Sheets workbook that you need to access through APIs.
- Open the downloaded JSON key file and look for
client_email
.
- Share the workbook with the
client_email
address and grant Edit
permission.
- Uncheck
Notify People
since this email address is not handled by a human.
- Follow the respective API/library documentation for Google Sheets, for authentication and usage.