A new Slack channel has recently been opened for all things Google Apps Script. Google-Apps-Script.slack.com So if you’d like to join in some live, informal chat on Apps Scripts and get to know some of your fellow GASers a bit […]
Continuing the “merge” theme this is a function that fills in a HTML template. I’ve personally used it to complete a template from a draft GMail. The template may end up having HTML tags within the placeholder that aren’t obvious […]
This script creates a number of PDF files using a Google Doc template and the rows selected in a Google Spreadsheet. Further to user requests, I have created many variations on the PDF creation theme. Other ways to use this […]
This script creates a number of PDF files using a Google Doc template and the values in a Google Spreadsheet. It creates a PDF of all of the rows in the Google Sheet. Further to user requests, I have created […]
This Google Apps Script creates a PDF from a multi-sheet Google Sheet with the option of emailing the PDF. Simply copy the script into the script editor (Tools > Script editor…) of the GSheet in question, save it, refresh the […]
This script automatically emails the submission from a Google Form as a PDF. The PDF is created by populating a Google Doc template from the values in the Google responses spreadsheet. Further to user requests, I have created many variations […]
Check out the latest episode of “Totally Unscripted” with Bruce McPherson talking about the new Sheets API and Spencer Easton about OAuth.
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 […]
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
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 […]
