Google – Page 2 – Bionic Teaching

Filtering CSV in PHP

Posted on May 26, 2022 (May 26, 2022) by Tom Woodward

I got an email from a KQED reporter asking about this old post on importing CSVs into Google Sheets. The source data was big though and hosted on GitHub and they only wanted the California data. I thought that anything we did in Google Script was likely to time out so I built a little […]

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

Posted on February 9, 2022 (February 9, 2022) by Tom Woodward

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 […]

Parallel Practice Logging in Google Forms/Sheets

Posted on October 13, 2021 by Tom Woodward

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 […]

Data Games with Google Sheets

Posted on April 21, 2021 by Tom Woodward

This is for a workshop with students on Saturday. It’s a revision of a thing Jeff and I did a way back in 2018. I think I’ve come up with some improved examples and I’ve revised a few things. The goal is to let any skill level start to see how spreadsheets can be useful […]

FotoFika Art Baseball Cards

Posted on May 1, 2020 (May 1, 2020) by Tom Woodward

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 […]

Monthly Reporting, A Gravity Forms to Google Forms Love Story

Posted on February 28, 2020 by Tom Woodward

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 […]

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

Posted on October 2, 2019 by Tom Woodward

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 […]

Gravity Forms Notification to Google Spreadsheet

Posted on April 25, 2019 (April 25, 2019) by Tom Woodward

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 […]

Google Sheets Data Flow

Posted on April 8, 2019 by Tom Woodward

This is a pretty specific thing but the concepts ought to be broadly applicable and interesting for the 3 to 5 people who will end up reading this. It’s a fairly amusing blend of less standard Google Functions and a bit of Google Script to do something fairly decent that had been quite a bit […]

Read More… from Google Sheets Data Flow

Get the PDFs – Google Search to Google Folder

Posted on January 31, 2019 (January 31, 2019) by Tom Woodward

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: […]