...
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 Spreadsheet Sheets Snaps.
Snap Setting Changes
Check box for Batch Write field in Worksheet field in the Google Sheets Writer Snap is removed as it is a default setting for v4.
Sheet API drop-down field in the Spreadsheets Google Sheets Browser Snap to select v3 and v4 is removed.
...
As the Sheet API drop-down field in the Spreadsheets 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.