Google Script to loop folder contents and copy Google Sheets content

I helped one of our athletic directors do some budget sheets for different teams. We then needed to add an additional sheet to all the workbooks and copy over content from a similar page. Given it’s about 20 or so workbooks, I scripted it.   […]

Read More… from Google Script to loop folder contents and copy Google Sheets content

Google Sheets JSON the Long Way

Ever since Google turned off direct access to the JSON data from Google Sheets, I’ve used a couple of App Script workarounds. They were a bit clumsy for what I was doing but better than re-writing the entire page. I find going through the whole oAuth and Google project process to be more hassle than […]

Read More… from Google Sheets JSON the Long Way

Google Sheet Web Scraping Example

The Context Middlebury has an interesting setup. They call them Go Links. It’s basically a version of tinyURL that anyone at Middlebury (students included) can use to make customized Middlebury links. If you’re on campus, you can use go/whatever and off-campus you have to use go.middlebury.edu/whatever.1 This replaced a giant redirect list. I’m not sure […]

Read More… from Google Sheet Web Scraping Example

Send Email to Different Addresses Based on Form Responses in Google Script

That title’s SEO gold, Jerry! I’ve used this pattern several times recently so I figured I’d write it up and break up the endless stream of “Weekly Web Harvest” posts. Google Forms are great but the options for doing more with emails are limited. Often people want to be alerted to a submission or to […]

Read More… from Send Email to Different Addresses Based on Form Responses in Google Script

Parallel Practice Logging in Google Forms/Sheets

The goal of this project was to have students logging their practice on translation and a separate non-translation activity.1 It’s a neat idea and I proposed doing it via Google Forms/sheets because it was a really short timeline. Here’s a walkthrough of how it ended up with version two. It’s likely we’ll have a more […]

Read More… from Parallel Practice Logging in Google Forms/Sheets

FotoFika Art Baseball Cards

A screenshot of the art-based baseball cards.

Origin Story The 2020 All Stars project1 is tied to the FotoFika site supporting photography faculty teaching online due to COVID. One of the concerns that came up in discussions was that this year’s graduating class wouldn’t be getting the personal connections that normally happen during exhibitions. That led to a discussion around Mike Mandel’s […]

Read More… from FotoFika Art Baseball Cards

Monthly Reporting, A Gravity Forms to Google Forms Love Story

Well not really but I’ll explain it anyway. Gravity to Google There are a number of plugins that tie Gravity Forms to Google Sheets but most (all?) of them rely on the ability to create an application to get authentication tokens. Many institutional accounts turn off that capability. VCU has turned that off. As a […]

Read More… from Monthly Reporting, A Gravity Forms to Google Forms Love Story

Google Form to Script to Make Folder, Document, Share it etc.

My click bait titles are so powerful! This isn’t anything special but it does show a couple of Google Script patterns that we reuse all the time. Folders are made in other folders! Documents are made in those folders. Things are shared. Ownership is assigned! So many things. The following script takes a form submission […]

Read More… from Google Form to Script to Make Folder, Document, Share it etc.