# Sheetgo Developers > Developer documentation for Sheetgo: the REST API (manage workflows, automations, triggers, forms, dashboards and runs) and the MCP server (an AI assistant works directly in Google Sheets, Drive, Docs, PDFs, BigQuery and Gmail). Both use a Sheetgo API key: `Authorization: Bearer sg_…`. API base URL: https://api.sheetgo.com. MCP endpoint: https://api.sheetgo.com/mcp. Paths: every path in these docs is complete. Append it to the base URL exactly as shown, for example `GET /rest/beta/workflows/` is `https://api.sheetgo.com/rest/beta/workflows/`. The segment after `/rest/` is the API version (today `beta`). It is part of the path and cannot be left out: `/rest/workflows/` does not exist. A later version will have its own segment (for example `/rest/v1/`); always use the path shown for the endpoint. Only the OAuth routes (`/rest/auth/...`) have no version segment. Start with index.html to choose between the API and MCP. For an API request, read the group page of the endpoint: it contains the operation and every model it uses. Do not guess fields that are not shown. Every page also exists in Markdown: replace `.html` with `.md` (for example https://developers.sheetgo.com/api/workflows.md). ## Start - [Everything in one file](https://developers.sheetgo.com/llms-full.txt): every page below in Markdown, one after another. - [REST API in one file](https://developers.sheetgo.com/llms-api.txt) and [MCP server in one file](https://developers.sheetgo.com/llms-mcp.txt): smaller, one section each. - [Start here](https://developers.sheetgo.com/): API or MCP, the API key, scopes, glossary. - [MCP server](https://developers.sheetgo.com/mcp/): connect a client, how tools work, errors, permissions, and all 41 tools with parameters. - [REST API](https://developers.sheetgo.com/api/): auth, conventions, errors, quickstart, and the index of all 78 endpoints. ## REST API groups - [Workflows](https://developers.sheetgo.com/api/workflows/): A workflow is an automated process that connects your spreadsheets and files and moves data between them — on a schedule or on demand — so a task that would otherwise be manual runs by itself. It is the top-level container that holds automations, forms and triggers. - [Automations](https://developers.sheetgo.com/api/automations/): An automation (also called a connection) is a single data transfer inside a workflow: it pulls data from one or more sources, optionally consolidates, filters or merges it, and writes the result to one or more destinations — all without manual copy-paste. - [Triggers](https://developers.sheetgo.com/api/triggers/): A trigger defines what makes a workflow run automatically, so you set it once instead of running the workflow by hand. A trigger can be a recurring schedule (e.g. every 15 minutes, or every weekday at 09:00) or the completion of another workflow (chaining one run after another). Each workflow has at most one active trigger. - [Dashboards](https://developers.sheetgo.com/api/dashboards/): Dashboards turn a workflow's data into shareable visual summaries. Each workflow has a single dashboard; add indicator, table and chart-reference elements to it, read an element's live values, and publish the dashboard to get a viewer URL. - [Forms](https://developers.sheetgo.com/api/forms/): A Sheetgo form collects data straight into a workflow. Its fields come from your spreadsheet's columns, and every submission is appended as a new row — a simple way to feed a workflow from people instead of another system. - [Webhooks](https://developers.sheetgo.com/api/webhook/): A webhook is a private URL that lets external systems push data into a workflow over HTTP. Your app sends a JSON payload and Sheetgo lands it in the workflow — optionally triggering a full run — with no Google APIs or OAuth to manage on your side. - [API as destination](https://developers.sheetgo.com/api/api-destination/): API as a destination turns a workflow's output into a live, read-only JSON feed at a private URL. Each workflow run refreshes the data; consumers fetch it on demand with an API key, with pagination, sorting and conditional (ETag) requests. - [Integrations](https://developers.sheetgo.com/api/integrations/): Integrations are pre-configured sources for third-party services — currently Shopify and QuickBooks. Instead of describing an HTTP request yourself, you pick a data source from a menu and Sheetgo supplies the URL, credentials, pagination and response parsing for the account you authorized. - [Outlook email](https://developers.sheetgo.com/api/outlook/): Integration endpoints used by the Sheetgo add-in for Microsoft Outlook to connect mailbox data to workflows. - [Gmail](https://developers.sheetgo.com/api/gmail/): Read and send email through a connected Google account. - [Files and folders](https://developers.sheetgo.com/api/files/): Browse and search the storage providers connected to your account — Google Drive, OneDrive, SharePoint and Dropbox — to find the ids you need when building an automation. - [BigQuery](https://developers.sheetgo.com/api/bigquery/): BigQuery can be both a source and a destination for an automation: read a table or a query's results into a spreadsheet, or load a spreadsheet's rows into a BigQuery table. - [OAuth](https://developers.sheetgo.com/api/auth/): OAuth2 authorization endpoints — exchange a Client ID / Client Secret for an access token, for developer and customer integrations. For most use cases an API key generated on your Account page is simpler (see Authentication above). ## Reference - [Versioning and deprecation](https://developers.sheetgo.com/versioning/): what `beta` means, what counts as breaking, `Deprecation`/`Sunset` headers, MCP tool changes. - [Changelog](https://developers.sheetgo.com/changelog/): every change, newest first ([Atom](https://developers.sheetgo.com/changelog.xml)). - [OpenAPI spec](https://developers.sheetgo.com/openapi.json): the REST API in OpenAPI 3 (JSON), for code generators and tools. - [All models](https://developers.sheetgo.com/api/models/): 153 request and response models. - [Guides](https://developers.sheetgo.com/api/guides/): Rate Limiting, API Key Scopes, Smart Tags, Cell References. - [Python examples](https://developers.sheetgo.com/examples/): complete, tested recipes: API client helper; Read every page of a list; Create, run and wait for an automation; Find a file and build an automation payload; Call MCP tools from Python; Give an AI agent the Sheetgo tools. ## The API's own docs - [API index for LLMs](https://api.sheetgo.com/rest/llms.txt) - [API start page, Markdown](https://api.sheetgo.com/rest/reference.md) - [Everything in one file](https://api.sheetgo.com/rest/llms-full.txt) - [OpenAPI spec](https://api.sheetgo.com/rest/openapi.json)