Category: Google Apps Script
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 […]
High-res terrain generator in Google Sheet!
You can see the terrain image in this spreadsheet. Having just released the Color Scale Add-on I was having a play around with a terrain generator and created this (fairly) high-res terrain in a Google Sheet! The terrain generation script is […]
Google Sheet Color Scale Add-on – v2 released
Ever popular in the Script Gallery, Color Scale is now available as an add-on in the Google Web Store for adding to your own Google Sheets. The Color Scale add-on for Google Sheets sets the background color of the cells […]
Rose Task Manager – Google Apps Add-on Released
Rose Task Manager is now available as a Google Apps Add-on in the Google Web Store! Rose Task Manager lists tasks in a Google sheet, use Google calendar to schedule regular events and send various emails notifications. You can read more […]
Apps Script to Merge a Google Sheet into a GDoc and Create a PDF
This is a Google Apps Script to create a PDF file using a Google Doc template and the values in a Google Spreadsheet. It takes the fields from the active row in your Google Spreadsheet (the one with a […]