Google Workspace Automation

StudioX enables you to automate tasks you perform in Google Workspace (formerly G Suite) using dedicated Google Docs, Google Drive, and Google Sheets activities. To use the activities, you must first open Manage Packages from the StudioX ribbon, select All Packages, and then find and install the latest version of the UiPath.GSuite.Activities package.

After you install the package, the activities are available in the G Docs G Drive, and G Sheets sections of the Activities panel.

Google Docs

Start by adding a Use Google Document activity to select your account and add the resource to the automation, and then add the activities that interact with the document inside the resource activity.

For faster execution, you can add multiple Insert Text and Replace Text activities inside a Batch Document Updates activity. This creates a single batch of operations and sends them all at once to the server.

You can use the following Google Docs activities: Use Google Document, Batch Document Updates, Insert Text, Read All Text, Replace Text.

Google Drive

Start by adding a Use Google Drive activity to select your account and add the resource to the automation, and then add the activities that interact with Google Drive inside the resource activity.

In activities where you need to select files and folders, you can use the built-in Google Drive file browser directly from StudioX.

You can use the following Google Drive activities: Use Google Drive, Copy File, Create Document, Create Folder, Create New Spreadsheet, Download File, Move File, Share File, Upload File.

Google Sheets

Start by adding a Use Google Spreadsheet activity to select your account and add the spreadsheet to the automation, and then add the activities that interact with the spreadsheet inside the resource activity.

When working with Google Sheets activities, you can indicate sheets and named ranges directly from the Plus menu in StudioX.

For faster execution, you can add multiple Write Cell and Write Range activities inside a Batch Spreadsheet Updates activity. This creates a single batch of operations and sends them all at once to the server.

You can use the following Google Sheets activities:.Use Google Spreadsheet, Add New Sheet, Batch Spreadsheet Updates, Clear Range, Copy Sheet, Delete Range, Delete Sheet, Download Spreadsheet, Read Cell, Read Range, Rename Sheet, Write Cell, Write Range.