Use the Getgrist connector to manage data with collaborative spreadsheets.
Integrating your application with Getgrist lets you use these operations in an automation. It exposes 20 actions, listed below. Add the connector from the Connections area, authenticate, then select its operations in the automation builder. Capabilities: actions.
Authentication
Before you begin, make sure you have the following information:
Connection Name: Choose a meaningful name for your connection. This name helps you identify the connection within your application or integration settings.
Authentication Type: The authentication method for this connector is defined in the connection setup. Select the connector in the Connections area to see the fields it requires.
Obtaining Your API Key
Log in to your Grist account.
Click your profile icon in the top-right corner and select Account Settings.
Open the Developer page from the settings menu.
In the API section, click Create to generate a new API key.
Copy the generated API key and store it securely for further authentication purposes.
Actions
Action Name | Description |
|---|---|
Create document in workspace | Creates a new document inside a workspace in Grist organisation |
Create workspace | Creates a new workspace for an organization in Grist |
Delete document | Delete a document by its ID in Grist organisation |
Delete organisation | Deletes an organisation in Grist |
Delete workspace | Deletes a workspace by ID in Grist organisation |
Get attachments | Get attachments for a document in Grist organisation |
Get document access | Get document access in Grist organisation |
Get organisation access | List users with access to organisation in Grist |
Get organisation details | Describes an organisation in Grist organisation |
Get organizations | List the organisations you have access to in Grist organisation |
Get table columns | Get the columns for a table in a document in Grist organisation |
Get table data | Get the data for a table in a document in Grist organisation |
Get table records | Retrieve all records from a table in a document in Grist organisation |
Get table schema | Get the schema for a table in a document in Grist organisation |
Get tables | List the tables in a document in Grist organisation |
Get workspace access details | List users with access to a workspace in Grist organisation |
Get workspace details | Describes a workspace in Grist organisation |
Get workspace documents | Describes a document in Grist organisation |
List organisation workspace | List workspaces and documents within an organisation in Grist |
List users with access to document in Grist organisation |