JavaScript, spreadsheets and API

on YouTube ↗24m

" summary

Claim: you can script spreadsheets with JavaScript to call real APIs, map JSON into rectangular results and show them in a sheet. Demonstrations use Google Sheets custom functions (Apps Script with a blocking UrlFetch), a MockAPI endpoint and a live Toggl time-entries aggregation that reduces five entries to three summaries. Code is tiny: fetch url parse JSON map to array-of-arrays. Caveats: synchronous runtime quirks, ECMA‑4 style limits, vendor lock‑in, no easy testing and duplicate invocations risk on writes.

AI-written summary · about

" chapters (14)

1. 0:00Introduction
2. 1:47Developers overbuild solutions
3. 3:14Spreadsheets power and limits
4. 5:21Why spreadsheets feel boring to developers
5. 6:43Scripting spreadsheets with JS
6. 8:27Demo: JS in Google Sheets
7. 10:13How spreadsheet API works
8. 12:40Real use case: Toggle API
9. 15:29Spreadsheets modify external data
10. 17:33Google Apps Script is JS
11. 19:20Google vs Microsoft Sheets
12. 20:45Risks of spreadsheet scripting
13. 21:50Spreadsheets as backend
14. 23:39Q&A

" related talks

• 21mSpreadsheets, Forms and ForksJessica Lord · Render Conference 2017
• 01h 16mExploring Google APIs with Python & JavaScriptWesley J. Chun · Silicon Valley Code Camp 2018
• 09mGoogle Apps ScriptAndrey Shulga · Frontend fwdays'17
• 24mThomas Wilburn - SeattleJS Conference 2017Thomas Wilburn · SeattleJS Conference 2017
• 09mLightning talk from Sean GroveSean Grove · ReactiveConf 2017
• 40mJavaScript ... for Science!Angelina Fabbro, Bill Mills · Strange Loop 2013
• 06mExcel JavaScript add-in APIsYu(Sky) Liu · Connect(); // 2015
• 52mWhat's New in JavaScript (ES 2020) - Part IIRaju Gandhi · Developer Summit 2020