Connect Grist to 5pm

Both apps 53Grist 255pm 28

• Trigger
  New or Updated Record

  Triggered when a row in a Grist table is created or updated.

• Trigger
  New or Updated Record (Instant)

  Triggers when a Record is updated, or a new Record is added.

• Trigger
  New Record

  Triggered when a new row is added to a Grist table.

• Trigger
  New Record (Instant)

  Triggers when a new Record is created

• Action
  Add Column

  Adds a column to a table in a Grist document.

• Action
  Add Table

  Creates a new table in a Grist document, optionally with a starting set of columns.

• Action
  Create Document

  Creates a new document in a Grist workspace and returns its document ID.

• Action
  Create or Update Record

  Adds a row to a Grist table, or updates the existing row when the match column already holds the match value. Returns the row ID.

• Action
  Create Record

  Adds a new row to a Grist table and returns its row ID.

• Action
  Create Workspace

  Creates a new workspace in a Grist organization and returns its ID.

• Action
  Delete Document

  Deletes a Grist document permanently.

• Action
  Delete Records

  Deletes one or more rows from a Grist table by row ID.

• Action
  Delete Workspace

  Deletes a Grist workspace along with every document inside it.

• Action
  Find Record

  Searches a Grist table for a row whose column holds a given value and returns that row's ID and column values.

• Action
  Get Document

  Returns the details of one Grist document — its name, web address, workspace, and organization.

• Action
  Get Org

  Returns the details of one Grist organization (team site) — its name, subdomain, owner, and your access level.

• Action
  Get Workspace

  Returns the details of one Grist workspace, including the documents it contains.

• Action
  List Columns

  Returns the columns of a Grist table, with each column's ID, label, and type.

• Action
  List Orgs

  Returns every Grist organization (team site) this connection can reach.

• Action
  List Tables

  Returns the tables in a Grist document.

• Action
  List Workspaces

  Returns the workspaces in a Grist organization, each with the documents it contains.

• Action
  Run SQL Query

  Runs a read-only SELECT statement against a Grist document and returns the rows.

• Action
  Update Document

  Renames a Grist document or changes whether it is pinned. Anything left blank stays as it is.

• Action
  Update Record

  Changes the column values of one row in a Grist table. Columns left blank keep their current values.

• Action
  Update Workspace

  Renames a Grist workspace.

• Trigger
  New Progress

  Triggers when a new task progress is created.

• Trigger
  New Project

  Fires when a new project is created in 5pm (poll ProjectsService getList).

• Trigger
  New Task

  Triggers when a new support task is created.

• Trigger
  New User

  Triggers when a new support user is created.

• Trigger
  Updated Project

  Fires when a project is updated in 5pm (poll ProjectsService getList).

• Trigger
  Updated Task

  Triggers when a new support task is updated.

• Trigger
  Updated User

  Triggers when a new support user is updated.

• Action
  Add Task Progress

  Add Task Progress (progress in percent and house down).

• Action
  Add User

  Create a new user in the 5pm account (UsersService add).

• Action
  Create Note

  Creates a new note in task.

• Action
  Create Project

  Creates a new project.

• Action
  Create Task
• Action
  Delete Note

  Remove an activity note/progress message (ActivityService remove).

• Action
  Delete Project

  Remove a project (ProjectsService remove).

• Action
  Delete Task

  Remove a task from a 5pm project (TasksService remove).

• Action
  Delete User

  Remove a user from the account (UsersService remove).

• Action
  Find Project by Id

  Retrieve a single project by its id (ProjectsService getById).

• Action
  Find Task

  Finds a task in the application.

• Action
  Find Task by Id

  Finds a task by Id in the application.

• Action
  Find User by Email

  Retrieve a user by their email address (UsersService getByEmail).

• Action
  Find User by Id

  Finds a user by Id in the system.

• Action
  List Notes

  List activity notes/progress messages on a task (ActivityService getList).

• Action
  List Projects

  List all projects in the account (ProjectsService getAll/getList).

• Action
  List Users

  List all users in the account (UsersService getAll).

• Action
  Update Note

  Update an activity note/progress message (ActivityService update).

• Action
  Update Project

  Update a project's fields (ProjectsService update).

• Action
  Update Task

  Update task in the application.

• Action
  Update User

  Update a user's fields (UsersService update).

No trigger or action matches that. Ask your agent to add it: it reads the API documentation and builds what you describe.