...
- Go to the following URL link:
https://console.developers.google.com
- Click Enable APIS and Services.
- Search for Google Sheets API in the search box and select it.
- Click Manage.
- Click Credentials option from the menu on the left-hand side of the page.
- Click Create Credentials and select OAuth Client ID from the drop-down list.
- Click the Application Type drop-down and select Web Application.
- Enter the web application name in Name field. Here, Web client is provided as the name.
- Click ADD URI in Authorized JavaScript origins field and provide https://console.developers.google.com as the URI.
- Click ADD URI in Authorized redirect URIs field and provide https://developers.google.com/oauthplayground as the URI.
- Click Create.
- Make note of the Client ID and the Client Secret information from the pop up that appears once the OAuth client is created.
...