Migrating Google Sheets Pipelines from V3 to V4

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. 

Snap Setting Changes

• 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.

Functional Changes

• 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.

Known Issue

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.

Impact on Existing Pipelines

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.