Resume Automation & Communication Management
Budget: ₹10,000 – ₹25,000 INR
Job Title: Automate Resume Processing + Screening + Communication (Google Drive + Sheets + Messaging)
Project Overview:
We are hiring a freelancer to fully automate our resume handling process — from Google Drive folder structuring and resume parsing to filtering resumes based on requirements and finally reaching out to selected candidates via Email, WhatsApp, and SMS.
The workflow involves:
Structured resume intake
Resume parsing and matching
Google Sheet integration
Communication automation
This will be a fixed-price project with a 6-month warranty on bugs and compatibility.
Phase 1: Resume Intake & Automation Setup
We will handle the manual downloading of resumes from Naukri, LinkedIn, and Indeed, and upload them to a relevant Google Drive folder.
Folders will be organized by job purpose, with subfolders for each job post within that purpose, and can further be organized platform-wise if needed.
Example Folder Structure:
Job Purpose: Hire Web Development Interns
Job Post 1: “Web Development Interns 6 months stipend Rs 5k” posted on Naukri (Monday – stays on top for 2 days)
Job Post 2: “Web Development Internship 6 months stipend Rs 5k” reposted on Naukri (Wednesday)
Job Post 3: “Web Development Interns 6 months stipend Rs 5k” posted on LinkedIn (Friday – stays on top for 2 days)
Job Post 4: “Web Development Interns 6 months stipend Rs 5k” posted on Indeed (Saturday)
Note: In Job Post 1, we used the word ‘Interns’, and in Job Post 2, ‘Internship’, since portals allow slight title variations within the same month.
You may suggest a more optimized folder structure if helpful. Additionally, there will be one folder (or a structured set) for automation-executed or processed resumes.
Your Scope of Work – Automation (Phase 1):
-- Resume Reading & Data Processing:
Read full resume content (PDF/DOCX) and extract structured data.
Match the data with our existing Google Sheets:
If resume already exists: update only 7 agreed-upon columns in the existing sheet, and add full record to the new sheet.
If resume is new: add the full record to the new sheet.
--Resume File Management:
Move the processed resume to a designated “Processed Resumes” folder.
Copy the file's Google Drive link and insert it into the relevant column in the new sheet.
--Referral Resume Handling:
Referrals will be uploaded into a separate folder.
File names will include the ID of the referrer (employee, intern, or applicant).
Extract resume data, add it to a new sheet, move file to "Processed" folder, and paste the file link in a designated column.
-- Resume Screening / Matching Logic:
Automatically filter resumes based on job-specific skills, experience, education, or location.
Screening rules will be defined by us, and must be configurable or adaptable.
Only shortlisted profiles should move forward for communication.
--Candidate Outreach:
Send messages to selected candidates from all sources (manual, referral, screened).
Communication via Email, WhatsApp, and SMS.
This follows Step 3 of our original process (shared in a PDF with you).
-- Terms:
We require a fixed-rate engagement.
No time tracking, reports, or hourly billing.
The fixed price must include:
100% automation (end-to-end process)
6-month warranty for:
Bug fixes
Tech stack changes requiring updates
Support SLA:
Emails must be responded to within 1 business day (Sunday excluded)
If there's an issue, you must acknowledge it the next business day and resolve it within 2–3 business days
Screening Questions (Must Answer):
Have you built resume automation or applicant screening systems before? Share details and tools used.
How will you extract data from PDF/DOCX resumes? Mention specific tools/libraries.
How will you implement filtering based on job-specific skills and criteria?
How will your system avoid duplicates when a resume already exists in our sheet?
What tools or APIs will you use for sending Email, WhatsApp, and SMS messages? Have you used them before?
Describe your experience in automating Google Drive folder structures and connecting with Google Sheets.
Are you comfortable with our 6-month warranty and response-time requirements?
Share a sample (screenshot or link) of a similar automation or dashboard you've built.
To Apply:
Please submit your fixed price quote, timeline, and detailed answers to the above questions.
Project Overview:
We are hiring a freelancer to fully automate our resume handling process — from Google Drive folder structuring and resume parsing to filtering resumes based on requirements and finally reaching out to selected candidates via Email, WhatsApp, and SMS.
The workflow involves:
Structured resume intake
Resume parsing and matching
Google Sheet integration
Communication automation
This will be a fixed-price project with a 6-month warranty on bugs and compatibility.
Phase 1: Resume Intake & Automation Setup
We will handle the manual downloading of resumes from Naukri, LinkedIn, and Indeed, and upload them to a relevant Google Drive folder.
Folders will be organized by job purpose, with subfolders for each job post within that purpose, and can further be organized platform-wise if needed.
Example Folder Structure:
Job Purpose: Hire Web Development Interns
Job Post 1: “Web Development Interns 6 months stipend Rs 5k” posted on Naukri (Monday – stays on top for 2 days)
Job Post 2: “Web Development Internship 6 months stipend Rs 5k” reposted on Naukri (Wednesday)
Job Post 3: “Web Development Interns 6 months stipend Rs 5k” posted on LinkedIn (Friday – stays on top for 2 days)
Job Post 4: “Web Development Interns 6 months stipend Rs 5k” posted on Indeed (Saturday)
Note: In Job Post 1, we used the word ‘Interns’, and in Job Post 2, ‘Internship’, since portals allow slight title variations within the same month.
You may suggest a more optimized folder structure if helpful. Additionally, there will be one folder (or a structured set) for automation-executed or processed resumes.
Your Scope of Work – Automation (Phase 1):
-- Resume Reading & Data Processing:
Read full resume content (PDF/DOCX) and extract structured data.
Match the data with our existing Google Sheets:
If resume already exists: update only 7 agreed-upon columns in the existing sheet, and add full record to the new sheet.
If resume is new: add the full record to the new sheet.
--Resume File Management:
Move the processed resume to a designated “Processed Resumes” folder.
Copy the file's Google Drive link and insert it into the relevant column in the new sheet.
--Referral Resume Handling:
Referrals will be uploaded into a separate folder.
File names will include the ID of the referrer (employee, intern, or applicant).
Extract resume data, add it to a new sheet, move file to "Processed" folder, and paste the file link in a designated column.
-- Resume Screening / Matching Logic:
Automatically filter resumes based on job-specific skills, experience, education, or location.
Screening rules will be defined by us, and must be configurable or adaptable.
Only shortlisted profiles should move forward for communication.
--Candidate Outreach:
Send messages to selected candidates from all sources (manual, referral, screened).
Communication via Email, WhatsApp, and SMS.
This follows Step 3 of our original process (shared in a PDF with you).
-- Terms:
We require a fixed-rate engagement.
No time tracking, reports, or hourly billing.
The fixed price must include:
100% automation (end-to-end process)
6-month warranty for:
Bug fixes
Tech stack changes requiring updates
Support SLA:
Emails must be responded to within 1 business day (Sunday excluded)
If there's an issue, you must acknowledge it the next business day and resolve it within 2–3 business days
Screening Questions (Must Answer):
Have you built resume automation or applicant screening systems before? Share details and tools used.
How will you extract data from PDF/DOCX resumes? Mention specific tools/libraries.
How will you implement filtering based on job-specific skills and criteria?
How will your system avoid duplicates when a resume already exists in our sheet?
What tools or APIs will you use for sending Email, WhatsApp, and SMS messages? Have you used them before?
Describe your experience in automating Google Drive folder structures and connecting with Google Sheets.
Are you comfortable with our 6-month warranty and response-time requirements?
Share a sample (screenshot or link) of a similar automation or dashboard you've built.
To Apply:
Please submit your fixed price quote, timeline, and detailed answers to the above questions.