Using Google Apps Script as a Webhook

Google Apps Script projects can be published as web apps when you’re done with them. This is helpful if you’re building a tool with a simple UI (using HTMLService), but they can also be used as webhooks to do work within a user account. Google provides the option of service accounts, so why use webhooks?… Read More »

New PD Site: SuperAdmins

A list of users with their name, location, email, and role. Each user has an Edit button available to the SuperAdmin.

Starting off with this project, I knew it would need a strong admin interface. One of the problems I mentioned initially is that all of the PD troubleshooting and administration went through me. That became a big burden, especially when presenters needed something done. The new platform includes a SuperAdmin area which can be used… Read More »

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 »