Productivity
Smartsheet
26 min
smartsheet is a collaborative work management platform for tracking projects, automating workflows, and managing resources integrating smartsheet with make com enables users to automate sheet updates, synchronize project data, and trigger notifications based on changes in smartsheet this is ai generated content based on official smartsheet documentation the content may contain mistakes please verify important information if you have questions on vendor documentation, contact https //help smartsheet com/es/contact directly requirements to use the smartsheet app in make, you must have an active smartsheet account and an api access token, https //www smartsheet com/ for subscription, refer to the https //www smartsheet com/ connect smartsheet and {{product name}} to get started, you must first create a connection between smartsheet and {{product name}} , allowing the two services to communicate obtain your oauth2 credentials in your smartsheet account create the connection in make obtain your oauth2 credentials in your smartsheet account before you create the connection in {{product name}} , you should first obtain your oauth2 credentials in your smartsheet account to obtain your oauth2 credentials click your account icon in the lower left corner in the smartsheet application click developer tools click create new app enter your app name , app description , app url , and contact information enter the callback uri https //www integromat com/oauth/cb/smartsheet click save copy the client id displayed in the confirmation window copy the client secret displayed in the confirmation window 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 //developers smartsheet com/api/smartsheet/guides/advanced topics/oauth create the connection in {{product name}} https //www make com/en/register , add the smartsheet 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 smartsheet account or follow the on screen instructions to create the connection for detailed information on connecting an application, see docid\ so88fm6pkt0g adkddfzz page smartsheet modules after connecting to the smartsheet app, you can choose from a list of available modules to build your {{scenario plural lowercase}} copy a folder duplicates the selected folder and all of its contents copy a sheet duplicates the selected sheet, creating an identical copy within your spreadsheet copy a workspace generates a duplicate of the selected workspace, including its current settings and content create a comment posts a new comment to an existing discussion thread create a folder creates a new folder in your sheets account, allowing you to choose its location—either in your home directory, within another existing folder, or inside a specific workspace create a row adds a new row of data to the selected sheet within your spreadsheet create a row (mappable) adds a new row to a selected sheet, allowing you to specify the sheet id for precise placement create a sheet creates a new spreadsheet sheet within your selected document create a user adds a specified user to your organization's account create a workspace creates a new workspace within your account delete a folder permanently removes the selected folder along with all files and subfolders it contains delete a row removes the selected row from the table or spreadsheet delete a sheet removes the selected sheet from your spreadsheet delete a workspace permanently removes the selected workspace from your account download a sheet retrieves a specific sheet as a pdf, csv, or excel file using the provided sheet id get my info retrieves detailed information about the currently authenticated user get a folder retrieves a specific folder and displays all the files and subfolders it contains get a row retrieves the details of a specific row from your selected table get a sheet retrieves the details of a specific sheet by its identifier get a workspace retrieves details about a specific workspace and displays all items contained within it make an api call executes a custom api request to the connected service using your authorized credentials move rows to another sheet transfers selected rows from one sheet and appends them to the bottom of a different sheet move a folder relocates the selected folder to a different destination within your storage move a sheet relocates the selected sheet within your spreadsheet to a different position new event triggers when a new event is created or detected in your connected application search everything searches through all accessible sheets for the user to find occurrences of the specified text search rows retrieves rows from a dataset that meet the specified conditions search sheets searches for specific text within a selected sheet update cells updates the values of selected cells within a specific sheet update a folder modifies the details or properties of a selected folder update a row updates the data in a selected row of your table update a row (mappable) updates an existing row in the selected sheet, allowing you to specify the sheet id for precise targeting update a summary field updates the content of a specified summary field in your selected record update a workspace modifies the details of a selected workspace upload an attachment upload a file to google sheets, including its rows and comments watch rows triggers when a new row of data is inserted into the specified table 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}} smartsheet resources you can have access to more resources related to this app on the following links https //community make com/search?q=smartsheet https //www smartsheet com/ https //smartsheet platform github io/api docs https //www make com/en/integrations/smartsheet