Troubleshooting
Fix SHEET_UNAVAILABLE
Check that the Google Sheet URL is valid and that anyone with the link can view it, or publish the Sheet to the web.
By Zainul Ariffin
- 1
Open the link in a private browser window
If Google asks you to sign in, SheetsDB cannot read the Sheet. Change its General access setting to Anyone with the link, Viewer.
- 2
Check the URL or spreadsheet ID
Use the full URL from Google Sheets. HTML-escaped links containing
&are normalized, but a shortened or copied partial URL can still fail. - 3
Try publishing to the web
In Google Sheets, use File, Share, Publish to web. Copy the published URL and send it as
sheetRef. - 4
Keep the request ID
Copy the
X-Request-IDresponse header when contacting support. It identifies the request without exposing the Sheet contents.
Review all accepted formats in Supported Google Sheet links.