send_sheet_email
Send Sheet via Email
Send a sheet or specific rows via email to one or more recipients. Supports formatting options and optional CC to self.
send_sheet_email
Send a sheet or specific rows via email to one or more recipients. Supports formatting options and optional CC to self.
add_rows
Add one or more rows to a sheet. Each row contains cell values mapped to column IDs. Rows can be positioned at the top, bottom, or relative to other rows.
create_sheet
Create a new sheet with specified columns. Optionally create the sheet inside a folder or workspace. You can also create a sheet from a template by providing a template ID.
get_sheet
Retrieve a sheet's full data including columns, rows, and cell values. Optionally filter by specific columns or rows. Use this to read sheet structure and data.
list_workspaces
List all workspaces accessible to the current user. Workspaces are top-level containers for organizing sheets, reports, and dashboards.
manage_folders
Create, list, update, or delete folders. Folders can be created at the home level, inside a workspace, or as subfolders within other folders. Use the **action** field to specify the operation.
manage_columns
Add, update, or delete columns on a sheet. Use the **action** field to specify the operation. When adding columns, provide column definitions. When updating, provide the column ID and fields to change. When deleting, provide the column ID.
list_users
List all users in the organization account. Can filter by email address. Requires admin-level access or READ_USERS scope.
create_workspace
Create a new workspace. Workspaces serve as top-level organizational containers with their own sharing permissions.
share_resource
Share a sheet or workspace with users. Can list current shares, add new shares, update access levels, or remove shares. Access levels include VIEWER, EDITOR, EDITOR_SHARE, ADMIN, and OWNER.
search
Search across all accessible sheets or within a specific sheet. Returns matching results with context including the object type, parent sheet, and matched text.
list_reports
List all reports accessible to the current user, or get the full data for a specific report. Reports aggregate data from multiple sheets and are read-only.
list_dashboards
List all dashboards accessible to the current user, or get details for a specific dashboard. Dashboards (also known as Sights) aggregate information from sheets and reports into visual displays.
create_update_request
Send update requests to collaborators asking them to update specific rows in a sheet. Recipients receive an email with a link to update the specified rows.
delete_sheet
Permanently delete a sheet. This action cannot be undone.
delete_workspace
Permanently delete a workspace and all its contents. This cannot be undone.
update_rows
Update one or more existing rows in a sheet. Can modify cell values, move rows to different positions, lock/unlock rows, or change their parent hierarchy.
update_sheet
Update a sheet's properties such as its name. Can also copy or move a sheet to a different folder or workspace.
manage_discussions
List, create, or reply to discussions on sheets and rows. Discussions are threaded comment collections attached to a sheet or a specific row. Use **action** to specify the operation.
list_sheets
List all sheets accessible to the current user. Returns sheet metadata including names, IDs, access levels, and timestamps. Use pagination parameters to control result size.
delete_rows
Delete one or more rows from a sheet by their IDs. This permanently removes the rows and their data.
get_workspace
Get details of a workspace including its contained sheets, folders, reports, and dashboards.
get_current_user
Get the profile information of the currently authenticated user.
add_user
Add a new user to the organization. Requires ADMIN_USERS scope. The user will receive an invitation email.
Create, read, update, and delete sheets, rows, columns, and cells in a spreadsheet-like work management platform. Organize work into workspaces and folders with granular sharing permissions. Manage attachments, discussions, and comments on sheets and rows. Build and access dashboards and reports that aggregate data across sheets. Search across sheets, send sheets or rows via email, and create update requests for collaborators. Manage users, groups, contacts, and favorites. Set up webhooks for real-time change notifications on sheets and account-level events. Support cross-sheet references, automation rules, proofing workflows, templates, and event reporting for auditing actions.
Common questions about connecting Smartsheet to AI agents with Metorial.