Save Time: How I use a text-expander and you should tooUsing a text-expander will save you time. I use Espanso every single day, and should have written about it sooner.Mar 11, 2023Mar 11, 2023
Extract & visualize your own Twitter data using Google Apps Script & Google SheetsIf want to get your data out of Twitter, and be able to visualize it with very little effort, this is for you.May 3, 2022May 3, 2022
Use Apps Script to pull all Google Shared Drives and permissions into a Google SheetUse Google Apps Script and the Drive API to pull information about all the Shared Drives in a domain into a Google Sheet.Mar 25, 2022Mar 25, 2022
Low code extracting listserv archives to tabular data using Webscraper.ioLow code extracting listserv archives to tabular data using Webscraper.ioMar 15, 2022Mar 15, 2022
Batch rename Google Drive Docs & SheetsFix your “Untitled Documents” and “Untitled Sheets” using some Apps Script to automate a rename, using the file’s own contents.Jan 8, 2022Jan 8, 2022
Bulk Create Google Drive Folder Structures & FilesPerfect for project managers, team leads, teachers or anyone who needs to set up a set of Google Drive folders and subfolders & filesJan 7, 20222Jan 7, 20222
Dear Vendor: Customer Advisory BoardsI’ve served on different CABs for over a decade with various vendors, and feel like I’ve seen them run well, and not so well. Here’s my…Nov 20, 2021Nov 20, 2021
Published inTowards Data ScienceAutomate Multiple CSV to BigQuery Pipelines with Google Sheets & Apps ScriptWant to load manage multiple pipelines of CSV files to different BigQuery projects/datasets/tables automatically, and control them all fromOct 28, 2021Oct 28, 2021
Twitter isn’t that bad, you just have to curate itIf you walked into a massive mall food court full of people (pre-covid of course), and started yelling, you’d expect people to yell back.Oct 8, 2021Oct 8, 2021
Create a book tracker using Apps Script and the Google Books API in 10 minutesI wanted a quick and easy way for my kids to track the books they read, as well as a way for my wife to catalog all the books in the house.Sep 28, 2021Sep 28, 2021