Label*

Default Value: Google Sheets Writer
Example: Google Sheets Writer

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.

Display Spreadsheet ID in Suggestions

Default Value: Deselected
Example: Selected

Checkbox

Select this checkbox to display Spreadsheets ID along with the Spreadsheet name in the Spreadsheets Suggestions list.

Spreadsheet*

Default value: N/A
Example: My Google Sheet

Specify or select the spreadsheet name or ID (or both) containing the worksheet to be written to. If the spreadsheet does not exist, you can type the name of the sheet to be created at the root level (My Drive).

Worksheet*

Default value: N/A
Example: Sheet1

Write Mode*

Default Value: Create new worksheet
Example: Append/edit existing worksheet

Dropdown list

Choose the type of write operation to perform for the specified worksheet. The available options are:

• Create New Worksheet: Creates a new worksheet.

• Append or Edit Existing Worksheet: Appends data to an existing worksheet or modifies an existing worksheet. Learn more through an example below.

Overwrite worksheet if it exists

Default Value: Not selected
Example: Selected

Checkbox

Select this checkbox to overwrite existing data if the worksheet exists.

Starting Cell Reference

Default Value: N/A
Example: A3

String/Expression

Specify the cell reference in A1 notation where the Snap should start writing the data in the existing worksheet. You can perform either of the following:

• Write new data to the worksheet by specifying a cell reference as the starting point.

• Append data to the worksheet at the last row in the worksheet containing content.

Write header row

Default Value: Selected
Example: Selected

Select this checkbox if the row containing column names should be written to the worksheet.

Parse data

Default value: RAW
Example: USER_ENTERED

Specify whether the input value must be preserved or parsed. Available options are:

• RAW: The input is not parsed and is inserted as a string. For example, "=1+2" places the string "=1+2" in the cell, not the implied result.
• USER_ENTERED: The input is parsed exactly as if it were entered into the Google Sheets UI. For example, "Mar 1 2016" becomes a date, and "=1+2" becomes a formula. Formats may also be inferred; so "$100.15" becomes a number with currency formatting.

Number of Retries

Default value: 3
Example: 5

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

Retry Interval (seconds)

Default value: 1
Example: 4

Specify the time interval in seconds for each retry attempt.

Read timeout in seconds

Default value:180
Example: 190

Specify the time limit in seconds for the Snap to read the data. If this limit is crossed, the Snap skips to the next batch of records.

Connection timeout in seconds

Default value: 20
Example: 10

Specify the time in seconds. In the event of a connection failure, the Snap stops a connection attempt after the specified time. For example, if the HTTP timeout is set to 30 seconds, and the Snap fails to establish a connection until 30 seconds, the pipeline logs a timeout exception and aborts execution.

Snap Execution

Default value: Execute only
Example: Validate & Execute

Select one of the three modes in which the Snap executes. Available options are:

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

Spreadsheet not found: <spreadsheet name>.

The spreadsheet may not exist or cannot
be accessed.

Verify that the spreadsheet exists and retry.

Invalid Write Mode.

Current Write Mode is not recognized.

Provide a valid Write Mode and run the Pipeline again.

Input data error.

Data is not a key-value pair.

Check the input data and try again.

Cell reference is invalid.

Cell reference does not follow A1 notation.

Provide the cell reference in A1 notation and retry.

Invalid range to write <number> columns starting at cell <cell reference>.

Range end column exceeds max column ZZZ.

Reduce the number of
columns in the written data or adjust the starting cell reference to fit all columns.

Failed to connect to Google account.

Google account is required

Add a valid Google account and retry.

Spreadsheet or Worksheet value is blank.

Spreadsheet and worksheet names are required

Verify that spreadsheet and worksheet names are provided

Invalid key name: null.

Null key is not allowed.

Verify that input document data do not contain any null keys.

Failed to initialize existing worksheet <worksheet name> for batch write.

Worksheet is not found.

Verify that the worksheet exists on the specified spreadsheet.

Failed to create a new worksheet for <worksheet name>.

Worksheet with the given name already exists.

Select the Overwrite worksheet if it exists checkbox or enter a different name for the worksheet then retry.