Run Script

UiPath.GSuite.Activities.RunScriptConnections

Description

Runs a function in a Google AppsScript project. The script project must be deployed for use with the Apps Script API, and the calling application must share the same Cloud Platform project.

To learn how to configure your Google Workspace script, check Execute Functions with the Apps Script API.

Scopes

This activity requires any one of the following scopes:

• https://www.googleapis.com/auth/drive
• https://www.googleapis.com/auth/documents
• https://www.googleapis.com/auth/forms
• https://www.googleapis.com/auth/spreadsheets
• https://www.googleapis.com/auth/sqlservice
• https://mail.google.com/
• https://sites.google.com/feeds
• https://www.googleapis.com/auth/groups
• https://www.googleapis.com/auth/userinfo.email
• https://www.googleapis.com/auth/spreadsheets.currentonly
• https://www.googleapis.com/auth/script.projects
• https://www.googleapis.com/auth/script.projects
• https://www.googleapis.com/auth/script.webapp.deploy
• https://www.googleapis.com/auth/script.storage
• https://www.googleapis.com/auth/script.send_mail
• https://www.googleapis.com/auth/script.external_request
• https://www.googleapis.com/auth/script.cpanel
• https://www.googleapis.com/auth/forms.currentonly
• https://www.googleapis.com/auth/dynamiccreatives
• https://www.googleapis.com/auth/documents.currentonly
• https://www.googleapis.com/auth/admin.directory.user
• https://www.googleapis.com/auth/admin.directory.group
• https://www.google.com/m8/feeds
• https://www.google.com/calendar/feeds
• https://apps-apis.google.com/a/feeds/groups/
• https://apps-apis.google.com/a/feeds/alias/
• https://apps-apis.google.com/a/feeds

Project compatibility

Windows | Cross-platform

Configuration

• Google Drive connection - The connection for the Google Workspace account to use in the activity.
• Deployment ID - The ID of the deployment to be executed. This property supports String variables and string-formatted values.
• Function - The name of the function to execute in the given script. The name does not include parentheses or parameters. It can reference a function in an included library, such as Library.libFunction1. This property supports String variables and string-formatted values.

Properties

Input

• Development mode - Select if you want to run a script in development mode, instead of production mode. Boolean value, default: False. If you enable this option, it replaces the Development ID field with the Script ID field.
• Parameters - The parameters to be passed to the function being executed. The object type for each parameter should match the expected type in Apps Script. Parameters cannot be Apps Script-specific object types, such as Document or Calendar. They can only be primitive types such as string, number, array, object, or boolean.

Output

• Result - The result of the function.