Google Apps Script

Below you will find the latest Google AppsScripts that we have found. Our tips are carefully categorised so whether you are a beginner, advanced user or an administrator you will find something of interest. Use the Filters to find what you are looking for or scroll down to browse through all our tips. If you have a tip or a Script you’d like to share, use our Suggest a Tip form.

Google Apps Script

Copy a Folder in Google Drive

Categories: , ,

Treat whole folder structures and docs as a template - use for new projects, or just for copying a single folder structure
Copy Folder Tool
By: Mark | Posted On: April 26th, 2013 | 17 Comments

Create global Shared Contacts

Use a Google Spreadsheet and Google Apps Script to synchronise multiple spreadsheets of contacts into Shared Contacts to create a global address book.
By: Mark | Posted On: October 12th, 2012 |

Simple electronic voting system

A good example of a simple electronic voting system using a Google Form and Spreadsheet.
By: Mark | Posted On: October 2nd, 2012 | 1 Comment


Automate the creation of personalised documents and emails.
By: Mark | Posted On: September 19th, 2012 |


Automate school communications through a multipurpose, flexible merged email creator that runs from Google Spreadsheets.
By: Mark | Posted On: September 18th, 2012 |


A script to give teachers the ability to auto-generate, pre-share, and manage grading and feedback on templated Docs for group and individual projects.
By: Mark | Posted On: September 17th, 2012 | 9 Comments

Gmail Print All for Chrome

Export emails from Gmail to a Google Drive document.
By: Mark | Posted On: September 12th, 2012 |

Print Phone Book

Generate a phone book document from your Gmail contact list
By: Mark | Posted On: September 5th, 2012 |

Envelopes for Google Docs

Create envelope documents for Google Docs and Google Drive.
By: Mark | Posted On: September 5th, 2012 |

Gmail Archiver

A script that will seamlessly analyse your Gmail inbox and move all the big attachments.
By: Mark | Posted On: September 5th, 2012 |

Sync Spreadsheet data to a Google Calendar

Sync data from a Google Spreadsheet to your Google Calendar.
By: Mark | Posted On: September 3rd, 2012 |

Sort Gmail Messages by Size using Google Docs

A Google Apps Script that will scan your Gmail mailbox for messages that contain large file attachments so you can delete (or forward) all the useless bulky messages to recover precious space.
By: Mark | Posted On: August 31st, 2012 |


Create an RSS feed of public Google+ activites and quickly add it to your Google Reader
By: Mark | Posted On: August 30th, 2012 |

Automate Google Analytics reporting

A simple Google Apps Script to put Google Analytics data into a Google Spreadsheet.
By: Mark | Posted On: August 27th, 2012 |

Build a leave management request system

Build a leave request management system for your business using Google Apps Script.
By: Mark | Posted On: August 15th, 2012 |

Flubaroo, grading made easy

Flubaroo is a popular script among teachers, as it extends the usability of Google Forms for online assignments.
By: Mark | Posted On: August 14th, 2012 |

Dashboards in Google Apps Script

Dashboards allow users to compose multiple charts and filters into a single experience.
By: Mark | Posted On: August 6th, 2012 |
Add New Tip

Suggest a Tip

What tip would you like to share with the world? Please follow the link

Add New Tip