Google Sheets

Help
1

Hi - is there a way to interact with Google Sheets other then thru the API? For example, copy from Excel, open google sheet and paste into it, etc? Thanks!

2

There’s the Google Spreadsheets package, allowing you to read and write ranges from/to a sheet: Community.Activities/Activities/Google Spreadsheet at master · UiPath/Community.Activities · GitHub

However, said package relies on the API as well.

3

@mz_psl

XLSToGoogleSheet.zip (8.8 KB)

Attached simple workflow copying from XLS and put it on the Google Worksheet (without using the Google API)

1 Like
4

I’ll give this s try, thanks!

One more semi-related question: is it possible to “loop” thru files in google drive folder without using the API?

5

Hi @mz_psl

See our GSuite component on Go! :slight_smile:
https://go.uipath.com/component/google-gsuite

6

this looks great, but it doesn’t show up in my package manager…

7

UiPath Go! is different to the package manager you use through Studio… you will have to go through Go! and download it for it become available

1 Like
8

Hey
there are GSuite activities available in UiPath. Here’s a video guide explaining how to use these activities