Smartsheet Utility Package

The Smartsheet Utility that allows users to Get Cell, Set Cell, Upload datatables and search for values. It helps extract sheets into A360 and insert blank rows

Top Benefits

  • It uses API method so UI does not have to be open while executing the commands
  • Unlike REST service command, it uses Row Number and Column Name instead of Row and column ID
  • It can help us avoid copying the data to excel and copying it back to Smartsheet for basic manipulations
  • Sheet Id and API Key can be added from Credential Vault to session for security

Actions

  • Get Cell value based on Row number and Column Name
  • Set Cell value based on Row number and Column Name
  • Extract the SmartSheet into a DataTable
  • Upload a DataTable into a SMartsheet to append the Data
  • Search for values in SmartSheet

The Smartsheet Utility Package helps in automating tasks that use the Smartsheet application. It allows users to manipulate Smatsheets using A360 using the Get Cell, Set Cell, Upload Datatable to Sheet, and Get Sheet As DataTable methods.
It allows us to search values in the Smartsheet and get the row number using the Search Value in Sheet action. Also, we can use the Get Number of Rows and Get Column Headers as a List option to iterate through the Smartsheet.

• It uses API method so UI does not have to be open while executing the commands.
• Unlike REST service command, it uses Row Number and Column Name instead of Row and column Id.
• Can help us avoid copying the data to excel and copying it back to Smartsheet for basic manipulations.
• Sheet Id and API Key can be added from the Credential Vault to session for security.

Success!

The download of Smartsheet Utility Package will begin shortly.

In your Control Room, use the ‘Import’ button to load the downloaded file into your Automations.

Get Package

Free

Bot Security Program
Level 1
Applications
Business Process
Category
Downloads
235
Vendor
Sachdeep Sivakumar
Automation Type
Package
Last Updated
June 15, 2022
First Published
May 19, 2022
Platform
Automation 360
ReadMe
ReadMe
Support

Bot Security

Level 1
  • All bots on Bot Store have passed a malware scan.

Bot Security Program

Automation Anywhere Bot Security is the RPA industry’s first of its kind bot security framework. In partnership with cyber security experts, Bot Security encompasses four (4) progressive levels of security designation. All bots including those built in-house or procured from Bot Store, can now be deployed reliably with secure bot development practices in alignment with prevailing Confidentiality, Integrity, and Availability (CIA) cybersecurity principles and best practices. View full Bot Security details.

See the Package in Action

Custom Actions
Get Cell Value
Set Cell Value
PREV NEXT
Custom Actions
Get Cell Value
Set Cell Value

Setup Process

Install

Download the Package and follow the instructions to install it in your AAE Control Room.

Configure

Use the Package in a bot, configure keys and other credentials the package will need (see the ReadMe for details.)

Run

That's it - now the Package is ready to get going!

Requirements and Inputs

  • Sheet Id of the Smartsheet should be provided as input
  • API Access should be enables and API Access Key should be provided.

About Bot Store

Automation Anywhere's Bot Store accelerates your robotic process automation initiatives by offering pre-built automations and plug-and-play integrations, so that complex business processes can be automated in days.

Bot Store