Google Sheets
Google Sheets is an online spreadsheet app that lets users create and format spreadsheets and simultaneously work with other people. Google Sheets isn’t only for consumers: it's used every day by businesses and schools to manage spreadsheet data. With the new Sheets API v4 and Sheets add-ons, that data can be accessed by code as well as users.
Rich integrations with Sheets data
The features that make Google Sheets so successful are available through the Sheets API. With the API, your code can access and update spreadsheets just like any other user. The API lets your apps:- Import, export and format Sheets data
- Control conditional formatting
- Build and edit charts embedded in a sheet
- Configure data validation
- Create and update named and protected ranges
- Add and adjust filtered views
- Create and manipulate pivot tables