Google Apps Script(s) User Provisioning

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)

Taidot: Google App Engine, Javascript

Näytä lisää: using google spreadsheet, using google apps, the p.i.c. group, submit google app, spreadsheet script google, spreadsheet script, spreadsheet javascript, spreadsheet in javascript, script google spreadsheet, new spreadsheet app, i m looking for employees, h and p form, google scripts spreadsheet, google apps spreadsheet, google apps script spreadsheet, google apps script create new spreadsheet, google apps javascript, google apps email, data input administrator, b j's, apps scripts google, apps script google, app script spreadsheet, app script form, apps company

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

Projektin tunnus: #4244885

Myönnetty käyttäjälle:


Hi, can help.

$190 USD 3 päivässä
(1 arvostelu)

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


Hi! Please see your inbox.

$250 USD 7 päivässä
(1 arvostelu)