The Google Sheets API lets you read and modify any aspect of a spreadsheet. The updated API includes many new features that weren’t available in previous versions, including access to functionality found in the Sheets desktop and mobile user interfaces. At Google I/O 2016, we launched a new Google Sheets API—click here to watch the entire announcement. Getting started. With Sheets, you can: - Create new spreadsheets or edit existing files - Share spreadsheets and collaborate in the same spreadsheet at the same time. Google Cloud Platform lets you build, deploy, and scale applications, websites, and services on the same infrastructure as Google. Choose from hundreds of fonts, add links, images, and drawings. A recorded series of Google Sheets actions that you can quickly repeat using a menu item or shortcut key. Then add Google Drive API to our project which will allow us to access spreadsheet inside of Google Sheets for our account. The latest version of the Sheets API lets developers programmatically: Read and write data; Format text and numbers; Build pivot tables; Enforce cell validation; Set frozen rows; Adjust column sizes; Apply formulas; Create charts... and more! Posted by Wesley Chun (), Developer Advocate, Google Apps. Spreadsheets have many settings that let you craft beautiful and functional sheets, so the API has many settings too. By completing this codelab, you can learn how to employ data manipulations, custom menus, and public API data retrieval in Apps Script to improve your Sheets' experience.And, you can continue working with the SpreadsheetApp, Spreadsheet, Sheet, and Range classes that the previous codelabs in this playlist introduced. Method chaining: A programming idiom for invoking multiple method calls on object, relying on the fact that each method call returns the object itself. For example, you can associate "headerRow" with a particular row; or "totals" with a particular column. Create and edit web-based documents, spreadsheets, and presentations. - Work anywhere, anytime - even offline - Add and respond to comments. Google Docs brings your documents to life with smart editing and styling tools to help you easily format text and paragraphs. The API offers two main ways to interact with the spreadsheet: Reading/writing cell values only (via the spreadsheets.values collection). Get things done with or without an Internet connection. Store documents online and access them from any computer. Use Sheets to edit Excel files. Figure 2.1: Click on Enable Once that’s added, we need to create some credentials to access the API so click on Add Credentials on the … Create a new spreadsheet and edit with others at the same time – from your computer, phone or tablet. Create, edit and collaborate with others on spreadsheets from your Android phone or tablet with the Google Sheets app.