Open a CSV file on Google Drive

Help
1

Hi ,

I’d like to use a Gsuite activity to open a CSV file on Google Drive as a Google Spreadsheets.
How should I do?
*I don’t want to use recoder.

Do you have any idea?

1 Like
2

Hi @dora

You can use the below component to work with google sheets. It’s similar to the way we automate normal spreadsheets installed in our machine…

https://go.uipath.com/component/google-gsuite

Install the component and use the activities listed under it to get your task done…

3

Hi,

There’s a package called UiPath.GSuite.Activities. You may want to explore on it under Manage Packages. image

Maybe you can combine Google Drive and Google Sheets Activities as per your requirement.

image

1 Like
4

Still now
there are only two way

  1. Gsuite
  2. web Recording
5

Hi, thank you for your reply.

I know to use GSuite Activity and could you please show me the detail?
What Activity do you use in Gsuite for CSV? Drive > Download File?

6

image
image551×650 12.1 KB

you can use all the above activities to work with Sheet in Drive.

7

Probably something like below:

  1. Download the CSV File
  2. Create New Spreadsheet
  3. Read New Spreadsheet.
8

Hi @VISHNU07,

I’d like to open a CSV file on Google Drive as a Google Spreadsheets.
And I use “Download File” activity but an error message appeared.

In this case, is it correct to use “File Download”?

FileID; https://drive.google.com/open?id=●●●●●●●●●●
LocalPath; “G:\●●●●●\●●●●●\●●●●●\●●●●●\●●●●●.csv”

It 'd be appreciated if you show a sample.

Thanks,

9

Hi,
I want to read a .CSV file from G drive and store it into Datatable. Kindly help if someone has an idea.

Thanks in Advance!!