How to read and write data from smartsheet

Help Activities
1

Can anyone tell me how to read and write data from smartsheet

2

@Sailaja_Pasupuleti

You can use SmartSheet API for retriving the data

Check below link
https://smartsheet-platform.github.io/api-docs/

Hope this helps

Thanks

3

Thanks. Should we use http request activity in uipath studio ? If you have any sample xaml can you please post it?

4

@Sailaja_Pasupuleti

Yeah you have to use http request, Also you can refer the API documentation of SmartSheet

Sorry, unfortunately i don’t have any samples that i can provide

Mark as solution if this helps

Thanks

5

FYI we released an activity pack for Smartsheet that will remove the need to call APIs. You can download it from Connect at Smartsheet - RPA Component | UiPath Marketplace or via the official feed.

Full documentation is at https://docs.uipath.com/integrations/docs/smartsheet-about

There are 47 activities in the package and there is also a generic Invoke activity that conveniently wraps all 183 API operations for anything you want to do that we don’t have a bespoke activity for.

Please try it out and let us know what you think. :slight_smile:

1 Like
6

Hi @paul.hoeffer,

While I am able to add rows using “Smartsheet Add Rows activity” after the filled rows in the smartsheet. How can I add rows in the middle of the filled rows. For e.g. I want to add 1 row before row 4. I do not see or could not find online any way of doing that. Please advise.

Thanks,
Pawan Panjwani

7

Hi I am trying to do a very basic integration of Smartsheet into UiPath to read in rows or even just cells from a Smartsheet containing First Name, Last Name, Email Address and be able to copy that data into a list in Constant Contact. I installed the Smartsheet integration from UiPath Marketplace but I have 2 questions:

  1. do I have to do the setup with integration key or token? https://docs.uipath.com/activities/docs/smartsheet-setup#section-1-create-integration-key I have no idea how to do this and don’t understand the instructions (I am a beginner at using UiPath and the Smartsheet integration was not covered in class, but I would like to use it for my class project since it has practical benefit for me).
  2. I looked at the list of activities https://docs.uipath.com/activities/docs/smartsheet-activities but I don’t see a way to just copy or import rows or individual cells from a Smartsheet into a UiPath data table or variable?

What I am trying to do is copy First Name, Last Name, Email address from SmartSheet into UiPath variables and then copy those UiPath variables over into specified fields in Constant Contact. Is it possible to do “For each row in data table” in Smartsheet to copy info from Smartsheet into a UiPath data table? When I look at the activities, it looks like they all work within the Smarthsheets, but don’t transfer info over to UiPath datatable unless I am not understanding?

I would also be interested in using the Smartsheet Integration that I installed from the UiPath marketplace to download csv file from a Smartsheet and then use the csv file to do “for each row” to create data table in UiPath but I don’t know how to do that?

Anyone who can offer suggestions/advice / screenshots I’d really appreciate it.

8

Hi@pawan
Please let me know how you were able to add data row to existing smart sheet using UiPath activities. If possible please share a xaml file.