Hoe to read the excel or google spread sheet from the google drive?

Help Activities
, ,
1

Hi All,

I need to read the data from the google spread sheet from the google drive
Can someone help me how can I can achieve this??

@Palaniyappan @ppr
@Yoichi
@Gokul001
@ushu
@geetishree_rao @hbomou7

2

I need to read the google drive from the below path:

3

@Vrishchik

You can use gsuite activities

references

cheers

4

@Vrishchik

you can use the UiPath GSuite activities package to achieve this. Make sure you have the package installed.

dataTable = New GoogleSheetReader("YourCredentialFile.json", "YourSpreadsheetId", "YourSheetName").ReadSheet()

cheers…!!!

5

I need to read an excel file which is present in the google drive.
Can someone help me to achieve this??
Need to read the data from the below path:

@Palaniyappan
@ppr
@Yoichi
@Sudharsan_Ka
@Rahul_Unnikrishnan
@Gokul001

6

Duplicate topic : Hoe to read the excel or google spread sheet from the google drive?

7

Hi @Vrishchik

You can use the Read range activity which is under the google in activities.
image

image

Note : For using this activity you have to install the UiPath.GSuite.Activities package from Mange Packages.

Hope it helps!!

8

Hi @Vrishchik

You can Use the Read Range activity which is under Google it will directly install the Gsuite Package for you and then you can connect your account and give permissions. Once done you can select the sheet from which folder you want to access and create an output DataTable Variable to write it to another excel locally

image

9

Getting error like this:
CreditMemo_InvoiceDirectReversalFramework/InputGoogleSheet.xaml: Errors: Excel column Column AG is empty

10

If you have any empty columns it shows that Error

11

How can I resolve that??

12

@Vrishchik
For testing can you select any other excel which doesn’t have any empty columns
Or else remove the entire empty column from your sheet