Andrew Roberts andrewroberts

## convertSpreadsheetToPdf.gs
/*
 * Save spreadsheet as a PDF
 *
 * Based on Dr.Queso's answer in http://stackoverflow.com/questions/30367547/convert-all-sheets-to-pdf-with-google-apps-script/30492812#30492812
 *
 * @param {String} email Where to send the PDF [OPTIONAL]
 * @param {String} spreadsheetId Or the active spreadsheet[OPTIONAL]
 * @param {String} sheetName The tab to output [OPTIONAL]
 * @param {String} PdfName [OPTIONAL]
 */

## exportSpreadsheet.gs
function exportSpreadsheet() {

  //All requests must include id in the path and a format parameter
  //https://docs.google.com/spreadsheets/d/{SpreadsheetId}/export

  //FORMATS WITH NO ADDITIONAL OPTIONS
  //format=xlsx       //excel
  //format=ods        //Open Document Spreadsheet
  //format=zip        //html zipped


## createPDF.gs
//
// Create a PDF by merging values from a Google spreadsheet into a Google Doc
// ==========================================================================
//
// Demo GSheet & script - http://bit.ly/createPDF
// Demo GDoc template - 1QnWfeGrZ-86zY_Z7gPwbLoEx-m9YreFb7fc9XPWkwDw
//

// Config
// ======

## createPDF_filename.gs
// dev: andrewroberts.net

// Replace this with ID of your template document.
var TEMPLATE_ID = ''

// var TEMPLATE_ID = '1wtGEp27HNEVwImeh2as7bRNw-tO4HkwPGcAsTrSNTPc' // Demo template
// Demo script - http://bit.ly/createPDF

// You can specify a name for the new PDF file here, or leave empty to use the
// name of the template. Placeholders can also be placed in here.

## API_.gs
// 34567890123456789012345678901234567890123456789012345678901234567890123456789

// JSHint - todo
/* jshint asi: true */
/* jshint esversion: 6 */

(function() {"use strict"})()

// API_.gs
// =======

## OAuth1_.gs
// From https://github.com/googlesamples/apps-script-oauth1/blob/master/samples/QuickBooks.gs

// Consumer key and secret in Config.gs

var OAuth1_ = {

/**
 * Connect to the API
 */


## PDFCreator_EmailAllResponses
/*

PDF Creator - Email all responses
=================================

When you click "Create PDF > Create a PDF for each row" this script
constructs a PDF for each row in the attached GSheet. The value in the
"File Name" column is used to name the file and - if there is a
value - it is emailed to the recipient in the "Email" column.

## fillInHtmlTemplate.gs
/**
 * For each placeholder - "{{[placeholder]}}", strip out any HTML and replace
 * it with the appropriate key value. An example use of this could be using the
 * HTML from a draft GMail as a template.
 *
 * E.g. If the obect were:
 *
 * {PlaceHolder1: newValue}
 *
 * In the template "{{PlaceHolder1}}" would be replaced with "newValue" even

## EmailPDFOfFormSubmission.gs
/*

PDF Create - Email on form submit
=================================

This script creates a PDF populated with the values submitted in a
Google form.

The "on form submit" trigger needs to be manually created:

## Properties_.gs
// 34567890123456789012345678901234567890123456789012345678901234567890123456789

// JSHint - TODO
/* jshint asi: true */

(function() {"use strict"})()

// Properties_.gs
// ==============
//
	/*
	* Save spreadsheet as a PDF
	*
	* Based on Dr.Queso's answer in http://stackoverflow.com/questions/30367547/convert-all-sheets-to-pdf-with-google-apps-script/30492812#30492812
	*
	* @param {String} email Where to send the PDF [OPTIONAL]
	* @param {String} spreadsheetId Or the active spreadsheet[OPTIONAL]
	* @param {String} sheetName The tab to output [OPTIONAL]
	* @param {String} PdfName [OPTIONAL]
	*/
	function exportSpreadsheet() {

	//All requests must include id in the path and a format parameter
	//https://docs.google.com/spreadsheets/d/{SpreadsheetId}/export

	//FORMATS WITH NO ADDITIONAL OPTIONS
	//format=xlsx //excel
	//format=ods //Open Document Spreadsheet
	//format=zip //html zipped
	//
	// Create a PDF by merging values from a Google spreadsheet into a Google Doc
	// ==========================================================================
	//
	// Demo GSheet & script - http://bit.ly/createPDF
	// Demo GDoc template - 1QnWfeGrZ-86zY_Z7gPwbLoEx-m9YreFb7fc9XPWkwDw
	//

	// Config
	// ======
	// dev: andrewroberts.net

	// Replace this with ID of your template document.
	var TEMPLATE_ID = ''

	// var TEMPLATE_ID = '1wtGEp27HNEVwImeh2as7bRNw-tO4HkwPGcAsTrSNTPc' // Demo template
	// Demo script - http://bit.ly/createPDF

	// You can specify a name for the new PDF file here, or leave empty to use the
	// name of the template. Placeholders can also be placed in here.
	// 34567890123456789012345678901234567890123456789012345678901234567890123456789

	// JSHint - todo
	/* jshint asi: true */
	/* jshint esversion: 6 */

	(function() {"use strict"})()

	// API_.gs
	// =======
	// From https://github.com/googlesamples/apps-script-oauth1/blob/master/samples/QuickBooks.gs

	// Consumer key and secret in Config.gs

	var OAuth1_ = {

	/**
	* Connect to the API
	*/
	/*

	PDF Creator - Email all responses
	=================================

	When you click "Create PDF > Create a PDF for each row" this script
	constructs a PDF for each row in the attached GSheet. The value in the
	"File Name" column is used to name the file and - if there is a
	value - it is emailed to the recipient in the "Email" column.
	/**
	* For each placeholder - "{{[placeholder]}}", strip out any HTML and replace
	* it with the appropriate key value. An example use of this could be using the
	* HTML from a draft GMail as a template.
	*
	* E.g. If the obect were:
	*
	* {PlaceHolder1: newValue}
	*
	* In the template "{{PlaceHolder1}}" would be replaced with "newValue" even
	/*

	PDF Create - Email on form submit
	=================================

	This script creates a PDF populated with the values submitted in a
	Google form.

	The "on form submit" trigger needs to be manually created: