Grist

grist is a collaborative spreadsheet database platform for managing data and automating workflows integrating grist with make com enables users to automate record creation, updates, and data synchronization between grist and 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/contact/ 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 in the top right corner to open the account menu click profile settings from the dropdown menu scroll down to the api section click the create button to generate an api key copy the api key displayed in your profile settings 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/#authentication 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 create new entries in a selected table within your database create a document generates a new blank document with no content create a workspace creates a new, empty workspace for your team (available only with team plans) delete table rows deletes specified rows from a selected table delete a document removes a specified document from your account delete a workspace permanently removes a specified workspace from your account get a document retrieves comprehensive details about a specific document get a document table as csv file retrieves the data from a table within a document and exports it as a csv file get a document as excel file retrieves the document's content and provides it as a downloadable excel file get a document as sqlite file retrieves the contents of a document and provides it as an 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, which are referred to as 'orgs' in the api, along with team sites list records from a table retrieves a list of data records from the specified source list table columns retrieves detailed information about all columns within a specified table list workspaces retrieves all workspaces that are accessible within your current domain list workspaces within organization retrieves all workspaces and their associated documents from 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 access permissions to 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 accessible with 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 in a specified table with new data update a document access updates the list of users or groups who are permitted to view or edit a specific document update a document metadata updates the metadata of an existing document without changing the document's actual content update a workspace modifies the details of an existing workspace update a workspace access modifies the list of users who can access the workspace by adding or removing their permissions update an organization modifies the details of a specified organization that already exists watch documents triggers when a new document is created or when an existing document is modified watch workspaces triggers when a new workspace is created or when an existing workspace is modified 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