We’re writing to let you know that Google Sheets v3 API will be shut down on March 3, 2020.

What do I need to know?

The Sheets v4 API, launched in 2016, opened new doors to custom development with programmatic access to critical features like conditional formatting, charts and pivot tables. Since then, Google has continually improved version 4 by supporting new Sheets features and introducing developer metadata.

As part of the migration to the Sheets v4 API, Google will shut down the Sheets v3 API on March 3, 2020.

To ensure projects originally built on the Sheets v3 API continue working long after it is gone, we have migrated our plugins(listed below) to the Sheets v4 API before March 3, 2020.

  • You can review this¬†migration guide which provides tips on how to transition our apps, including a mapping of operations in Sheets v3 API to operations in Sheets v4 API and some ideas for using the new functionality to your advantage.
  • Note that the Sheets v4 API does not provide the ‚ÄúList spreadsheets for the authenticated user” operation. However, this operation can be replicated via the¬†Drive API Files.list¬†method.

We have the following projects have used the Sheets v3 API:

  • CF7 GSheetConnector Free & Pro
  • WPForms GSheetConnector Lite & Pro

Here is the Article Link for more like what you need to do with our plugins after upgrading version.

CF7 Google Sheet Connector Free Version 4.0 updates