How to read google sheet data in uipath

activities
studio

#1

Hi,

I want to read google sheet data in uipath.
I am using uipath community version 2018.1.3.

Thanks,
@Sam


#2

@sams Never tried. But did you got chance to check this,

Thanks,
Rammohan B.


#3

Thanks for replying @Rammohan91,

I cant understand, How to install package in uipath community?

thanks,
@Sam


#4

Hey @sams,

Follow as below,

  1. Under Activities, Click on Manage Packages.
  2. Right Click on the left most pane and Click ‘Configure Source’.
  3. Click on ‘+’ and add a name for the Package.
  4. Enter Source as ‘https://gallery.uipath.com/api/v2’ and click OK.
  5. Expand ‘Available’ under Manage Package window. Package source just added would be displayed there.
  6. Select that package source, look for UiPathTeam.GoogleSpreadsheet.Activities and Click Install.

Once installed you should see some activities to play around with under ‘Activities’ panel.

Let me know if it helps.

Thanks,
Rammohan B.


#5

HI @Rammohan91,

When I enter source address it gives warning like:

any solution for this?


#6

Remove the quotes for the url under source field.

Thanks,
Rammohan B.


#8

@Rammohan91,

In PackageSource no package found,

like:

any solution.


#9

That’s strange. Can you please close, restart the studio and check?

You should see something like this,

Thanks,
Rammohan B.


#10

Thanks @Rammohan91,
when I restart the uipath it works.

Once again thakyou for helping.:grin:


#11

@sams Great. Happy to help. :slight_smile:

Thanks,
Rammohan B.


#12

Hi @Rammohan91,

in google sheet activities,

  1. google sheet application activity:- in authentication whats is key path,
    password,serviceaccountemail,spreadsheetId?

  2. read range:- in input, whats is range, sheet?
    How to write range in input?


#13

Hey @sams,

Check this,

Thanks,
Rammohan B.


#14

Hi @Rammohan91,
it is strange that i can’t find the google sheet activities



Can you tell me where i can find it ?
Thanks alot.:grinning:


#15

@Rinaaaaaa Check the next page. Click on ‘>’.

Thanks,
Rammohan B.


#16

@Rinaaaaaa,
Follow as below,

Under Activities, Click on Manage Packages.
Right Click on the left most pane and Click ‘Configure Source’.
Click on ‘+’ and add a name for the Package.
Enter Source as ‘https://gallery.uipath.com/api/v2’ and click OK.
Expand ‘Available’ under Manage Package window. Package source just added would be displayed there.
Select that package source, look for UiPathTeam.GoogleSpreadsheet.Activities and Click Install.
Once installed you should see some activities to play around with under ‘Activities’ panel.

Thanks,
@sams


#17

Hi - I have installed the package but I don’t have the Google API. Is that a requirement as I am unsure whether I am able to download that?

Thanks in advance.


#18

@mshannon Did you installed it from nuget gallary? Here - https://gallery.uipath.com/packages/UiPathTeam.GoogleSpreadsheet.Activities/

Google Spreadsheet activity are dependent on Google Apis. If you install your package from the gallery then it should automatically install dependencies with it.

Let us know if you see any issue and the activities doesn’t work.

Thanks,
Rammohan B.


#19

Hi @Rammohan91 - The link worked. Thanks, the previous link I had tried was asking me to install the dependencies first. @rwoodurn1 - try this link.


#20

@jmoore94 - might be useful.