Originally posted on techupover.com tagged in “Development” Use Google Apps Script and the Drive API to pull information about all the Shared Drives in a domain into a Google Sheet. Then use the Drive API again to loop through all the drives and get the top-level permissions. If you’re a…

Originally posted on techupover.com Mailing lists come and go, and if you’ve kept everything in your inbox (and were a member since the list’s inception) then you can always go back to find that random answer someone gave. BUT, if you didn’t sign up at the start, or have lost…

Originally posted in techupover.com Fix your “Untitled Documents” and “Untitled Sheets” using some Apps Script to automate a rename, using the file’s own contents. This one’s easy…everyone gets lazy sometimes, and ends up with a bunch of “Untitled Spreadsheet” or “Untitled Documents” in their Google Drive files list. This Apps…

This Apps Script is perfect for project managers, team leads, teachers or anyone who needs to set up a set of Google Drive folders and subfolders quickly and efficiently using automation instead of manual clicks. Kudos to https://www.pbainbridge.co.uk/2020/06/bulk-create-google-drive-folders-20.html and various stackoverflow threads for filling in some gaps about how things…

Originally posted in: Dear Vendor I’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 advice to vendors. You want to understand the Higher Education market, so naturally someone had the bright idea to…

Get some simple data into BigQuery without having to use a lot of tools or complex workflows — Want to load multiple pipelines of CSV files to different BigQuery projects/datasets/tables automatically, and control them all from a single Google Sheet? Yes? Then this article is for you. This process will even let you configure if you want the automation to truncate or append the data each time to…

If 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. In fact, even if you’re yelling about something mundane, there’s a good chance someone else out there is going to have an opinion about it, and…

Originally posted at techupover.com in the Development category I 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 we have in our home library. 35 years ago, my dad set up…

Your unsolicited email strategy is just annoying. You should know what we do with your emails. We’ve all received these, right? Hi {last name because their CRM leads import mapped the wrong field}, {name} here with {vendor} - {colloquial phrased paragraph about how you got my email} {attempted informal language…