Google Apps Script(s) User Provisioning

Budget $30 - $250 USD
Bids 2
Average Bid $220

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,”@[url removed, login to view]”] 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)

Post a Project Like This

This project was awarded to

Viqtor

My project ended up being quite a bit more difficult than I think was imagined but he still made a good effort to get it done in a timely manner and even though it was done in a different way than I thought it would be, he has agreed to do another project with me to get the job done right! Thanks Viktor!
About the Freelancer
Viqtor Profile Picture

Results oriented IT engineer with experience of working on web based IT projects and services. Highly motivated and fascinated by new technologies I always deliver a high quality working product. About myself: I am fast, brilliant and cheap, but you can only have any two of them at a time. So if I am fast and brilliant, I am not cheap; if I am brilliant and cheap, I am not fast; and if I am fast and cheap, I am not brilliant.

Looking to make some money?

  • Set your budget and the time frame
  • Outline your proposal
  • Get paid for your work

Bids on this Project

  • Viqtor Profile Picture

    Viqtor

    Kharkiv,  Ukraine

    Results oriented IT engineer with experience of working on web based IT projects and services. Highly motivated and fascinated by new technologies I always deliver a high quality working product. About myself: I am fast, brilliant and cheap, but you can only have any two of them at a time. So if I am fast and brilliant, I am not cheap; if I am brilliant and cheap, I am not fast; and if I am fast and cheap, I am not brilliant.

    Javascript, Data Processing, Excel, and Google Adwords

  • GeorgeKazi Profile Picture

    GeorgeKazi

    n/a,  Kenya

    I'm a highly motivated software devloper. Send me your problems and we'll work through them together.

    PHP, Perl, C Programming, and Java