You have chosen to sponsor your bid up to a maximum amount of .
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)