Developers are up in arms over a forced migration to version four of Google Sheets in March 2020, saying the migration breaks numerous functionalities.
Google Sheets is a web-based software tool for creating and storing spreadsheets. The service uses Google Drive and can be integrated across G-suite. Sheets allows team members to edit and collaborate on spreadsheets in real-time.
A key feature used by programmers in Google Sheets v3 was the ability to run structured queries on Sheets that returned only matching rows.
This ability to run a complex search, which involved the filtering process happening inside the Sheets API, helped to