How to read google sheet data in uipath

Help
,
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,

https://forum.uipath.com/t/googlespreadsheet-activities/21092

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.

1 Like
5

HI @Rammohan91,

When I enter source address it gives warning like:

image
image1600×900 76.8 KB

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:

image
image1600×900 65.6 KB

any solution.

9

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

You should see something like this,

image
image1153×580 67.2 KB

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,
https://forum.uipath.com/t/google-spreadsheet-activities/14473/3?u=rammohan91

Thanks,
Rammohan B.

14

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

image
image705×669 34.7 KB

image
image687×631 38 KB

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 - RPA Listings - Collections, Integration Packs | UiPath Marketplace

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.

1 Like
20

@jmoore94 - might be useful.