Overview
Smartsheet is a work management platform – spreadsheet + project + collaboration. The Automize Smartsheet connector covers sheets, rows, columns, attachments, reports, workspaces.
- Regions: Global SaaS.
- Plans: Pro + Business + Enterprise.
Setting up the connection
Auth type: Bearer Token.
- Smartsheet → Personal Settings → API Access → Generate token.
- In Automize → Settings → Connectors → Smartsheet. Paste token.
Find your credentials at https://app.smartsheet.com/b/home.
Rate limits
300 req/min.
Data model
Work management:
Workspace ─── Sheets ─┬─ Rows ─── Cells
├─ Columns
└─ Attachments
Reports (cross-sheet)Available operations
16 operations available. Click any row to jump to its detail.
| Operation | Category | What it does |
|---|---|---|
| Add Attachment | General | Add an attachment to a row |
| Add comment | General | Add a comment to a Smartsheet row. |
| Add Rows | General | Add rows to a sheet |
| Copy sheet | General | Copy a Smartsheet sheet. |
| Create sheet | General | Create a new Smartsheet sheet. |
| Delete Rows | General | Delete rows from a sheet |
| Get Report | General | Get report data |
| Get Sheet | General | Get sheet with all rows and columns |
| List Columns | General | List columns in a sheet |
| List discussions | General | List discussions on a Smartsheet sheet. |
| List Reports | General | List all reports |
| List Sheets | General | List all sheets |
| List Workspaces | General | List all workspaces |
| Search | General | Search sheets, rows, and reports |
| Share sheet | General | Share a Smartsheet sheet with users. |
| Update Rows | General | Update existing rows |
Operations
Add Attachment
Add an attachment to a row
| Parameter | Required | Type | Description |
|---|---|---|---|
Sheet Id sheet_id | Yes | text | |
Row Id row_id | Yes | text |
Add comment
Add a comment to a Smartsheet row.
| Parameter | Required | Type | Description |
|---|---|---|---|
Sheet Id sheet_id | Yes | text | |
Row Id row_id | Yes | text | |
Comment comment | No | textarea |
Add Rows
Add rows to a sheet
| Parameter | Required | Type | Description |
|---|---|---|---|
Sheet Id sheet_id | Yes | text |
Tips
- rows[]: each with cells[]: object_id (column) + value.
Copy sheet
Copy a Smartsheet sheet.
| Parameter | Required | Type | Description |
|---|---|---|---|
Sheet Id sheet_id | Yes | text | |
Destinationtype destinationType | No | text | |
Destinationid destinationId | No | text | |
Newname newName | No | text |
Create sheet
Create a new Smartsheet sheet.
| Parameter | Required | Type | Description |
|---|---|---|---|
Name name | Yes | text | |
Columns columns | No | text |
Delete Rows
Delete rows from a sheet
| Parameter | Required | Type | Description |
|---|---|---|---|
Sheet Id sheet_id | Yes | text |
Get Report
Get report data
| Parameter | Required | Type | Description |
|---|---|---|---|
Report Id report_id | Yes | text |
Get Sheet
Get sheet with all rows and columns
| Parameter | Required | Type | Description |
|---|---|---|---|
Sheet Id sheet_id | Yes | text |
Tips
- Heavy payload. Use ?columnIds= or ?rowIds= to scope.
List Columns
List columns in a sheet
| Parameter | Required | Type | Description |
|---|---|---|---|
Sheet Id sheet_id | Yes | text |
List discussions
List discussions on a Smartsheet sheet.
| Parameter | Required | Type | Description |
|---|---|---|---|
Sheet Id sheet_id | Yes | text |
List Reports
List all reports
No input parameters.
List Sheets
List all sheets
No input parameters.
Tips
- Filter by workspace.
List Workspaces
List all workspaces
No input parameters.
Search
Search sheets, rows, and reports
No input parameters.
Share sheet
Share a Smartsheet sheet with users.
| Parameter | Required | Type | Description |
|---|---|---|---|
Sheet Id sheet_id | Yes | text | |
Email email | Yes | text | |
Accesslevel accessLevel | No | text |
Update Rows
Update existing rows
| Parameter | Required | Type | Description |
|---|---|---|---|
Sheet Id sheet_id | Yes | text |
FAQ
- vs Airtable / Monday?
- Smartsheet: spreadsheet-feel, Gantt, project planning. Airtable: database-feel. Monday: visual board.