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

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

• Spreadsheet - The Google spreadsheet to use. Select 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.

• Additional filters - Configure additional criteria to check on the created sheet. Supports filtering on the following fields: Sheet name.

Output​

• 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.

• Sheet created - The created sheet, which can be used further in the workflow. Automatically generated output variable. You can use it as it is or save it with a different name. You can use this in other activities.

• Sheets activities
• Write Row
• For Each Row in Spreadsheet