Google spreadsheet

studio
#1

Hello
I am beginner of uiPath, Please can someone help me with 1 sample how to use google spreadsheet and extract data from it. I am having tough time in understanding with the theory part.
Thank you.

#2

Hi Kuenzang,

Welcome! Please refer the G Suite activity from UiPath Go!:

Description from the above link:

Set of activities to interact with Google Drive, Sheets, and Gmail

Supercharge your productivity with a robot that can collaborate on spreadsheets, access stored files, and read emails all within Google Cloud.

This activity set has 16 components:

Google Drive
  • Find Files and Folders
  • Copy File
  • Move File
  • Create Folder
Gmail
  • Get Mail Messages
  • Send Mail Messages
Sheets
  • Create New SpreadSheet
  • Add New Sheet
  • Get Sheets
  • Read Cell
  • Read Column
  • Read Row
  • Read Range
  • Write Cell
  • Write Range
Authentication
  • GSuite Application Scope (API Key, Service Account, OAuth)

Click here for documentation on the activities.

Thanks & Regards,
Dominic

2 Likes
#3

Thank you

#4

Please can you give a demo of using activity as I don’t know how to use those activity, It would be thankful with 1 sample, as I am a slow learner :slight_smile:
Thank you. @Dominic

#5

@Kuenzang

Have you solved this ans?

#6

Yes I have.
Thank you

1 Like
#7

can you please upload the steps ?
or workflow file ? :slight_smile:

#8

can you share the demo project based on google sheets