Google Apps Script(s) to Deploy a site, group, and several Google docs folders

I’d like a Google apps script to help me setup a new project on form submit. (I have a template site called HIPP_Project)

The script would work as such:

1. Form input: Project number, Client Name, Project Lead and Deploy Project Site = Yes or No (drop down)

2. On form submit:

o The data would populate a spreadsheet Row with column labels: Project Number, Client Name, Project Lead, Deploy Site, Location, Google Group, CAD Lead, Folder Link, Site Link

o Calculated Columns

o Location: [=If(left(1,1)=A, “Augusta”, if(left(1,1)=R, “Raleigh”,””))

o The Google Group field/cell should be populated with [=Concatenate (ProjectNamber,”@[url removed, login to view]”]

o CAD Lead: The CAD lead should rotate through a list of 3 names from sheet 2. Each form submit gets assigned the next name.

1. (If possible it would be great to check for the CAD leads email address on our vacation calendar and if they are out, skip that person and move to the next.)

o File Link: field should be populated with \\Y:\projects\Location(ie. Raleigh or Augusta)\project number.

o Sites Link: [=if(Deploy Project site = yes, [url removed, login to view], “NA”,)


o The script should run simple mail merge and send an email to the Google group [] “The project for $clientname has been setup at the following location: File link field. A project site was deployed $yes_or_no. If a site was deployed you can find it at $site link.


o The script would then create a new google group [project#@[url removed, login to view]]

? Set the owner to with delivery set to no email

? Add people from a list in sheet2 ,

? Assign these people to manager roles

? Set email delivery to no

? Set permissions to: Post = Anyone, Join the group = Anyone in the organization, View topics = All organization members


o Create a new folder with the project number as the name. Based on the location field; Place this new folder under either Projects\Raleigh\ NewFolder OR Projects\Augusta\ NewFolder

o Next create new subfolders based on the following list.


? Calculations

1. Elec,

2. Fire


4. Inst,

5. Plum

6. Proc

? Client-Received Materials

? Correspondence

1. Agenda

2. Email

3. Faxes

4. Letters

5. Meeting Minutes

6. Memos

7. Telephone Call

8. Reports

9. Transmittals

10. Trip Reports

? Deliverables

1. Basis of Design

2. Covers

3. Detailed Package

4. Field Data Study

5. Preliminary Package

6. Report

7. Specs

? Drawings

1. Client Originals,

2. Disciplines,

3. Incoming,

4. Issue Archive,

5. Outgoing,

6. Vendor Drawings

? Equipment

1. Equipments List,

2. Vendor Cut Sheets

? Information Logs

1. Action Items,

2. Distribution Matrix,

3. RFI’s,

4. Submittals

? Job Closeout

1. Lessons Learned,

2. Punch List,

3. Redline Notes,

4. Turnover Documents

? Pictures

? Project Schedule

? Temp



o If I choose deploy project site = yes on the form, the script would deploy our site from the template (HIPP_Project)

? Set the new site name as: Client Name_Project Number

? Set the new site category as projects

? Place your assigned Project Lead is: Project Lead Name on the front page

? Place your assigned CAD lead is: CAD Lead Name on the front page

? Place the google group iframe on a page called Correspondence [[url removed, login to view] Name_project number/correspondence]

? Push the Client Name, Project Number, Project Lead, CAD Lead, Location, File link Url and Site Link Url to a list on the following site list page. [page [url removed, login to view] /activeprojects/ ]

Taidot: Google App Engine, Javascript, tietojärjestelmäarkkitehtuuri

Näytä lisää: google site script, the members group, spreadsheet script google, spreadsheet script, spreadsheet javascript, spreadsheet in javascript, software for cad design, sites google com sites, sites google c, script sheets, script google spreadsheet, roles of a project manager, r.d.o. equipment, r.c. groups, r architecture, project schedule template, project manager job sites, people that help you find a job, notes in google apps, move domain from 1&1, matrix design group, mail merge google docs, mail merge google, mail merge from google docs, logs topics

Tietoa työnantajasta:
( 4 arvostelua ) Raleigh, United States

Projektin tunnus: #4245640

Myönnetty käyttäjälle:


Hi! As discussed earlier.

$250 USD 30 päivässä
(2 Arvostelua)

2 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


I have a good experience(5 years) in both web designing and web development. I'm having expertise in Photoshop, html5, CSS3 and PHP5, Frame works (like Opencart, Joomla, Magento, WordPress etc). If you can give me a ch Lisää

$750 USD 30 päivässä
(0 arvostelua)