You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
This repository has been archived by the owner on Jan 27, 2022. It is now read-only.
Well, the settings for the spreadsheet were all wrong - I updated it to Publish to the web and also make sure the sharing settings were configured to allow anyone on the web to view (as per the README). However, now the provided script is failing with a 400 Bad Request error. Not sure what's going on there.
Thanks @samcday, sounds like there's a few things in play here:
I had it set to "Anyone with the link can edit", but you've pointed out that that was supposed to be "Anyone on the internet can find and edit", if I wanted to use an anonymous request. That makes sense, sorry for misreading the README.
Now my example above returns Error: HTTP error 400: Bad Request, as you mentioned.
The original error message, when the sheet's permissions are not set correctly, is confusing / does not indicate the problem.
It seems like 2. and 3. could each warrant filing an issue; shall I convert this one to address 3. (the error message) and file a new issue for 2.?
Sign up for freeto subscribe to this conversation on GitHub.
Already have an account?
Sign in.
Trying to load range
A1:A3
from this sheet.The text was updated successfully, but these errors were encountered: