Build a script to read data from a postgreSQL database, separately hosted, and use the data to populate users in Google Apps. Alternatively, read the data from a csv file exported from the database. If possible, the script should create a new user, add a forwarding email, and add the user to a group. The username and forwarding email are derived from the database, the group name is mapped in a google sheet
Hi, can help.
Will develop script. Data from csv file is used for user info update? Do you have a sample of spreadsheet, csv (need understand they structure ) and provide access to db?
Regards, Viktor
Hello, I did a lot of similar projects (get data from a DB and generate KML for Google Earth for example).
I believe it is best to connect to a DB so that you do not need to hassle with CSV.
So the steps are:
1. Script fetch all data from DB (user/forwarding email)
2. Then it adds a user to a google spreadsheet? or shall it create the users in Google App (create google account for them)?
3. When you say group name is mapped in a google sheet, can I have a look at the mapping?
perhaps it is easier to talk on skype so that you can do the desktop sharing and talk me through what exactly you want to achieve. my skype account is erozhnov.
I have read your project details, and I am interested in offering my services.
I provide 100% satisfaction guaranteed on all my work.
Milestone is required to begin; to be released when the job has been satisfactorily completed.
Contact me at your soonest convenience so we may get your solution delivered quickly.
Thanks,
coderXO
Hi
thanks.
I'm pro in google apps script.
see my work history related with google apps script.
https://www.freelancer.com/projects/Javascript/script-google-apps-script/