For Each Row in Spreadsheet

• Google Sheets connection - The connection for the Google Workspace account to use in the activity.
• Connection - The connection for the Google Workspace account to use in the activity.
• Spreadsheet - The Google spreadsheet file to use. Click the Folder icon to browse Google Drive folders and select a spreadsheet. This option accepts input as IResource. Use the Plus button menu to switch to Use variable or Url or ID input modes.
  • Spreadsheet URL - The URL of the spreadsheet of interest. This field is available when Url or ID is selected as the input mode. This property supports String variables and string formatted values.
  • Spreadsheet sample - The spreadsheet template to use. The field is visible after clicking Use spreadsheet template. Browse the Google Drive folders and select a spreadsheet. In Studio Desktop, the option is available from the Plus button menu next to Range type. To learn more, see Working with templates. This field accepts IResource input.

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

• Range - The range within which rows are iterated. This field is prepopulated with information retrieved from the selected spreadsheet or spreadsheet sample. This property supports String variables and string formatted values. Click the Plus button menu to select Update Ranges if you've performed changes in the spreadsheet ranges.

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

• Has headers - Specifies whether the first row in the range represents a header row. By default, True is selected. This property supports Boolean values.

Additional options

Input

• If row is empty - Indicates the behavior to follow when an empty row is iterated. The available options are Skip, Process, and Stop.
• What to read - Specifies what to read from the range. The available options are Values, Values, and Formulas, Text.

• Number of rows processed - The total number of rows processed by the activity. Can be used outside the For Each Row in Spreadsheet activity. Automatically generated output variable. You can use it as it is or save it with a different name.

Body

Known limitations for requests

See also:

• Sheets activities
• Read Range
• Read Cell
• Write Range
• Write Cell