IT and Development
Grist
23 min
grist is a collaborative spreadsheet database platform that lets users organize, analyze, and automate data integrating grist with make com allows users to automate data syncing, trigger workflows from record changes, and manage documents across other business tools this is ai generated content based on official grist documentation the content may contain mistakes please verify important information if you have questions on vendor documentation, contact https //www getgrist com/ directly requirements to use the grist app in make, you must have an active grist account and an api key, https //www getgrist com/ for subscription, refer to the https //www getgrist com/ connect grist and {{product name}} to get started, you must first create a connection between grist and {{product name}} , allowing the two services to communicate obtain your api key in your grist account create the connection in make obtain your api key in your grist account before you create the connection in {{product name}} , you should first obtain your api key in your grist account to obtain your api key click your profile picture or initial at the top right of the screen to open the account menu click profile settings from the dropdown menu scroll down to the api section click the create button to generate a new api key copy the api key displayed in the modal you will use this value while creating a connection in {{product name}} because the ui might have changed, the steps you see on your screen might be different, https //support getgrist com/rest api/ create the connection in {{product name}} https //www make com/en/register , add the grist module to your {{scenario singular lowercase}} , and click create a connection if you add a module with an instant tag, click create a webhook , then create a connection optional in the connection name field, enter a name for the connection enter the authentication credentials you copied from your grist account or follow the on screen instructions to create the connection for detailed information on connecting an application, see docid\ so88fm6pkt0g adkddfzz page grist modules after connecting to the grist app, you can choose from a list of available modules to build your {{scenario plural lowercase}} add records to a table add new entries to a selected table in your database create a document generates a new blank document with no content create a workspace creates a new, empty workspace for your team note workspaces are only available with team plans delete table rows deletes specified rows from a selected table delete a document permanently removes a specified document from your account delete a workspace permanently removes a specified workspace from your account get a document retrieves comprehensive details and metadata for a specified document get a document table as csv file extracts the data from a table within a document and provides it as a downloadable csv file get a document as excel file retrieves the document's data and provides it as a downloadable excel ( xlsx) file get a document as sqlite file retrieves the full contents of a document and provides it as a downloadable sqlite database file get a workspace retrieves comprehensive details about a specific workspace, including its settings and properties get an organization retrieves comprehensive details about a specific personal space, including its settings and attributes list organization users retrieves a list of all users who have access to the specified organization list organizations retrieves a list of your personal spaces, referred to as 'orgs' in the api, excluding team sites list records from a table retrieves a list of records from your selected data source list table columns retrieves and displays all columns from a specified table list workspaces retrieves a list of all workspaces that are accessible within your current domain list workspaces within organization retrieves a list of all workspaces and their associated documents within a specified organization list a document users retrieves a list of all users who have permission to access a specific document list a workspace users retrieves a list of all users who currently have permission to access the specified workspace make an api call executes a custom api request to the connected service using your authorized credentials move a document transfers a document from its current workspace to a different workspace within the same organization this feature is available exclusively to users on a team plan update organization access updates the list of users who have permission to access the organization update records of a table updates existing records within a specified table update a document access updates the list of users or groups who can view or edit a specific document update a document metadata updates the metadata information of an existing document without changing its actual content update a workspace updates the details or settings of an existing workspace update a workspace access updates the list of users who can access the specified workspace update an organization updates the details of an existing organization, such as its name, address, or other relevant information watch documents triggers whenever a new document is created or an existing document is modified watch workspaces triggers when a new workspace is created or when an existing workspace is updated templates you can look for more templates in https //www make com/en/templates , where you'll find thousands of pre created {{scenario plural lowercase}} grist resources you can have access to more resources related to this app on the following links https //community make com/search?q=grist https //www getgrist com/ https //support getgrist com/api/ https //www make com/en/integrations/grist