Turn Your Google Spreadsheets into a Web API

on YouTube ↗45m

" summary

Shows how to use Google Spreadsheets as a lightweight data store and expose their contents as web APIs using Google’s SDK and REST. Covers manipulating spreadsheets from Java apps with the Google SDK, adding a REST API in minutes to expose spreadsheet data, leveraging built-in spreadsheet functions, and enhancing those APIs with added value.

AI-written summary · about

" chapters (8)

1. 0:00Introduction
2. 3:55Java SDK for Sheets
3. 5:41Sheets creation
4. 15:52Data to API with Api Spark
5. 27:52Emerging API standards
6. 34:11API ecosystem
7. 40:13API integration
8. 44:51Future perspectives

" related talks

• 06mExcel REST API (Public preview)Sudhi Ramamurthy · Connect(); // 2015
• 31mWeb API Mashups in a Python ApplicationJohan Euphrosine · EuroPython 2011
• 23mScale up your business with API integrationMathieu Rasse · apidays Paris 2021
• 52mHow to simplify API integration with Meta APIMathieu Rasse · apidays Paris 2021
• 27mApidays Virtual Helsinki - Geir Sjurseth, Google CloudGeir Sjurseth · APIdays Helsinki 2020
• 47mDeveloping for the Google Apps MarketplaceCorentin Leclerc · DevFest Paris 2015
• 24mExploring an API with BlocksLarry Kluger · Apidays LIVE Paris 2020
• 21mFrom Web APIs to Cross-Device Web SitesJerome Louvel · APIdays San Francisco 2013