I will build an ai powered ats with google apps script and gemini


About this gig
Optimize your hiring workflow with a custom AI-powered Applicant Tracking System (ATS). I build end-to-end recruitment solutions using Google Apps Script and Gemini AI to automate everything from CV screening to final document generation.
Core Features:
- AI Resume Scoring: Automatically analyze and rank candidates using Gemini AI logic. Extract education, experience, and skills into Google Sheets instantly.
- Document Automation: Generate professional Offer Letters, Appointment Letters, and Relative Declarations as PDFs or Google Docs with a single click.
- Centralized Dashboard: A web-based portal to manage KPIs, track application status, and view real-time recruitment data.
- Seamless Candidate Experience: Responsive forms for Quick Apply and detailed data collection, including CV uploads to organized Drive folders.
- Email System: Branded HTML interview invitations with automated tracking and logs to prevent duplicate messaging.
- Secure Archiving: Automatic backup of candidate summaries and proposals to a master recruitment database for long-term records.
Scale your recruitment process with a professional, automated tool tailored to your business needs. Contact me today to get started.
Get to know Masud Rana
Graphic Designer, Website Developer, Data Entry Specialist
- FromBangladesh
- Member sinceApr 2025
- Avg. response time1 hour
- Last delivery5 months
Languages
Bengali, English, Chinese, Urdu, Hindi, Spanish, French
My Portfolio
FAQ
What do I need to get started with this system?
To set the system up, you will need a standard Google Account (Gmail or Google Workspace) and a Gemini API Key. I will provide step-by-step guidance on how to generate your API key and where to paste it in the configuration file.
How does the AI CV scoring work?
The system uses the Gemini 2.5 Flash model to analyze uploaded CVs against your specific job requisition. It extracts education, experience, and skills to provide a numerical match score, a summary of the candidate, and identifies specifically matched or missing skills.
Is my data secure?
Yes. All candidate data, resume files, and generated documents are stored exclusively within your own Google Drive and Google Sheets. The system does not use external databases, ensuring you have full ownership and control over your recruitment data.
Can I customize the offer and appointment letters?
Absolutely. The system is built to map data directly to your existing Google Doc templates. You can easily update your company logo, terms, and branding within those templates, and the system will automatically fill in the candidate's details.
What are the ongoing costs for running this ATS?
Because the system runs on Google Apps Script, there are no hosting fees. You only pay for what you use via the Gemini API. Many users find the Gemini "Free Tier" sufficient for moderate hiring volumes.
Can the system handle a high volume of applications?
Yes. The backend includes a Batch Processing feature with a built-in rate limiter and exponential backoff. This prevents the system from hitting Google's execution limits even when scanning dozens of CVs at once.
Does it support automated emails to candidates?
Yes. The system can automatically send branded HTML email confirmations or interview invitations. You can also choose to attach a generated PDF of the candidate's information form for their records.

