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,”@[login to view URL]”] 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, [login to view URL], “NA”,) 3. SPREADSHEET 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. 4. GROUPS o The script would then create a new google group [project#@[login to view URL]] ? 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 5. DRIVE 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. o NEWFOLDER ? Calculations 1. Elec, 2. Fire 3. HVAC 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 6. SITES 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 [[login to view URL] 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 [login to view URL] /activeprojects/ ]