How to send Google form applicants to Org Charts

Question

I need to automate the applicant and position ownership processes:
Forms> Acceptance> Plug them into an Org chart

Let me know if I can provide more use case info. I tried using Apps Script.

Thank you,

Answer 1

You can definitely use Google Apps Script to accomplish this.

First you need to create a Google Form the users will need to fill and get the data of that form in a spreadsheet. Once you have the spreadsheet you can start using Google Apps Script to create the users based on the data from the spreadsheet.

There is a code sample on how to create users in the Admin console using Google Apps Script here. I am assuming you will create your script so that it can add users based on the information introduced in the data from the spreadsheet, so you have the list of methods you can use here.

You would also need to add a trigger to your script so it starts running every time the spreadsheet gets edited, meaning that a user will get automatically created by the script every time someone fills the form and the responses get recorded in the spreadsheet.