One of the new templates that Sheetgo has come up with is for Recruitment
Once you install the template the workflow should look something like this
![](https://i.imgur.com/K80jJxjh.png)
You can find this in the template gallery - or use this link to directly go to the template
![](https://i.imgur.com/Xu8dKdW.png)
A detailed description of how to operate the template can be found in the Notes section of the workflow - you can add to these notes as well and customize it to keep track of your process
![](https://i.imgur.com/8aJGJI2h.png)
To start working with the template first clear out all the sample data from the sheet
Some columns have formulas in them usually in the header - these columns will be greyed out - while clearing out the data be careful not to remove the formulas
![](https://i.imgur.com/pzo0dm8h.png)
Go to the forms section of the workflow - the forms help in streamlining and standardizing the data entry into sheets - you will have 3 forms to run the system
![](https://i.imgur.com/eNCgj95h.png)
- Record any new positions which open up in the company - this needs to be posted as a new recruitment request
![](https://i.imgur.com/KW7RMXZh.png)
- For one such request you can have one or more openings - for example you can hire 3 people as software developers
- Mark a new request as Open - then you can start taking in applications for it
![](https://i.imgur.com/Ngbsa3ah.png)
- When a new request is submitted you can then tag multiple candidates to it - so lets say you have to hire 3 software developers, you can tag the CV’s of 10 people for those 3 roles
![](https://i.imgur.com/M36veK3h.png)
- For each of these candidates - you can then update the status of the candidate as they are navigating the different stages of the interview process
![](https://i.imgur.com/Z5Swvmkh.png)
- Once a vacancy has been filled out you can mark it Closed
![](https://i.imgur.com/34Xl4e3h.png)
- For a particular candidate you can look at all the stages that they have passed through and their final hiring result
![](https://i.imgur.com/KsEmOAch.png)
All the different form dropdown options can be customized via the Parameters tab on the sheet
The template is easy to install and start with - since all the data is recorded on google sheets you can further analyze the data as per your needs.