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

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

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.

Gravity Forms Notification to Google Spreadsheet

Small red plastic toy shovel.

The idea that data can flow to different places for different purposes is one of the key concepts I want people to believe in. Different technologies and different interfaces have different affordances depending on what you’re trying to do. In this case, we’ve built some online training for students. As part of that training they […]

Read More… from Gravity Forms Notification to Google Spreadsheet

Get the PDFs – Google Search to Google Folder

An old newspaper ad showing an automatic printer.

Here’s a neat little pattern that might interest others. We got a version of the question below yesterday. Is there a way to automatically get the links from the search linked below into a spreadsheet? https://www.google.com/search?q=site%3Aedu+filetype%3Apdf+syllabus+education&oq=site%3Aedu+filetype%3Apdf+syllabus+education Then, from there, is there a way to automagically get the pdf files into a Drive folder? Step 1: […]

Read More… from Get the PDFs – Google Search to Google Folder

Google Sheets Meets Digital Humanities

A drawing of a small terrier dog jumping through a hoop held by a monkey.

Jeff and I are doing a THAT Camp workshop that’s trying to talk about the scale/scope/potential of Google Sheets in the big box of Digital Humanities related options. Depending on how the workshop goes, I’ll revise this post to be more useful. Getting Data In There are quite a few ways to pull data into […]

Read More… from Google Sheets Meets Digital Humanities

WordPress Plugin Health Dashboard (Early POC)

In trying to get a better handle on how we’re going to manage our plugins in the future, I found the API for the WordPress.org plugins data. Not like they were hiding it but I’d not seen it before.Consider me Columbus– absent the genocide, slavery, and other terrible things. Replacing *slug* in the following URL […]

Read More… from WordPress Plugin Health Dashboard (Early POC)