
Đã đóng
Đã đăng vào
Thanh toán khi bàn giao
I want a lightweight applicant-tracking system that lives entirely in Google Sheets for my recruitment agency. Candidates will enter through a Google Form; their details must feed straight into a master data sheet that can comfortably handle multiple clients, their individual vacancies, and every application tied to each job. A clean dashboard inside the workbook should update in real time, showing: • Total number of applications received • Number of jobs per client • Live breakdown of application statuses (e.g., New, Short-listed, Interviewing, Hired, Rejected) Please structure the data so I can slice or filter by client, by job, or by status without breaking formulas. Standard data security is enough, so protected ranges and sensible sharing permissions will do—no need for enterprise encryption layers. I do not need email or in-app alerts; I’ll review the sheet manually. Deliverables • Google Form linked to the sheet • Master data tab with all captured fields, properly normalised • Dashboard tab with charts/metrics described above, driven by formulas or pivot tables • Brief hand-off note explaining sheet logic and how to add new clients or roles If Apps Script is the smartest way to keep everything tidy or automate look-ups, feel free to use it, but keep the solution contained within Google Workspace. I’m aiming for clarity, speed, and ease of maintenance rather than complex extras.
Mã dự án: 40251986
48 đề xuất
Dự án từ xa
Hoạt động 11 ngày trước
Thiết lập ngân sách và thời gian
Nhận thanh toán cho công việc
Phác thảo đề xuất của bạn
Miễn phí đăng ký và cháo giá cho công việc
48 freelancer chào giá trung bình ₹6.802 INR cho công việc này

Drawing from my seven years of experience as a Full Stack Developer, I assure you that I possess the necessary skills to create a well-organized, efficient and easily maintainable Google Sheets system for your recruitment agency. I have directly applied my abilities in Google Spreadsheet and Excel extensively in the past, including heavy use of formulas, pivot tables, and database analysis which aligns perfectly with your project requirements. My experience as an analyst with firms like Metlife GOSC and DXC technologies has made me well adept at data management practices crucial for handling numerous clients and their vacancies simultaneously without breaking any formulas or processes. Moreover, my domain expertise extends to efficiency improvements through Web Scraping and Automation techniques using services within Google Workspace like Apps Script, which could further streamline your applicant-tracking process without complicating the system.
₹9.000 INR trong 3 ngày
8,8
8,8

Hello, I’m an experienced Google Sheets and Workspace automation specialist, and I can build you a clean, lightweight applicant-tracking system fully contained within Google Sheets and Forms, designed for clarity, scalability, and easy day-to-day use. I will structure a normalized master data tab that cleanly links clients, vacancies, and candidate applications, ensuring the sheet can handle multiple clients and roles without breaking formulas. The connected Google Form will feed directly into the master sheet, and I’ll create a real-time dashboard displaying total applications, jobs per client, and a dynamic status breakdown (New, Short-listed, Interviewing, Hired, Rejected), all filterable by client, job, or status using pivot tables and robust formulas. I’ll implement protected ranges and sensible sharing permissions for data security, and if helpful, use lightweight Apps Script for clean automation while keeping everything within Google Workspace. You’ll also receive a concise hand-off guide explaining the logic and how to add new clients or roles, ensuring the system remains simple, fast, and easy to maintain Regards, Zafar
₹12.500 INR trong 7 ngày
6,3
6,3

Hi There , Good afternoon! I’ve carefully checked your requirements and really interested in this job. I’m full stack node.js developer working at large-scale apps as a lead developer with U.S. and European teams. I’m offering best quality and highest performance at lowest price. I can complete your project on time and your will experience great satisfaction with me. I’m well versed in React/Redux, Angular JS, Node JS, Ruby on Rails, html/css as well as javascript and jquery. I have rich experienced in Google Sheets, JavaScript, Data Analysis, Data Management, PHP, Excel, Software Architecture, Data Visualization, Google Apps Scripts and Data Entry. For more information about me, please refer to my portfolios. I’m ready to discuss your project and start immediately. Looking forward to hearing you back and discussing all details.. Have a great time
₹7.770 INR trong 5 ngày
4,5
4,5

I will create a lightweight applicant-tracking system in Google Sheets, leveraging Google Forms for candidate intake and a master data sheet to handle multiple clients, vacancies, and applications. I will design a clean dashboard with real-time updates, including total applications, jobs per client, and application status breakdown, with data structured for easy filtering by client, job, or status. I will utilize standard data security measures, including protected ranges and sharing permissions, and deliver a Google Form, master data tab, dashboard tab, and brief hand-off note, potentially using Apps Script for automation, all within Google Workspace, adapting to your proposed budget. Waiting for your response in chat! Best Regards.
₹8.461 INR trong 3 ngày
4,8
4,8

Hello There. ⇛My Philosophy is “Quality is never an accident it is always the result of an intelligent effort! Professional Multilingual Service Provider. Given the chance to be in long-term Cooperation! ▶Expertise and Specialties is? & What Services I Provide? ✔️Excel ✔️DAX ✔️Python ✔️SQL ✔️Tableau ✔️Scraping ✔️PPT ✔️Google-Sheets ✔️Typing ✔️ Web Scraping ✔️Data Extraction ✔️Data collection ✔️Leads ✔️Spreadsheet - Formulas ✔️PDF-MS Expert ✔️power-BI specialist ✔️Functions ✔️Macros ✔️VBA ✔️Dashboards ✔️Graphs ✔️Charts ✔️Pivot tables ✔️Flow charts ✔️ODOO ✔️Data Analysis ✸ Google-sheets ✔️Data Processing ✔️ Please leave a message here in via chat box. Thank You!
₹4.000 INR trong 1 ngày
4,6
4,6

As a passionate Data Scientist specializing in Data Analysis, your Google Sheets Applicant Tracking Dashboard project aligns perfectly with my expertise. With a Master’s degree in Data Science, I’m skilled at structuring and managing complex datasets efficiently. I’ve built dynamic dashboard tabs featuring live insights, pivot tables, charts, and key metrics—exactly what your project requires. I’m also experienced with Google Workspace tools, including Google Forms and Apps Script, enabling me to develop a streamlined, fully integrated solution within Google Sheets. My background in data management and visualization ensures your database remains organized and scalable, with stable formulas that hold up during filtering and slicing. I prioritize clarity, performance, and maintainability, delivering well-documented systems for easy long-term use. With clear communication, fast turnaround, flexible pricing, and ongoing support, I’m committed to your satisfaction. Let’s build a clean, efficient applicant tracking system that brings structure and visibility to your hiring process.
₹1.500 INR trong 5 ngày
4,3
4,3

I will build a lightweight applicant-tracking system fully inside Google Workspace, where candidates apply through a Google Form that feeds directly into a structured master sheet. The data will be properly organized to support multiple clients, jobs, and application statuses without breaking formulas. A real-time dashboard tab will display total applications, jobs per client, and a live status breakdown using pivot tables and formulas, with slicers to filter by client, job, or status. The sheet will include protected ranges for security and a simple handoff guide explaining how to add new clients or roles. Optional Apps Script can be used to automate IDs or dropdown logic while keeping everything contained within Google Sheets.
₹3.000 INR trong 2 ngày
3,5
3,5

Hello, I understand you want a lightweight, fully Google Workspace–based applicant tracking system, where candidates enter via a Google Form and everything flows into a structured, scalable Google Sheet with a real-time dashboard. I can design a clean architecture with: • A Google Form linked directly to a normalized Master Data sheet • Structured tables separating Clients, Jobs, and Applications to keep relationships clear • Status tracking (New, Short-listed, Interviewing, Hired, Rejected) driven by controlled dropdowns • A live Dashboard showing total applications, jobs per client, and real-time status breakdowns The data model will be built so you can filter or slice by client, job, or status without breaking formulas. I’ll use structured references, pivot tables, and clean formula logic so the sheet remains stable even as data grows. Protected ranges will ensure the calculation and dashboard logic stay intact, while allowing you to update statuses and add roles freely. If helpful, I can use lightweight Apps Script to automate lookups or maintain relational consistency—but only if it improves clarity and usability. You’ll receive: • The connected Google Form • A well-structured Master Data sheet • A dynamic Dashboard tab • A short hand-off guide explaining logic and how to add new clients or vacancies If you’re aiming for clarity, scalability, and ease of maintenance without unnecessary complexity, I’d be happy to build this for you. Best Regards, Sajjad
₹5.000 INR trong 1 ngày
3,5
3,5

Hi! Imagine your recruitment agency running like a well-oiled machine — every candidate form submission flows straight into a clean master sheet, auto-updates live dashboards, and gives you instant visibility on applications, jobs per client, and status breakdowns (New → Short-listed → Hired) with zero manual copying.I’ll deliver the complete solution in 1 day:Google Form capturing all candidate details Master data tab with normalised columns + protected ranges Dynamic dashboard tab (pivot tables + charts) showing totals, client breakdowns, status pies — refreshes automatically Short hand-off note explaining how to add clients/jobs and refresh views Fixed price: $120 (perfect for this scope & precision) Share your field list & branding now — I’ll build it spot-on and make your tracking effortless today!
₹12.000 INR trong 1 ngày
3,4
3,4

Hi, I can build a clean, scalable Google Sheets–based ATS that fits exactly your workflow—Google Form intake feeding a normalized master sheet structured for multi-client and multi-role tracking, with reliable status management and easy filtering by client, job, or stage. I’ll design the data model (Clients / Jobs / Applications tabs), connect the Form, and create a real-time dashboard using pivot tables and charts showing total applications, jobs per client, and live status breakdown. Where helpful, I can add lightweight Apps Script (auto-IDs, dropdown sync, data validation) while keeping everything fully maintainable inside Google Workspace. You’ll receive the form, structured workbook, dashboard, and a short handover guide explaining how to add new clients/roles and maintain formulas. I’ve built similar Sheet-based CRMs/trackers and can deliver a clear, fast, easy-to-use system aligned with your needs.
₹7.000 INR trong 7 ngày
2,3
2,3

I understand you're looking for a lightweight applicant-tracking system in Google Sheets that integrates seamlessly with a Google Form for candidate submissions. The requirement for a master data sheet to handle multiple clients and vacancies, along
₹1.650 INR trong 7 ngày
2,3
2,3

I can build a clean, scalable applicant-tracking system fully داخل Google Sheets that is easy to manage and updates in real time. I have experience creating structured data workflows with Google Forms, dashboards, and automation while keeping everything simple and maintainable. I will deliver: • Google Form connected directly to a normalized master data sheet • Structured tabs for clients, jobs, and applications (filter-friendly) • Real-time dashboard with metrics, charts, and status breakdowns • Protected ranges and proper permissions for data safety • Optional Apps Script automation for lookups (if beneficial) • Clear hand-off guide for adding new clients or roles The system will be optimized for clarity, speed, and long-term usability without unnecessary complexity. I’m ready to start immediately and can complete this within a few days.
₹5.000 INR trong 2 ngày
3,1
3,1

Hello, My name is Anil Prajapati. I can build a clean, lightweight applicant-tracking system entirely in Google Sheets for your recruitment agency. I will provide: A Google Form for candidate submissions linked to a master data sheet Properly structured master data tab to handle multiple clients, vacancies, and applications A real-time dashboard with total applications, jobs per client, and live status breakdowns Pivot tables or formulas for easy filtering and slicing by client, job, or status Optional Apps Script automation for tidy lookups and real-time updates A brief hand-off note explaining the sheet logic and how to add new clients or roles The solution will be fully contained within Google Workspace, easy to maintain, and secure with protected ranges. Best regards, Anil Prajapati
₹7.000 INR trong 7 ngày
2,2
2,2

Hello, I can build a lightweight Applicant Tracking System (ATS) using Google Sheets and Google Forms that will allow your recruitment agency to easily manage candidates, clients, and job vacancies in one organized workspace. I have 8+ years of experience working with data systems, dashboards, and automation, including Google Sheets, Excel dashboards, and workflow automation. I can design the system so it remains fast, clean, and easy to maintain even as your data grows. How I Will Implement Your System 1. Google Form Integration Create a structured Google Form for candidate applications Automatically feed submissions into the master data sheet 2. Master Data Structure Normalized data tables for: Clients Job vacancies Candidate applications Structured columns so data can be filtered by client, job, or status without breaking formula2
₹7.000 INR trong 2 ngày
2,1
2,1

Hi there, I completely agree you don't need expensive enterprise software to run a highly effective recruitment agency. A well-structured Google Workspace setup is perfect for this. I specialize in building lightweight, scalable Google Sheets dashboards that are easy to maintain and completely break-proof. Here is exactly how I will build your Applicant Tracking System (ATS): --> Streamlined Intake: A custom Google Form feeding candidate details directly into a neatly normalized Master Data tab. --> Protected Data: I will use data validation for status updates (New, Short-listed, Interviewing, Hired, Rejected) and apply protected ranges so you can safely sort and filter without breaking formulas. --> Live Dashboard: Using clean QUERY functions and Pivot Tables, I will build a real-time visual dashboard tracking total applications, jobs per client, and status breakdowns. You can slice data instantly by client or role. --> Zero Bloat: Relying on robust native functions for speed and easy maintenance. Any necessary Apps Script will be clean and fully documented. Project Details: --> Timeline: 2 days --> Estimated Cost: ₹2,999 INR Upon completion, I will provide a brief hand-off guide showing exactly how to add new clients and roles. Would you like me to map out a quick wireframe of the Dashboard layout so you can see how your metrics will be visualized before we officially start?
₹2.999 INR trong 2 ngày
2,0
2,0

Hi, I can easily DO your work IN 24 HOURS, DM me now to get started, PRICE NEGOTIABLE 100% Work satisfaction is provided
₹2.000 INR trong 1 ngày
1,7
1,7

This project requires building a structured Google Sheets applicant tracking system where inconsistent entries or poor status management can cause missed follow-ups and hiring delays. I would design a clean, organized tracker with standardized fields, clear status stages, and reliable updating to keep the recruitment pipeline transparent and efficient. Do you need automated status tracking or dashboard summaries included for better visibility?
₹1.500 INR trong 2 ngày
2,1
2,1

Hello, I can build a clean, reliable applicant tracking system in Google Sheets that is easy to use and maintain. I will set up: • A Google Form connected to a master application database • Properly structured sheets for Clients, Jobs, and Applications • Validated dropdowns for status and roles to avoid errors • A live dashboard with totals, status breakdown, and client/job filters • Protected ranges and clear sharing setup • Simple documentation on how to add new clients and roles The system will be designed so filters and formulas never break, even as data grows. If useful, I can also add light Apps Script automation for lookups and data consistency. I have experience designing structured spreadsheets and dashboards for operational and reporting workflows, and I focus on clarity, accuracy, and long-term usability. Delivery: 5–7 days Support included after handover. Looking forward to working with you. Best regards, Dhivya
₹9.000 INR trong 7 ngày
1,4
1,4

Hi there, You’re absolutely in the RIGHT PLACE. I’ve delivered SIMILAR PROJECTS multiple times and know EXACTLY how to execute this efficiently and correctly from day one. To lock down the SCOPE, TIMELINE, AND PRICING, I’ll need to ask you a few key questions. Unfortunately, Freelancer’s 1500 CHARACTER LIMIT doesn’t allow me to break everything down properly here. Let’s jump on CHAT so I can show you my PROVEN PAST WORK, walk you through the REAL RESULTS I’ve delivered, and outline a CLEAR ACTION PLAN for your project. You’ll immediately see why my approach is DIFFERENT and EFFECTIVE. If you’re serious about getting this done RIGHT, I’m ready to move forward. Looking forward to CONNECTING and WINNING TOGETHER. Cheers, Aayushaman Sahu
₹7.000 INR trong 7 ngày
0,2
0,2

As a seasoned software developer and tester, I am well versed in the intricate world of Google Sheets and have significant experience with JavaScript – precisely what your project requires! Creating a reliable and efficient system for managing data is my strong suit. I will not only set up a tailored Google Form linked directly to the sheet but also ensure that all captured fields are properly normalized in a master data tab. In order to provide you with real-time updates and simplify your data analysis process, I will construct a clean, intuitive dashboard with charts and metrics that automatically update as new data is added. Using JavaScript via Apps Script, I'll make sure the formula-driven dashboard operates smoothly without compromising the simplicity you desire. Moreover, my knack for solving complex problems in a simplified manner aligns well with your project goals. I assure you that I'll streamline all operations so that filtering data by client, job, or status becomes a breeze. As we conclude the project, I'll provide a comprehensive hand-off note explaining the logic behind the sheets and how to add new clients or roles – ensuring no knowledge gaps. Your satisfaction and success are at the forefront of my work. Choose me for an optimal blend of intricate technical knowledge and an eye for clarity, speed, and ease of maintenance—precisely what your recruitment agency needs!
₹9.000 INR trong 7 ngày
0,0
0,0

Bhiwadi, India
Phương thức thanh toán đã xác thực
Thành viên từ thg 4 2, 2022
₹600-1500 INR
₹600-1500 INR
₹600-1500 INR
₹1500-12500 INR
₹1500-12500 INR
€12-18 EUR/ giờ
$15-25 USD/ giờ
₹12500-37500 INR
$30-250 USD
$10-30 USD
₹1500-12500 INR
$250-750 USD
$10-30 USD
$250-750 USD
₹12500-37500 INR
€250-750 EUR
₹1500-12500 INR
₹37500-75000 INR
$250-750 USD
₹1500-12500 INR
$15-25 USD/ giờ
₹12500-37500 INR
₹12500-37500 INR
€12-18 EUR/ giờ
$15-25 USD/ giờ