Automação do Google Workspace

O StudioX permite que você automatize as tarefas que executa no Google Workspace (Ex GSuite) através de atividades específicas para o Google Docs, Google Drive e Google Sheets. Para usar essas atividades, você deve primeiro abrir Gerenciar Pacotes na faixa de opções do StudioX, selecionar Todos os Pacotes e então encontrar e instalar a versão mais recente do pacote UiPath.GSuite.Activities.

Após instalar esse pacote, as atividades estarão disponíveis nas seções G Docs G Drive e G Sheets do painel Atividades.

Documentos Google

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.

Em atividades nas quais precise selecionar arquivos e pastas, você pode usar o navegador de arquivos do Google Drive integrado diretamente do 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.

Planilhas Google

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.