Google sheet to Excel Sheet in same drive

Help Studio
, ,
1

How can I retrieve data from a Google Sheet on Google Drive and save it to an Excel file in the same Google Drive using UiPath?

Forum Engagement Daily Reports
2

Hi @vihaannairca ,

Retrieving data from a Google Sheet and saving it to an Excel file on Google Drive is a common task. Let’s walk through the steps to accomplish this in UiPath.

First, do you have the Google GSuite activities package installed in UiPath Studio? This package will be necessary for interacting with Google Sheets and Drive.

Regards
Sandy

3

Yes, I have the Google GSuite activities package installed and using the same to achieve the task

4

Hi ,

  • Set Up Google Application Scope:

  • Read Data from Google Sheets:

  • Write Data to Excel File:

  • Upload the Excel File to Google Drive:

5

i have utilised the similar approach but unble to copy the forumulaes used accrsso the sheet

6

copy sheet would only copy the data , but you need not only data and also values use copy paste range you will have options to select paste type in that .

7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.