Procedures
Automation procedures in the Smartsheet book.
Make sure to add the Smartsheet book to your agent before using these automation procedures.
to add some content to a sheet
Append the contents of a table into an existing sheet.
Input Concepts
content
The table object to append.
table
Yes
(no default)
Output Concepts
Examples
Append the contents of a table in a sheet
get a sheet whose name is "Invoices"
>>>
create a table where
the column names are "Product Id", "Price"
insert a row in the table where
the Product Id is "00003"
the Price is 313
use the table as the content
>>>
add the content to the sheet
to get some (sheet's columns)
Get a sheet's columns.
Input Concepts
Output Concepts
Examples
Get the sheet's columns
get a sheet whose name is "Invoices"
get the sheet's columns
to get some (sheet's rows)
Get a sheet's rows.
Input Concepts
Output Concepts
Examples
Get the sheet's rows
get a sheet whose name is "Invoices"
get the sheet's rows
to get some (sheets)
Gets all sheets.
Output Concepts
Examples
Get all sheets
get some sheets
Get a sheet by name
get the sheet whose name is "Products"
to get some (workspaces)
Gets all workspaces.
Output Concepts
Examples
Get all workspaces
get some workspaces
Get a workspace by name
get a workspace whose name is "Workspace Name"
to insert a (new column) in a sheet
Inserts a column in a sheet.
Input Concepts
name
Name of column to add
text
Yes
(no default)
column type
Type of column to add
enum[abstract_datetime, checkbox, contact_list, date, datetime, multi_contact_list, multi_picklist, picklist, predecessor, text_number]
Yes
(no default)
index
Index of column to add (First index is 1)
number
Yes
(no default)
Output Concepts
Examples
Insert a new column at index
get a sheet whose name is "Products"
>>>
insert a new column in the sheet where
the name is "Product Type"
the column type is "TEXT_NUMBER"
the index is 2
to insert a (new row) in a sheet
Append a row in a sheet.
Input Concepts
values
List of values to insert
boolean
or number
or text
Yes
(no default)
Output Concepts
Examples
Append a new row to a sheet
get a sheet whose name is "Documents"
insert a new row in the sheet where
the values are 384230, "Invoice", "Completed"
to write the content in a workspace
Set the contents of a table to a new sheet.
Input Concepts
sheet name
The name of the new sheet.
text
Yes
(no default)
content
The table object to set in the sheet.
table
Yes
(no default)
Output Concepts
Examples
Set the contents of a table into a new sheet
get a workspace whose name is "Workspace Name"
>>>
create a table where
the column names are "Product Id", "Price"
insert a row in the table where
the Product Id is "00003"
the Price is 313
use the table as the content
>>>
write the content in the workspace
the sheet name is "Product Sheet"
Last updated
Was this helpful?