Private Sheets
:::warning Beta Connect with Drive is currently in beta. Behavior and UI may change. :::
By default, Sheet Best needs link access to your sheet. Connect with Drive is an alternative that lets you connect a sheet that stays private — Sheet Best authenticates against your Google account through Drive permissions instead.
Connect with Drive
In the Sheet Best dashboard, start a new connection and choose Connect with Drive (or Load from Drive) instead of pasting a sheet URL. Authenticate with the Google account that owns the sheet, then pick the sheet from the list.
The resulting connection works like any other: the same https://api.sheetbest.com/sheets/<id> URL, the same CRUD methods, the same query and aggregation endpoints.
Trade-offs
- The sheet stays private — no link sharing required.
- Full CRUD works without changing sheet permissions.
- Re-authentication may be required occasionally.
- The feature is in beta and may have limitations.
Combine with API keys
Drive-connected sheets work with the X-Api-Key header just like any other connection. The sheet stays private in Drive, and the API itself is protected by the key. See Authentication.