UiPathTeam.GoogleSpreadsheet.Activities


#1

Interacts with Google Spreadsheet by calling Google API.

Package: UiPathTeam.GoogleSpreadsheet.Activities
Author: @Bogdan_Popescu


#2

@Bogdan_Popescu do u have any sample workflow how to use this activity or any documentation.


#3

Hi @Santosh_Chhotaray,

Here are some guidelines for using Google Spreadsheet Activities

1. Google Sheet Application Scope

a) Authentication

To use this app scope you’ll need a google service account, an encryption key and a password to encrypt that key.

b) Spreadsheet calls

To make requests to a Google Spreadsheet you’ll need to specify the SpreadsheetId

2. Read Range

Needs to have specified: Sheet, Range and optional IncludeHeaders
The output of this will be a DataTable object (Result property)
If you don’t specify the Sheet, it’ll use the default sheet of the Google Spreadsheet

3. Write Range

Needs to have specified: Sheet, Range, StartingCell and optional IncludeHeaders
Note: both read range and write should be very similar in usage as the ones from the excel package.