Site Tools‎ > ‎

Script Library

Google Apps Script is a JavaScript cloud scripting language that enables ways to automate tasks across Google products and third party services. We recommend building a library of rudimentary scripts for easy access by you or your staff. Also note: Since not all variables are documented, it's important to connect to developers who might be able to assist you when needed. Below are a handful of scripts we've used and are linked on various pages of this site.
SelectionFile type iconFile nameDescriptionSizeRevisionTimeUser
SelectionFile type iconFile nameDescriptionSizeRevisionTimeUser
ċ

View
YouTube video.  Aug 21, 2013, 11:01 AM Unknown user
ċ

View
Step-by-step instructions.  Aug 21, 2013, 11:01 AM Unknown user
SelectionFile type iconFile nameDescriptionSizeRevisionTimeUser
Ĉ
View Download
Instructions and spreadsheet template for copying pages from one Google Site into another Site. Click "download" to access the file and then import into your Google Documents collection.  15k v. 5 Apr 5, 2012, 8:03 AM Unknown user
ċ

Download
Google Apps Script for copying a Google Site into another Site. Copy and paste the text in the attached file into the script editor for the Google Spreadsheet.  2k v. 3 Apr 5, 2012, 8:03 AM Unknown user
SelectionFile type iconFile nameDescriptionSizeRevisionTimeUser
ċ

View
CopySite is an app that helps you copy Google sites. Usually, when you copy a site, you then have to go through all the embedded elements - documents, spreadsheets, calendars, gadgets, presentations... - and copy them as well manually, and eventually change the links inside all the pages so they point to you fresh copies. Now this is over: CopySite takes care of that. If you have ownership-level access to the site and view-level access to the embedded content, then just use CopySite and everything is automatic!  Aug 21, 2013, 10:59 AM Unknown user
SelectionFile type iconFile nameDescriptionSizeRevisionTimeUser
ċ

View
The following script can be used to generate a tree view of a Google Docs Collection in Google Sites on the fly. Very useful for displaying contents of large Google Docs Collection on a Google Sites page. Script by Saqib Ali at Seagate.  Mar 20, 2012, 12:57 PM Unknown user
ċ

View
Step-by-step instructions on how-to embed a Google Document Collection on a Site page.  Apr 5, 2012, 6:41 AM Unknown user
SelectionFile type iconFile nameDescriptionSizeRevisionTimeUser
ċ

View
Idea Banks are repositories for innovative ideas that Seagate employees can submit, and others can vote on those ideas. Before Google Apps Script we had a custom built Idea Bank on the LAMP stack. With the release of the UI Services in the Google Apps Script, we wanted to port that Idea Bank to Google Apps to easily manage idea submissions in a Google Spreadsheet. Script by Saqib Ali at Seagate.  Mar 20, 2012, 12:50 PM Unknown user
SelectionFile type iconFile nameDescriptionSizeRevisionTimeUser
ċ

View
Step-by-step instructions including two Marketplace tools that administrators have found useful for managing Sites. Use data pulled about your organization's Sites along with the spreadsheet template and Google Apps Script to send emails to Site Owners.  Apr 5, 2012, 6:39 AM Unknown user
ċ

View
Google Apps Script for sending a mail merge reminder. Copy and paste the text in the attached file into the script editor for the Google Spreadsheet.  Apr 5, 2012, 6:37 AM Unknown user
ċ

View
Spreadsheet template for setting up mail merge. Import the attached Spreadsheet into Google Docs.  Apr 5, 2012, 6:35 AM Unknown user