You can use the Google Sheets Browser Snap to browse the given Google Drive folder and list the spreadsheet names matching the provided name filter. The Snap also displays the worksheets within each spreadsheet.
Inputs without any format restrictions are accepted when the expression toggle is enabled and a Pipeline parameter is provided for the following fields:
Number of Retries
Retry Interval
Read timeout in seconds
Connection timeout in seconds
For an expression input, the value is evaluated and accepted if it meets the expression criteria; if not, then the default value is used.
You will find the Snap fetching all worksheets in the output, regardless of whether they are hidden or protected.
Known Issue
A long-standing bug​ in the Google Sheets endpoint does not allow the use of a colon ':' in the worksheet names; hence, these inputs are not supported.
Snap Views
Type
Format
Number of Views
Examples of Upstream and Downstream Snaps
Description
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.
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.
Updated and certified against the current SnapLogic Platform release.
July 2024
437patches27197
Latest
Fixed an issue with the Google Sheets Writer Snap where using cell names as worksheet names caused incorrect data writing behavior.
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 the Google Spreadsheet Snap Pack and Snap names to Google Sheets.
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.