Google Apps Script

By Barrie Roberts | GAS and Javascript related to GAS

Pimp up your Sheet – Programmatically!

When working with spreadsheets we can spend quite a long time making them look good and if we have to make the same sheets over again, that’s a lot …

Web Development

Book inventory

Here we’re going to make a simple book inventory, where we’ll be able to control the location of the books and also find out where a book is. This …

Python Programming

Automatically emailing info from a form submission

Here we’ll look at how to set up automatic emails, which contain information submitted by the Google Form user. The beauty of this is that the …

PHP

Google Apps Script doGet and doPost Tutorial + 6 Web App Examples

Trevor Fox<p>January 30, 2017<p>If you are new to Google Apps Script or programming in general, Google Apps Script Web Apps may seem daunting. The good …

Request form – Sending automatic emails

One of the most useful things I’ve learnt to do with Google Apps Script, is to email people automatically when a form is submitted. It has countless …

PHP

19 Useful Google Apps Scripts to Automate Google Drive

Google Drive offers great features for storing and working with different types of files but it does lack at some features that are crucial for your …

Google Drive

App Maker University

2016 - Another year in Apps Script

The real world of 2016 has been full of madness, badness and sadness. It's impossible to reflect on its events without thinking of the divisiveness, …

Totally Unscripted: Episode 6 - Analytics in Add-ons and App Maker

Google Apps Script: Create Your Own Mail Merge - Teacher Tech

I use peer evaluation quite a bit in my class. My data is collected via a Google Form and are in a spreadsheet. I use mail merge to send students …

Creating a Google form that will automatically email users a copy of the form - SBS Technology Enhanced Learning

We were asked to find a way to send an auto reply email to users who had completed an online form. An email also needed to be sent to their line …

Google Spreadsheets as a Database – INSERT with Apps Script form POST/GET submit method

Update 04/07/2014: I’ve revisited this code and made a number of improvements. Read more in Google Sheets as a Database – INSERT with Apps Script …

Google Apps Script: Create New Tabs - Teacher Tech

Create Tabs in Google Sheets<p>Google Apps Script allows you to customize what Google text docs and Google Sheets can do for you. It is based on …

Education Technology

Create Auto responding google form with 2 lines of code

A form submit trigger sends an event object which contains form data which can be used to get the user details and send him an email.<p>We are passing …

Automate Google Sheets: An Introduction to Google Apps Script - The Ultimate Guide to Google Sheets

Google has built some of the most effective productivity tools on the planet. With Gmail, Hangouts, Chrome, Docs, Sheets, and more, odds are you use …

Html Service Basics - Write Form Data To A Spreadsheet

<b>Update 14-Sep-2015: See chapter 7 in leanpub book This chapter has been fully re-written and expanded</b><br>As stated in the previous post, GUI Builder is …

How to make programmatic Google Forms

16 Jul 2015<p>Let’s pretend you’re making a survey. And you want to ask the same thing many times, with only the slightest modification.<p>What if you want …

Is it possible to 'prefill' a google form using data from a google spreadsheet?

I'm looking for a way to 'pre fill' a google form with specific data from a google spreadsheet. The form will have the same 'standard' questions for …

Supercharge your Google Form with Google Apps Script!

I love Google Docs, and with just a little bit of JavaScript, you can supercharge any of your Google Docs using Google Apps Script. In this blog, …

How to Copy an Entire Folder to Another Folder in Google Drive

Google Drive, launched almost 4 years ago, is an online vault where you can store all your files and documents. It offers nearly all the …

Google

Google Slides – Master slides and themes

The built-in themes provide a great springboard to make professional looking slides but what happens if you want them to look different? Or what …

Count cells based on color in the new google sheets?

When using a custom function like the one above, you have to make sure the range is passed to the function and not the values. That's why you have to …

Create Google Calendar Events from Spreadsheet but prevent duplicates

I'm trying to write a script that will take data from a Google spreadsheet and create events in my Google calendar.<p>I managed that fine but it …

12 Books Every JavaScript Developer Should Read

I’m a big fan of JavaScript books. Being a long-time learner of JavaScript, I’ve had the pleasure of reading a great many of the popular JavaScript …

JavaScript

Tutorial: Using Google Spreadsheets to Update a Google Calendar – Our New Vacation Management System

As promised in my last post about our vacation policies, here’s a step-by-step tutorial of how we now manage our vacation policies with a Google …

Issues - google-apps-script-issues

Google Apps Scripts

Delete or Trash specific file in Drive

I had a script that ran every day at 5 am, that would move a specific file (data.xls) to the trash. However, since DocsList has been retired, the …

Google Apps Script to create PDF

This is a little script to create a PDF file using a Google Doc template and the values in a Google Spreadsheet. Get in touch now if you need any …