You can create an account from Designer or Manager. In Designer, when working on pipelines, every Snap that needs an account prompts you to create a new account or use an existing account. The accounts can be created in or used from:
Your private project folder: This folder contains the pipelines that will use the account.
Your Project Space’s shared folder: This folder is accessible to all the users that belong to the Project Space.
The global shared folder: This folder is accessible to all the users within an organization in the SnapLogic instance.
Account Configuration
In Manager, you can navigate to the required folder and create an account in it (see Accounts). To create an account for Google Sheet:
Click Create, then select Google Sheets, then Google Dynamic OAuth2 or Spreadsheet Basic Auth Account.
Google OAuth2:
Supply an account label.
Click Authorize. You will be asked to log into a Google account. Log in with your user credentials, and after successfully logging in, you will be asked to provide permission for access. Access is required to make a connection.
Click Apply.
Google Dynamic OAuth2:
Provide a valid access token to make requests against OAuth2 enabled endpoints.
(Optional) Supply additional information on this account in the Notes field of the Info tab.
Avoid changing account credentials while pipelines using them are in progress. This may lead to unexpected results, including locking the account.
Known Issue
While authorizing accounts, force approval prompts you to request a new refresh token.
Account encryption
Standard Encryption
If you are using Standard Encryption, the High sensitivity settings under Enhanced Encryption are followed.
Enhanced Encryption
If you have the Enhanced Account Encryption feature, the following describes which fields are encrypted for each sensitivity level selected per each account.
High:
Medium + High:
Low + Medium + High:
Snap Pack History
Click to view/expand
Release
Snap Pack Version
Date
Type
Updates
November 2024
main29029
Stable
Updated and certified against the current SnapLogic Platform release.
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.