Totally Unscripted – G+ Community Apps Script Show
Check out the latest episode of “Totally Unscripted” with Bruce McPherson talking about the new Sheets API and Spencer Easton about OAuth.
Category: Computing
Website/domain monitor – Google sheet and Apps Script
Never miss a “domain expiry” email notification ever again! One of my websites was recently down for a couple of weeks without me noticing (it looks like the email notification got lost in the post). So to avoid this happening again […]
Using Apps Script and the Vision API to monitor a webcam
This is a very cool script from Robert Elison that uses Apps Script and Google’s Vision API to monitor a webcam for anything unusual: http://ithoughthecamewithyou.com/post/get-an-email-when-your-security-camera-sees-something-new-apps-script–cloud-vision
Yet Another Google Sheet Burndown Chart (YAGSBDC)
This is a bit of a twist on the typical burndown chart with a couple of extra features: Velocity = points/actual hours. As the number of hours I work in a “sprint” can vary, and it is just me which […]
Google Apps Script to create and email a PDF
This script creates a PDF file using a Google Doc template and the values in a Google Spreadsheet. It is a development of this script , where this one allows you to specify the name of the PDF in the […]
Google Sheets “get address” custom function
This is a fun little custom function that makes a best guess at the address of a place you give it. Take a look at this sheet which has the custom function GET_ADDRESS() in B2 and gets the address of A2. […]
OpenStack RESTful GAS Library
OpenStack is a cloud-based OS that provides a RESTful API to storage it manages. This is a library I’ve developed that allows you to access that storage via Google Apps Script. Read more…
Rose Money Manager
I’ve just made public the Google Spreadsheet I use for my personal finance management. Features: Schedule regular transactions: Automatically create the next 40 days transactions (to create projected cash flow over the next month). This needs a Google Calendar called “Regular Transactions” […]
VeriClock RESTful API Google Apps Script library
VeriClock is a cloud-based employee time tracking system that provides a RESTful API. This library provides a straightforward way to access the VeriClock API from a Google Apps Script. The project id of the library is “Mnek5yp41nP-lNIwpLgcNFtnfWGfgtIUb”. Details of the API […]