Productivity activities

Description​

Scopes​

• https://www.googleapis.com/auth/drive.readonly

• https://www.googleapis.com/auth/spreadsheets.readonly

• https://www.googleapis.com/auth/spreadsheets

• https://www.googleapis.com/auth/drive

Project compatibility​

Configuration​

• Google Sheets connection - The connection for the Google Workspace account to use in the activity.

• Spreadsheet - The Google spreadsheet to use. Click the Folder icon to browse Google Drive folders and select a spreadsheet.

  • Select the Reload File Data option if you've modified your folders and need to retrieve the latest data.

• Sheet name - The sheet to be monitored.

  • Select the Update Sheets option if you've modified your sheets and need to retrieve the latest data.

• Has headers - Specifies whether the first row in the sheet has headers. Boolean value.

• Spreadsheet - The Google spreadsheet file, saved as a GDriveRemoteItem variable. Automatically generated output variable. You can use it as it is or save it with a different name.
• Job Data - Contains job info, such as Process name, Process version, Workflow name, Robot name, and mode of execution. Row added - The row that was added to a sheet, saved to a DataRow variable. Automatically generated output variable. You can use it as it is or save it with a different name.

Example​

• Sheets activities
• For Each Sheet in Spreadsheet
• Read Range