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 dataThe 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
Sheets Add-ons (built with Apps Script) let you add custom menus, sidebars and dialogs to Sheets. You can also use the Apps Script platform to connect to other services, such as Drive, Gmail, Calendar and even third-party services. Any add-ons you build can be shared with others in the Add-on store.
You can define custom formulas using Apps Script. Just create the function in an add-on or in a script bound to the sheet, and you'll be able to use it like any other built-in formula.
The Google Chart tools allow you to visually organize your data for websites or applications. You can use Sheets as a datasource for Google Charts, and embed a chart in a sheet. The Sheets API gives you control over charts within your Sheets as well.