After entering my clientId, I'm getting a 'Error: Daily Limit for Unauthenticated Use Exceeded. Continued use requires signup. at https://api.observablehq.com/@gnestor/google-drive.js?v=3:52:12' in this cell.

Have you tried setting the `clientId` variable above?

I am receiving Error 400: redirect_uri_mismatch ... what redirect uri do I actually have to add to my authorized list to make this work ? I am an Observable/JS/OAuth newbie.

I tried 'https://snoopy.static.observableusercontent.com', but that ain't working.

I have "https://gnestor.static.observableusercontent.com" for my authorized Javascript origin and no authorized redirect URLs

I think I have changed the implementations since September, so you will also need to click the "Sign in" button at the top of notebook in order to auth with Google

Thanks a lot, Grant! When I changed my settings from web server to browser request it finally worked.

Excellent!

This one gives me a 'Error: The request is missing a valid API key. at https://api.observablehq.com/@gnestor/google-sheets.js?v=3:83:12' message

After creating a new OAuth clientId with extended scopes, I am now getting 'Error: The request is missing a valid API key. at https://api.observablehq.com/@gnestor/google-sheets.js?v=3:83:12 at async eval (observablehq-25:3:1)' when starting from a fresh notebook.

Have you tried setting the `clientId` variable above?

what's `Authorized redirect URIs` setting for this Client ID for Web application in Google? I got Error 400: redirect_uri_mismatch You can't sign in to this app because it doesn't comply with Google's OAuth 2.0 policy. If you're the app developer, register the JavaScript origin in the Google Cloud Console. Request details: origin=https://***.static.observableusercontent.com

there's always some errors, showing on the cells and in browser console Error: The request is missing a valid API key. at https://api.observablehq.com/@gnestor/google-sheets.js?v=4&resolutions=33e13207967f499f@43:102:12