Google Apps Script – File Clone
This little script makes a copy of a list of Google Drive files in a Google Sheet in a folder called “Cloned Files”. You can get a copy by clicking on this link. You can see the script in Extensions […]
Tag: Google Sheets
Google Apps Script Library Database
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 […]
PDF Creator – Send multiple PDFs based on selected rows
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 […]
Create a PDF from each of the rows in a Google Sheet
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 […]
Convert multi-sheet Google Sheet to PDF using Apps Script
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 […]
PDF Creator – Email form submission in a PDF
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 […]
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. […]
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 […]