Developers have used the Google Sheets API for all sorts of rich integrations with spreadsheet data. Why? Because reading, writing, and displaying data visually can drive more efficient decision-making in the workplace—just check out this real-time travel tracking and approvals app powered by the Sheets API.

Three years ago we introduced the Sheets v4 API, which opened new doors to custom development with programmatic access to critical features like filters, conditional formatting, charts and pivot tables. V4 API also enables batch methods for better performance, provides an easier-to-use interface, and operates on an individual file basis, which, when used with the drive.file scope, gives users better control over which files they want to share with apps. Since its launch, we’ve continually improved version 4 by supporting new Sheets features and introducing developer metadata. As part of the migration to the Sheets v4 API, which provides a better developer and user experience, we will be retiring the Sheets v3 API on March 3, 2020. 

We want to make sure that projects originally built on the v3 API continue working long after it is gone. To this end, this migration guide provides tips on how to transition your apps, including a mapping of older commands to operations in v4 and some ideas for using the new functionality to your advantage. Additional documentation is available to help you get started on a new project or leverage the content and appearance controls not available in previous versions. 

If you’re new to using the Sheets API, be sure to check out the sample resources and videos on our developer site. Continue to wow your colleagues by extending what’s possible with Sheets—give v4 a try.


Source: Google Cloud Blog