Skip to main content

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.

This selects one spreadsheet and creates a Google Sheets connection at https://api.sheetbest.com/sheets/<connection-id>. Each connected spreadsheet uses one connection slot. Supported row operations use the same endpoints as other Google Sheets connections, subject to the connection's allowed methods, your Google permissions, and your plan.

This picker is separate from a Google Drive folder connection. A folder connection lists file metadata; it does not expose spreadsheet rows or automatically connect the spreadsheets inside it.

Trade-offs​

  • The sheet stays private — no link sharing required.
  • Read and write operations use the connected account's Google permissions. Writes require edit access.
  • 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.

Next​