Automatización de Google Workspace

StudioX le permite automatizar las tareas que realiza en Google Workspace (anteriormente G Suite) mediante actividades dedicadas a Google Docs, Google Drive yGoogle Sheets. Para utilizar las actividades, primero debe abrirGestionar paquetesen la cinta de StudioX, seleccionarTodos los paquetesy, a continuación, buscar e instalar la última versióndel paquete UiPath.GSuite.Activities.

Después de instalar el paquete, las actividades están disponibles en las secciones GDocs GDrive y GHojas del panel Actividades.

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.

En las actividades en las que tienes que seleccionar archivos y carpetas, puedes utilizar el navegador de archivos incorporado de Google Drive directamente desde 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.