Google Apps Script(s) User Provisioning

IN PROGRESS
Bids
2
Avg Bid (USD)
$220
Project Budget (USD)
$30 - $250

Project Description:
I'm looking for someone to write a few Google Apps Scripts using things like UserManager to help speed up the administrative tasks involved in setting up a new user in Google Apps.
The script would help me setup new employees as such:
1. The setup Script would first populate a spreadsheet with our current list of users from the domain.
2. Form Input: Employees First Name, Last name, cell phone number, 4 digit Employee ID and organizational Unit.
a. On form Submit
b. The spreadsheet would first look to match the employee ID. If the employee ID is found Message Box: “ Duplicate Employee Found! Please Exit” Else:
c. The data would populate a spreadsheet Row in sheet 1 with column labels:
i. First Name, Last Name, Cell number, Employee ID , OU, initial password, Email Address, Google Group and Employee Status.
d. A spreadsheet function [=left(A2,1)&Left(B2,1)&"77681"] would fill out the next column labeled: initial password
e. A spreadsheet function [=CONCATINATE(B2,”.”C2,”@domain.com”] would fill out the Email Address column. ()
f. A spreadsheet function [=if(OU=”Administrator”,I2=,ect ] would fill out the Google group column.
g. The script would set the Status column to Active
h. Next the script would setup the employees email from the Email Address column
i. Set the Initial password: From the password column
j. Set the email conversation view to Off
k. Set the chat function to On
l. Add the employee to the OU from the OU Column data
m. Add the employee's cell phone number to their calendar
n. Add a list of Calendars to the employee calendar list from data specified on sheet 2. Ex(project calendar, vacation calendar and conference room)
o. Set accepted terms to yes
p. Add employee to specified Google group based on the Group column data.
q. If possible create a basic Google + account for the employee (Just Name, Company, Email)

Skills required:
Google App Engine, Javascript
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


Hire GeorgeKazi
$ 250
in 7 days
$ 190
in 3 days