The Google Sheets API allows developers to read, write, and format data in Google Sheets. Users can build pivot tables, enforce cell validation, set frozen rows, adjust column sizes, apply formulas, create charts, and more. The API offers full control over the content and appearance of spreadsheet data. Quickstart guides are provided in many common programming languages
Google announced in September of 2019 that they plan on ending support for V3 of the Google Sheets API, a decision that has drawn the ire of some developers. Version 4 of the API was announced at Google I/O 2016, almost 4 years before the seemingly inevitable deprecation of its predecessor.
Twelve APIs have been added to the ProgrammableWeb directory in categories including Financial, Cryptocurrency and Spreadsheets. Featured today is an API for Insurance brokers to fetch data about policies and customers, and an API for sonar imaging. Here's a rundown of the latest additions.