Output

Document

• Min:0

• Max:1

• None

The name filter to select the desired spreadsheets.

Input

Document

• Min:1

• Max:1

• File Writer

• Transform

List of spreadsheets available in the provided folder matching the provided name filter. Provides Sheet ID, Sheet name, and Worksheets within.

Error

Error handling is a generic way to handle errors without losing data or failing the Snap execution. You can handle the errors that the Snap might encounter while running the Pipeline by choosing one of the following options from the When errors occur list under the Views tab. The available options are:

• Stop Pipeline Execution: Stops the current pipeline execution when the Snap encounters an error.

• Discard Error Data and Continue: Ignores the error, discards that record, and continues with the rest.

• Route Error Data to Error View: Routes the error data to an error view without stopping the Snap execution.

Learn more about Error handling in Pipelines.

Label*

Default value: Google Sheets Browser
Example: Google Sheets Browser

String

Specify the name for the Snap. You can modify this to be more specific, especially if you have more than one of the same Snap in your Pipeline.

Include Shared Drives

Default Value: Deselected
Example: Selected

Checkbox

Select this checkbox to write files from the shared drive.

Deselect this checkbox if you do not want the Snap to write files from the shared drive.

Name filter

Default value: None
Example: Filter1

String/Expression

Specify the GLOB pattern to look for spreadsheets having name patterns.

Fetch Mode

Default Value: Spreadsheets and Worksheets
Example: Spreadsheets

Dropdown list

Choose an option to fetch the Spreadsheets. The available options are:

• Spreadsheets and Worksheets: Fetches Spreadsheets and Worksheets within the Spreadsheet.

• Spreadsheets: Fetches only the Spreadsheets.

Number of Retries

Default value: 3
Example: 2

Integer/Expression

Specify the maximum number of retry attempts that the Snap must make to read the worksheet.

Retry Interval (seconds)

Default value: 1
Example: 2

Integer/Expression

Specify the time interval in seconds for each retry attempt.

Snap Execution

Default value: Validate & Execute
Example: Execute only

Dropdown list

Select one of the following three modes in which the Snap executes:

• Validate & Execute: Performs limited execution of the Snap, and generates a data preview during Pipeline validation. Subsequently, performs full execution of the Snap (unlimited records) during Pipeline runtime.

• Execute only: Performs full execution of the Snap during Pipeline execution without generating preview data.

• Disabled: Disables the Snap and all Snaps that are downstream from it.