# Sheet Best Documentation > Turn your Google Sheets into a REST API ## docs ### faq Common questions about Sheet Best, authentication, formats, limits, and sheet access. - [Frequently Asked Questions](https://docs.sheetbest.com/docs/faq.md): Common questions about Sheet Best, authentication, formats, limits, and sheet access. ### generate-api - [Create a Connection](https://docs.sheetbest.com/docs/generate-api/create-connection.md): Connect spreadsheet rows or a read-only Google Drive file catalog to Sheet Best. - [Prepare your Sheet](https://docs.sheetbest.com/docs/generate-api/prepare-sheet.md): How Sheet Best reads your spreadsheet, and the share permissions it needs. - [Private Sheets](https://docs.sheetbest.com/docs/generate-api/private-sheets.md): Connect a private Google Sheet without making it publicly shareable. ### getting-started - [Overview](https://docs.sheetbest.com/docs/getting-started/overview.md): Sheet Best turns a Google Sheet into a REST API. - [Quick Start](https://docs.sheetbest.com/docs/getting-started/quickstart.md): Create your first Sheet Best REST API from a Google Sheet. ### guides - [Aggregating Data](https://docs.sheetbest.com/docs/guides/aggregations.md): Compute column-wise aggregations (sum, mean, max, ...) directly from the API using the /agg endpoint. - [Authentication & API Keys](https://docs.sheetbest.com/docs/guides/auth-api-keys.md): Protect your Sheet Best connection with an optional API key sent via the X-Api-Key header. - [Column Info](https://docs.sheetbest.com/docs/guides/column-info.md): Get a statistical summary of each column in your sheet using the /info endpoint. - [Deleting Rows (DELETE)](https://docs.sheetbest.com/docs/guides/crud-delete.md): Remove rows from your sheet by index or by filter. - [Reading Data (GET)](https://docs.sheetbest.com/docs/guides/crud-get.md): Read rows from your Google Sheet via the Sheet Best REST API. - [Updating Rows (PUT / PATCH)](https://docs.sheetbest.com/docs/guides/crud-patch-put.md): Update existing rows by index or by filter using PUT and PATCH. - [Adding Rows (POST)](https://docs.sheetbest.com/docs/guides/crud-post.md): Append one or many rows to your sheet with a POST request. - [Filtering Data](https://docs.sheetbest.com/docs/guides/filtering.md): Filter rows from a sheet by column value with exact matches, wildcards, and case-insensitive search. - [Pagination](https://docs.sheetbest.com/docs/guides/pagination.md): Paginate sheet results with the _limit and _offset query parameters or the row-index URL shortcuts. - [Pivoting Data](https://docs.sheetbest.com/docs/guides/pivot.md): Pivot a sheet around one or more columns and aggregate the remaining columns with /pivot/. - [Querying Data](https://docs.sheetbest.com/docs/guides/querying.md): Run numeric and date comparisons against a sheet using the /query endpoint and the __eq, __ne, __lt, __lte, __gt, __gte operators. - [Working with Tabs](https://docs.sheetbest.com/docs/guides/tabs.md): Target a specific tab of your Google Sheet by appending /tabs/ to any URL. ### integrations - [Call Sheet Best from Bubble](https://docs.sheetbest.com/docs/integrations/bubble.md): Use Bubble's API Connector to read and write rows in a Sheet Best connection. - [Call Sheet Best from GitHub Actions](https://docs.sheetbest.com/docs/integrations/github-action.md): Use curl in a GitHub Actions workflow step to read or write a Sheet Best connection. - [Call Sheet Best from n8n](https://docs.sheetbest.com/docs/integrations/n8n.md): Use n8n's HTTP Request node to read and write rows in a Sheet Best connection. - [Call Sheet Best from Webflow](https://docs.sheetbest.com/docs/integrations/webflow.md): Read and write Sheet Best data from a Webflow site using fetch in custom code, or render it declaratively with sheet-best-templates. ### mcp - [MCP Connections and Tools](https://docs.sheetbest.com/docs/mcp/connections-and-tools.md): Understand Sheet Best MCP endpoint scopes, available tools, permissions, pagination, filters, and row operations. - [Connect AI Assistants with MCP](https://docs.sheetbest.com/docs/mcp/overview.md): Use Sheet Best MCP to let an AI assistant work with your Google Sheet connections and rows. - [MCP Quickstart](https://docs.sheetbest.com/docs/mcp/quickstart.md): Enable Sheet Best MCP, generate a token, and connect an AI assistant to your Google Sheets. - [MCP Security and Tokens](https://docs.sheetbest.com/docs/mcp/security-and-tokens.md): Safely generate, pause, replace, and revoke Sheet Best MCP credentials. - [MCP Troubleshooting](https://docs.sheetbest.com/docs/mcp/troubleshooting.md): Diagnose Sheet Best MCP connection, token, permission, quota, tool, and sheet errors. ### reference - [Custom Request Headers](https://docs.sheetbest.com/docs/reference/custom-headers.md): Custom HTTP request headers Sheet Best understands. - [Error Codes](https://docs.sheetbest.com/docs/reference/error-codes.md): String error codes returned alongside 4xx responses. - [Data Formats](https://docs.sheetbest.com/docs/reference/formats.md): Reshape GET responses with the _format query parameter and return native types with _raw. - [HTTP Response Headers](https://docs.sheetbest.com/docs/reference/headers.md): Headers Sheet Best returns to help you monitor your sheet and quota. - [HTTP Status Codes](https://docs.sheetbest.com/docs/reference/status-codes.md): Status codes returned by the Sheet Best API and what they mean. ### troubleshooting Common errors and how to fix them. - [Troubleshooting](https://docs.sheetbest.com/docs/troubleshooting.md): Common errors and how to fix them.