I currently use a Google App Scripts on Google Sheets for my Seller Hike spreadsheet. Essentially, the way I have it set up is:
first i create project on Google cloud console.
enable google Sheet Api and configure with consent screen.
set Authorised JavaScript origin and Authorised redirect URIs (https://developers.google.com/oauthplayground).
open https://developers.google.com/oauthplayground for consent screen .
- a) Open setting and paste client id and secret key. b) complete 3 step (i) select Select & authorize APIs. (ii) Exchange authorization code for tokens. (iii) Configure request to API.*
project number enter in google app script Project Setting .
After follow these steps and process show authorisation error : 401 what is the solution of this Error ?