Creating a low-cost ATS using Google Sheets
In an earlier post I had talked about using low-code tools to build apps fast.
In this post I will talk about using low-code tools to create an in-house ATS for your startup.
If you are managing the hiring at your startup you would regularly struggle with sending invites, managing the feedback, sending updates to selected, rejected or waitlisted candidates.
Popular ATS’ already solve this problem. But what if you do not want to invest into them right now.
DIY — ATS using Google Sheets & App Scripts
Let’s get started.
Step 1
To get started you would need to accept candidate data in a structured format. We can use Google Forms for this. You can link this wherever you post your job.
Step 2
Create the Google Sheets associated with the Google Form, this is optional when creating the Google Form but you need to create this before adding further functionalities
Steps 3
Create an App Script project associated with this Google Sheet. Next you need to implement the below .gs
functions:
- Create
Menu.gs
to add the toolbar buttons - Create
SendInvites.gs
which sends the invites with Meet link to the candidate as a Calendar Event. - Create
SendUpdates.gs
which sends the updates to candidates over email of the stage of the hiring pipeline.
The complete code is present in the repo here: https://github.com/ankitdbst/ats
Fin.