Handling Paginated API Responses in Google Apps Script

One of my favorite things about Google Apps Script is that I can get information from an API and write it directly to a shared document or spreadsheet. Information is collected automatically and immediately available to a group of people working on that same doc. It’s not uncommon for these requests to come back in… Read More »

Sending Charts from Google Forms

We’re getting ready to launch a digital teaching and learning course for staff that is based on the TPACK framework. A few years ago, we started our 1:1 training by coaching teachers through using SAMR to design lessons which really use the technology in new ways. This time, we’re having teachers do more metacognitive reflection… Read More »

Google Sheets, SpreadAPI, and an Extension

This is a revisit to a post I wrote four years ago in which we used a spreadsheet and Google’s nifty little hidden JSON data endpoint to serve data to a Chrome extension. Without going too deep, the extension needed to be updated. I took this chance to refactor using modern Javascript rather tha jQuery… Read More »