Unfortunately we don’t yet have our own npm in Google Apps Script 🙁 Although there have been efforts to pull together all those Apps Script libraries that are out there, nothing seems to have ever stuck. So this is […]
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 […]
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 […]
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. […]
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 […]
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 […]
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 […]
