JSouthGB

Google Apps Script pdfToText Utility#

This is a helper function that will convert a given PDF file blob into text, as well as offering options to save the original PDF, intermediate Google Doc, and/or final plain text files. Additionally, the language used for Optical Character Recognition (OCR) may be specified, defaulting to 'en' (English).

Note: Updated 12 May 2015 due to deprecation of DocsList. Thanks to Bruce McPherson for the getDriveFolderFromPath() utility.

    // Start with a Blob object
    var blob = gmailAttchment.getAs(MimeType.PDF);

Google Apps Script Survey Workflow

The components involved in this workflow are:

A script to generate and send an email with an HTML form.
An html template for that email, which allows us to customize the email for each recipient.
A doPost() function to handle responses. The script must be [deployed as a Web App][1].
A spreadsheet to collect responses. The script will be contained in the spreadsheet, and extends the spreadsheet UI with a menu for sending a copy of the survey. (It could be adapted for standalone use, without the UI component.)

Here is an example of such a workflow, conducting a Commuting Survey. Recipients will receive a survey email like this:

	#!/bin/bash

	# Create postgres directory with pgvolume and pga4volume as child directory.
	mkdir -p postgres/{pgvolume,pga4volume}

	# Navigate to postgres directory
	cd postgres

	# Create pg.env that holds environment variable for postgres docker container.
	cat << EOF > pg.env

	function extractData(data, startStr, endStr) {
	// This function extracts text between two strings
	// i.e. extractData("Good_news,_everyone!", "Good_", ",_Everyone!") will return "News"
	var startIndex, endIndex, text = 'N/A';

	startIndex = data.indexOf(startStr);

	if(startIndex != -1) {
	startIndex += startStr.length;
	text = data.substring(startIndex);

	#!/bin/bash

	# get all running docker container names
	containers=$(sudo docker ps \| awk '{if(NR>1) print $NF}')
	host=$(hostname)

	# loop through all containers
	for container in $containers
	do
	echo "Container: $container"

	function processInboxToSheet() {
	//var threads = GmailApp.getInboxThreads();
	// Have to get data separate to avoid google app script limit!
	var start = 0;
	var threads = GmailApp.getInboxThreads(start, 100);
	var sheet = SpreadsheetApp.getActiveSheet();
	var result = [];

	for (var i = 0; i < threads.length; i++) {
	var messages = threads[i].getMessages();