Request is missing required authentication credential. Expected OAuth 2 access token, login cookie or other valid authentication credential
Not possible. You need to use the OAuth login as indicated here in spreadsheets.values.batchUpdate: You can see on the authorization part that it uses OAuth scopes, therefore it follows that it uses OAuth not API KEY: Authorization Requires one of the following OAuth scopes: https://www.googleapis.com/auth/drive https://www.googleapis.com/auth/drive.file https://www.googleapis.com/auth/spreadsheets