Grist Tools
Grist 是一个关系型电子表格平台，将电子表格的灵活性与数据库的稳健性相结合，使用户能够根据其数据需求创建定制应用程序。
让 AI 智能体使用 Grist Tools
Aident Loadout 让 Claude Code、Codex、Cursor 和其他受支持的智能体调用 Grist Tools。可选择 30 个受支持的操作。 可在 Audit 中审核每次执行。
通过 Aident Vault 连接一次 Grist Tools。智能体无需获取底层凭证即可使用受支持的操作。
分类
Productivity价格与支付
- 价格
- 在 Loadout 中免费。使用个人连接的账号时，服务提供商可能收费。
- 统一支付
- 暂不支持。需要时请连接服务提供商账号。
包含的操作
- Grist Add RecordsAdd one or more records to a Grist table. First use GRIST_LIST_WORKSPACES to get docId, GRIST_LIST_TABLES to get tableId, and GRIST_LIST_COLUMNS to get column IDs for the fields mapping.
- Grist Create DocumentCreates a new Grist document in a specified workspace. Use this tool when you need to add a new spreadsheet document to a workspace. Requires a valid workspace ID (obtainable via GRIST_LIST_WORKSPACES) and a document name.
- Grist Create Scim UserTool to create a new SCIM user. Use when provisioning new user accounts via SCIM. Run after gathering all required user details.
- Grist Create TableTool to create tables in a document. Use after confirming the document ID. Creates one or more tables with specified columns in the given document.
- Grist Create WebhookTool to create a new webhook for a specified document. Use when you need to register webhook endpoints for document events in Grist. Run after confirming document ID.
- Grist Delete AttachmentRemove unused attachments from a Grist document to free up storage space. IMPORTANT: This action removes ALL attachments that are not currently referenced by any cell in the document. It does NOT delete a specific attachment by ID. To remove a specific attachment: 1. First remov…
- Grist Delete ColumnTool to delete a column from a Grist document table. Use after confirming document, table, and column IDs.
- Grist Delete RecordsTool to delete records from a specified Grist table. Use when you need to remove specific rows by their IDs. Use after confirming the row IDs exist.
- Grist Delete Scim UserDelete a user from the Grist organization by their numeric user ID. Use GRIST_GET_USERS first to find the user's ID. Falls back to org access API if SCIM is not enabled. Note: Cannot delete your own account.
- Grist Delete WebhookPermanently removes a webhook from a Grist document. Use this tool when you need to stop receiving notifications for document changes. First use GRIST_LIST_WEBHOOKS to find the webhook_id you want to delete. This action is destructive and cannot be undone.
- Grist Download All Attachments ArchiveDownload all attachments from a Grist document as a single archive file (.zip or .tar). Use this to bulk-download attachments. Ensure the document has attachments before calling (check with GRIST_LIST_ATTACHMENTS). Returns an empty archive if no attachments exist.
- Grist Download AttachmentDownload a file attachment from a Grist document. Returns the file content as a downloadable file. Use GRIST_LIST_ATTACHMENTS first to get valid attachment IDs.
- Grist Fetch Document MetadataTool to fetch metadata for a specified Grist document. Use after obtaining the document ID.
- Grist Fetch Table MetadataTool to retrieve metadata for a specified table in a Grist document. Use when you need to inspect table schema details before data operations.
- Grist Get Org AccessRetrieves the list of users who have access to a Grist organization along with their access roles (owners, editors, viewers). Use this to find user IDs, emails, or check access permissions within an organization. Useful for user management tasks.
- Grist Get UsersTool to retrieve a list of users via SCIM v2. Use when you need to page through and filter enterprise users in Grist.
- Grist List AttachmentsTool to list all attachments in a Grist document. Use after confirming the document ID to retrieve attachment metadata.
- Grist List ColumnsTool to list all columns in a specified Grist table. Use after selecting the document and table to inspect column metadata.
- Grist List OrganizationsTool to list all organizations accessible to the authenticated user. Use when you need to select a Grist organization for subsequent operations.
- Grist List RecordsTool to retrieve records from a specified table within a Grist document. Use when you need to fetch rows by applying optional filters, sorting, limits, or hidden columns. Example: list records where pet is 'cat' sorted by '-age'.
- Grist List TablesTool to list all tables within a specified document. Use after obtaining the document ID to retrieve its tables.
- Grist List WebhooksList all webhooks configured for a Grist document. Returns webhook configuration details (URL, event types, table binding) and delivery status information. Use this to inspect, audit, or manage webhooks for a document. Requires a valid document ID obtained from GRIST_LIST_WORKSP…
- Grist List WorkspacesTool to list all workspaces and documents accessible to the authenticated user on the current site. Use when you need to select a workspace or document for subsequent operations.
- Grist Run Sql QueryTool to execute a read-only SQL SELECT query on a Grist document. Use after confirming the document ID and preparing a valid SQL SELECT statement.
- Grist Update Column MetadataUpdates metadata (label, type, description, formula, etc.) for one or more columns in a Grist table. Use List Columns first to get valid column IDs. Warning: changing 'label' may rename the column ID unless 'untieColIdFromLabel' is set to true.
- Grist Update Document MetadataTool to update metadata for a specified Grist document. Use when you need to rename or pin/unpin a document after obtaining its ID.
- Grist Update RecordsUpdate existing records in a Grist table by their row IDs. Use this tool to modify field values for one or more records in a specified document and table. First use GRIST_LIST_RECORDS to obtain the record IDs you want to update. Supports batch updates - you can update multiple r…
- Grist Update Table MetadataUpdate metadata properties for a table in a Grist document. Currently the main updatable property is 'onDemand' which controls lazy loading of table data. Use List Tables to find valid table IDs first.
- Grist Update WebhookUpdate an existing webhook configuration for a Grist document. Use to modify webhook settings such as URL, event types, enabled status, or target table. Requires valid document ID (from GRIST_LIST_WORKSPACES) and webhook ID (from GRIST_LIST_WEBHOOKS). Only provided fields will b…
- Grist Upload AttachmentUpload one or more file attachments to a Grist document. Returns attachment IDs that can be used to link files to records in Attachments-type columns. First use GRIST_LIST_WORKSPACES to get a valid document ID.