Google Spreadsheet API is migrating from v3 to v4 API as Google announces sunsetting the v3 API on June 8, 2021. This document explains the impact on your existing Pipelines that have the Google Sheets Snaps.
Check box for Batch Write field in the Google Sheets Writer Snap is removed as it is a default setting for v4.
Sheet API drop-down field in the Google Sheets Browser Snap to select v3 and v4 is removed.
Works in Ultra Pipelines.
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.
A bug in the Google Sheets endpoint does not allow the use of a colon ':' in worksheet names; hence, using a colon is not supported.
As the Sheet API drop-down field in the Google Sheets Browser Snap to select v3 and v4 is removed, the Spreadsheet Snaps themselves will execute fine but since the Snap output document format changes between v3 and v4, downstream mappings that expects the old document format will need to be updated in all such pipelines.