Activities

Overview

Use the following lists to view all the cross-platform activities included in the Google Workspace activity package, under each category:

• Calendar

• Drive

• Gmail

• Sheets

• Tasks

• Trigger activities

These activities are also available in Studio Windows projects.

Note: These activities use Integration Service connections.

Using cross-platform activities

The activities in the cross-platform category are designed for cross-platform projects in Studio Web and Studio Desktop.

Connect to your Google Workspace account

When you add an activity that interacts with an online application using an Integration Service connector, you must select the connection for the account to use in that activity. The ConnectionId configuration field sets the connection for the Google Workspace account that is used in each Google Workspace cross-platform activity.

Google Workspace activities use the following connectors:

• Gmail for Calendar and Gmail activities.
• Google Drive for Drive activities.
• Google Sheets for Sheets activities.

Depending on whether or not connections are already set up in the Integration Service for the connector, one of the following may occur:

• No connection exists - You are prompted to add a connection in the activity. From the connection drop-down, select Add new connection to start the authentication process and enable the required permissions. For more information, see the Integration Service documentation for the connector you want to use.
• Connections already exist - Select a connection from the connection drop-down in the activity. The connection that is set as default is automatically selected. To add a new connection, select Add new connection from the drop-down.
• A connection is selected but is invalid - If a connection is selected, but no additional properties are available in the activity, this indicates the connection is broken. From the connection drop-down, select Manage connections to go to the Integration Service and fix the connection.

Iterate through items with For Each activities

The For Each activities (For Each Event, For Each File or Folder, For Each Email, For Each Sheet in Spreadsheet, For Each Row in Spreadsheet) execute an activity or a series of activities for each file, folder, email, or item in a specified Google Drive location.

Inside the body of a For Each activity, you can use a variable called CurrentItem, which refers to each item in the contained collection.

Add the activities to repeat inside the Body section of the For Each activity. When you configure these activities, indicate that you want to process each item in the iteration by selecting the CurrentItem variable for that item:

• CurrentEvent in the body of For Each Event
• CurrentItem in the body of For Each File or Folder
• CurrentEmail in the body of For Each Email
• CurrentSheet in the body of For Each Sheet in Spreadsheet
• CurrentRow in the body of For Each Row in Spreadsheet

Calendar activities

Set start and end dates and times

Activities such as Create Event let you choose the start and end date and time of that particular event. To set a start or end date and time, click the calendar icon next to the field to open the calendar widget and select the date and time. Alternatively, click the Plus button menu to use a variable. In Studio Web, you can also use one of the predefined snippets (Today, Yesterday, Tomorrow, StartOfNextWeek, StartOfNextMonth, Now).

Google Sheets activities

The Google Workspace cross-platform activities provide methods to create, extract, and insert data into Google Sheets, such as cells, ranges, and sheets.

Range types

Activities such as Read Range, Write Range, or For Each Row in Spreadsheet allow you use data from a specified range of cells in a spreadsheet.

There are several types of ranges that you can use: Range (named ranges whose scope is limited to a given spreadsheet), Sheet (entire sheets), or Default (which includes all the previous types and allows you to manually enter a custom range, e.g., Sheet1!A1:B6).

Indicating a folder or file

To indicate a specific folder or file to use in an activity, click the folder icon inside the fields that support it to navigate through your Google Drive or Gmail files and folders.