This message is intended for developers and those who use Google APIs to pull information into other apps and systems. You may disregard this message if you do not use the Google Sheets API or other Google APIs.
As part of the migration to the Sheets v4 API, Google will retire the Sheets v3 API on March 3, 2020.
Make sure that projects originally built on the v3 API continue working long after it is gone. 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 get started on a new project or leverage the content and appearance controls not available in previous versions.
Three years ago Google introduced the Sheets v4 API, which offered 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 better control over which files to share with apps. Since its launch, Google has improved version 4 by supporting new Sheets features and introducing developer metadata.
If you’re new to using the Sheets API, be sure to check out the sample resources and videos on the developer site.