The Snap conforms to the limitations imposed byGoogle Drive service.A spreadsheet may contain multiple worksheets. The cell count limit applies to the sum of the cells in all the worksheets in a spreadsheet.
If the spreadsheet or worksheet to which you want to write contains one or more leading or trailing spaces, the Worksheet Writer Snap does not function as expected:
If the spreadsheet name contains leading or trailing spaces, the Snap displays a "Spreadsheet not found" error.
If the worksheet name contains leading or trailing spaces, the Snap creates a new worksheet in the target spreadsheet using the worksheet name specified, without the extra space.
Workaround: Enclose the names of the spreadsheet and worksheet in quotes (") and enable expressions for both Spreadsheet and Worksheet fields.
Known Issue:
Page lookup error: page "Spreadsheets Browser" not found.
This Snap uses account references created on the Accounts page of SnapLogic Manager to handle access to this endpoint. This Snap uses a Google OAuth2 Account (Client ID, Client Secret, etc) or Google Dynamic OAuth2 Account (Access Token). See Configuring Google Spreadsheet Accounts for more information.
Views
Input
This Snap has exactly one document input view.
Output
This Snap has at most one document output view.
Error
This Snap has at most one document error view and produces zero or more documents in the view.
Settings
Label
Required. 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.
Spreadsheet
Required. The name of the spreadsheet 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.
Example: My Google Sheet
Default value: None
Worksheet
Required. The name of the worksheet to be written to. If the worksheet does not exist, you can type the name of the worksheet to be created.
Hidden and Protected sheets are not a part of worksheet suggestions. However, you can manually enter the name of the existing worksheet that is hidden or protected to enable the Snap to overwrite based on your account permissions.
Worksheets with hidden range appear in the suggestion list.
Worksheets with protected range do not appear in the suggestion list.
You can view the list of hidden sheets in the Google Sheets UI by clicking Viewand then selecting Hidden Sheets.
You can view the protected ranges in Google Sheets UI by clicking Data and then selecting Protected sheets and ranges.
Example: Sheet1
Default value: None
Overwrite worksheet if it exists
Select this option to overwrite existing information if the worksheet exists.
Default value: Not selected
Write header row
Select this option if the row containing column names should be written to the worksheet. Default value: Selected
Parse data
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.
Default value: RAW
Number of retries
Specify the maximum number of retry attempts that the Snap must make to write into the worksheet.
Default value: 3
Retry interval (seconds)
Specify the time interval in seconds for each retry attempt.
Default value: 1
Connection properties
Configure the connection properties to specify the read and connection timeouts.
Read timeout in seconds
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.
Default value: 180
Connection timeout in seconds
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.
Default value: 20
Snap execution
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.
Snap Pack History
Click to view/expand
Release
Snap Pack Version
Date
Type
Updates
May 2024
main26341
Stable
Updated and certified against the current SnapLogic Platform release.
February 2024
main25112
Stable
Updated and certified against the current SnapLogic Platform release.
November 2023
main23721
Stable
Updated and certified against the current SnapLogic Platform release.
August 2023
main22460
Stable
Updated and certified against the current SnapLogic Platform release.
May 2023
main21015
Stable
Upgraded with the latest SnapLogic Platform release.
February 2023
main19844
Stable
Upgraded with the latest SnapLogic Platform release.
November 2022
main18944
Stable
Upgraded with the latest SnapLogic Platform release.
August 2022
main17386
Stable
The Allow empty rows checkbox in the Worksheet Reader Snap allows you to output empty rows. Select this checkbox to include empty rows between other rows that contain data.
The Worksheet Writer Snap supports expressions for the Starting Cell Reference field. This Snap also includes a warning about potential overwriting of existing data for the Starting Cell Reference field when writing data in the same range of cells.
4.29
429patches16975
Latest
Fixed an issue with the Worksheet Writer Snap where the Snap failed to write data correctly after each batch write.
When the Write Mode is Create New Worksheet and Overwrite worksheet if it exists checkbox is selected, the cell data is shifted by five columns to the right after each batch in the resulting worksheet. Now, the data is written correctly in the worksheet.
Introduced the following Snaps:
Google Sheet Subscribe Snap that allows you to subscribe to the specified spreadsheet for notifications of the changes in the Google Sheet.
Enhanced the Worksheet Reader and Worksheet Writer Snaps with the Display Spreadsheet ID in Suggestions checkbox. You can select this checkbox to display both spreadsheet ID and the spreadsheet name in the suggestions. This helps you to choose among the spreadsheets having the same name.
Enhanced the Worksheet Writer Snap with the Write Mode dropdown list to perform the desired write option for the given worksheet—that is either create a new worksheet or append or edit an existing worksheet. You can write new data to the worksheet by specifying a cell reference as the starting point or append data to the worksheet at the last row in the worksheet containing content.
4.28 Patches
428 patches14755
Latest
Enhanced the Spreadsheet Browser Snap with the Fetch Mode dropdown list. You can fetch:
Spreadsheets and worksheets within that Spreadsheet, or
Only Spreadsheets.
4.28
main14627
Stable
Upgraded with the latest SnapLogic Platform release.
4.27
main12833
Stable
Upgraded with the latest SnapLogic Platform release.
4.26
main11181
Latest
Enhanced the Worksheet WriterSnap to populate the target schema preview with headers and associated data types (when the data is written to an existing worksheet with a valid header) in the upstream Snap.
4.25
main9554
Stable
Upgraded with the latest SnapLogic Platform release.
4.24
main8556
Stable
Upgraded with the latest SnapLogic Platform release.
Upgraded with the latest SnapLogic Platform release.
4.22
main6403
Stable
Upgraded with the latest SnapLogic Platform release.
4.21
snapsmrc542
Stable
Upgraded with the latest SnapLogic Platform release.
4.20
snapsmrc535
Stable
Upgraded with the latest SnapLogic Platform release.
4.19 Patch
google/spreadsheet8333
Latest
Fixed an issue with the Google Worksheet Reader Snap wherein the Snap produces output documents for empty rows.
4.19
snaprsmrc528
Stable
Upgraded with the latest SnapLogic Platform release.
4.18
snapsmrc523
Stable
Upgraded with the latest SnapLogic Platform release.
4.17 Patch
google/spreadsheet7283
Latest
Fixed an issue with the Google Worksheet Writer Snap wherein the No of valid records written field in the output document would count the header row.
4.17
ALL7402
Latest
Pushed automatic rebuild of the latest version of each Snap Pack to SnapLogic UAT and Elastic servers.
4.17
snapsmrc515
Latest
Added the Snap Execution field to all Standard-mode Snaps. In some Snaps, this field replaces the existing Execute during preview check box.
4.16 Patch
google/spreadsheet6995
Latest
Fixed an issue wherein the Spreadsheets Browser Snap fails if a spreadsheet name contains / or : in Windows plex.
4.16
snapsmrc508
Stable
Upgraded with the latest SnapLogic Platform release.
4.15 Patch
google/spreadsheet6835
Latest
Added a new property, Parse data, to the Worksheet Writer Snap which helps preserve the date data type.
4.15 Patch
google/spreadsheet6639
Latest
Added new properties, Preserve data types, Connection properties, Read timeout in seconds, and Connection timeout in seconds, to the Worksheet Reader Snap. These properties let you convert input data types to strings and handle connection timeouts. Also, fixed issues with header count, column count mismatch and rendering of columns with no headers.
4.15
snapsmrc500
Stable
Upgraded with the latest SnapLogic Platform release.
4.14 Patch
google/spreadsheet5730
Latest
Migrated Google Sheets from API v3 to v4. Implemented retries to overcome defects in Sheets API.
4.14
snapsmrc490
Stable
Upgraded with the latest SnapLogic Platform release.
4.13 Patch
spreadsheet5293
Latest
Fixed the Google Worksheet Writer Snap that incorrectly displays numeric values as a string in the spreadsheet when writing in batch mode. The spreadsheet now preserves the exact data type of the input value.
4.13
snapsmrc486
Stable
Upgraded with the latest SnapLogic Platform release.
4.12
snapsmrc480
Stable
Added the Batch write property in Worksheet Writer to enable writing the input documents into the worksheet as a single batch instead of writing the input data one cell at a time.
4.11
snapsmrc465
Stable
Upgraded with the latest SnapLogic Platform release.
4.10 Patch
spreadsheet3626
Latest
Addressed an issue where Worksheet Reader failed unexpectedly when validation mode input exceeded limitations.
4.10
snapsmrc414
Stable
Updated the Google Worksheet Writer Snap with Row count property to resolve the ' Data writing error'.
4.9.0 Patch
spreadsheet3104
Latest
Addressed an issue with Google Worksheet writer: Fails with " Data writing error "
4.9
snapsmrc405
Stable
Upgraded with the latest SnapLogic Platform release.
4.8
snapsmrc398
Stable
Upgraded with the latest SnapLogic Platform release.
4.7
snapsmrc382
Stable
Upgraded with the latest SnapLogic Platform release.
4.6
snapsmrc362
Stable
Upgraded with the latest SnapLogic Platform release.
4.5.1
snapsmrc344
Stable
Upgraded with the latest SnapLogic Platform release.
4.5
snapsmrc344
Stable
Enhanced the error view output to include error, reason, and resolution.