Google Sheets Snap Pack
- Kalpana Malladi
- Aparna Tayi (Unlicensed)
- Lakshmi Manda
In this article
Overview
The Google Sheets API provides you the ability to read and modify data in Google Sheets.
Use Snaps in this Snap Pack to:
- Browse for Google Sheets
- Read a worksheet within a Google Sheet
- Write to a worksheet within a Google Sheet
Snap Pack History
Release | Snap Pack Version | Date | Type | Updates |
---|---|---|---|---|
August 2024 | 438patches27861 | Latest | Added the Google Sheets - Google Service Account to connect Google Sheets Snaps with data sources that use Google Service Account. | |
August 2024 | main27765 | Stable | 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 |
| |
4.29 | 429patches16975 | Latest |
| |
4.29 | main15993 | Stable |
| |
4.28 Patches | 428 patches14755 | Latest |
| |
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 Writer Snap 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. | |
4.23 Patch | 423patches7848 | Latest | Enhanced the Snap Pack by migrating from version 3 to version 4 API as Google announces sunsetting the v3 API on June 8, 2021. For more information, see Migrating Google Spreadsheet Pipelines from V3 to V4. | |
4.23 | main7430 | Stable | 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. |
Related Links
Have feedback? Email documentation@snaplogic.com | Ask a question in the SnapLogic Community
© 2017-2024 SnapLogic, Inc.