
Open
Posted
•
Ends in 5 days
Paid on delivery
Project Title: Google Form + Google Sheet Automation for Staff Attendance & Salary Calculation Project Description: I need a professional who can create and integrate a Google Form with Google Sheets to manage staff attendance. The system should track check-in & check-out timings, maintain attendance records, and automatically calculate monthly salary based on working hours/days. Key Requirements: • A Google Form where staff can mark their Check-in & Check-out. • Data should automatically update in a linked Google Sheet. • Automatic calculation of: • Date, Day, and Month of each entry • Total working hours per employee • Total present/absent days • Salary calculation based on working days/hours & rate (to be entered per employee). • Easy to use, clean, and reliable setup. • Bonus: If possible, send monthly reports automatically. Deliverables: • Google Form (for attendance logging) • Google Sheet (with formulas/automation for salary & reports) • Documentation on how to use and maintain the system Budget: (Open to offers – please quote your best price) Deadline: Preferably within 5–7 days
Project ID: 39743791
43 proposals
Open for bidding
Remote project
Active 14 hours ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
43 freelancers are bidding on average ₹193,384 INR for this job

I can develop salary management tool on google spreadsheets using google forms and google app script automation. This will have functionalities of marking attendance on google form, auto calculating the salaries based on attendance and automatically sending monthly reports on your email. I have successfully completed many projects on google app script automation. Please have a look at my portfolio or ping me to discuss in detail. I am an Excel & VBA Automation Expert with an MBA and 10+ years of experience delivering smart solutions to global clients (eg. Decathlon, E&Y, Schindler). I’ve successfully completed 100+ projects (4.9★ rating), helping businesses save time, reduce errors, and boost efficiency. My expertise includes: ✔ Advanced Excel Dashboards ✔ VBA-based Automation for Excel, Word & PowerPoint ✔ Stock Market Tools with API Integration ✔ E-commerce Data Processing (Amazon/Flipkart) ✔ Sales & Inventory Management Solutions Looking forward to working with you!
₹20,000 INR in 4 days
6.1
6.1

Hi, I have gone through the Job details and am interested in taking it up. I need you to share more details with me, and I will deliver the required tasks fast and accurately. We will negotiate my fees depending on how many hours it will take to fulfill the work. I’m Ahmed Hassanein. I’ve been working with MS Office since the 90’s as a user, developer, and trainer. I've been using formulas, VBA, and macros in Excel since 2004. I completed Excel VBA and Google Sheets Apps Script jobs for happy customers (check my job reviews). I have over 25 years of experience supporting systems and users in the information technology field such as office applications, domain servers, application servers, network security, information systems audit, etc. I would be happy if we connect to talk more about your Job and discuss how I can help you accomplish it. Thank you and kind regards.
₹12,500 INR in 7 days
6.0
6.0

I am sure you will give me more projects after this. I have done a similar project a week ago. I am interested to do this project too and ready to complete this within the timeline. Pls check my profile to see all rating and reviews given by clients. Hoping to hear from you soon. Note: Budget Negotiable.
₹7,000 INR in 1 day
4.4
4.4

As an experienced data analyst and automation expert, I believe I can provide the precise solution you're seeking for your Staff Attendance & Salary Automation project. My eight years of using tools like Microsoft Excel, Excel VBA, Advance Formula, and Google Sheets have equipped me with a deep understanding of their capabilities and a keen sense of how to apply them to streamline complex processes. My expertise spans across areas such as data automation, spreadsheet integration, data modeling, and dynamic reporting. This equips me uniquely to create the Google Form- Google Sheet system you need to simplify your staff attendance tracking and salary calculation. With my skills in Excel VBA and Google Sheets along with a focus on automation, the system I will develop will be efficient and reliable, saving you valuable time and resources. Hire me today and let's revolutionize how you manage your HR tasks!
₹7,500 INR in 3 days
4.6
4.6

Hi, My name is Taranum, and I have proficiency in Excel and Google Sheets. I can create a user-friendly Google Form where your staff can log their check-in and check-out times. These entries will then automatically update an associated Google Sheet where vital attendance records will be maintained. My expertise also extends to developing intricate formulas and automations in Google Sheets, which will be central to your salary calculation process. I understand the need for accurate calculation of total working hours per employee, total present/absent days, as well as salary based on working days/hours and rate, precisely. I would also work on integrating the date, day, and month factors into each entry for more comprehensive evaluation. Looking forward to adding value to your team! Regards Taranum
₹9,000 INR in 7 days
3.9
3.9

Hello, I am Daksh Mahaur, VBA Developer with expertise in Google Sheets automation and workflow optimization. I can create a Google Form + Google Sheet system for staff attendance that will: Track check-in & check-out automatically Calculate daily working hours and attendance Generate monthly salary reports with formulas & automation (Bonus) Send automated monthly reports via email I ensure a clean, reliable, and easy-to-maintain setup, along with documentation for smooth usage. Let’s connect—I can deliver this within 5–6 days. Best Regards, Daksh Mahaur VBA Developer
₹10,000 INR in 7 days
4.1
4.1

With 8 years of experience in similar projects, I am the best fit to complete this requirement. I have the relevant skills to create and integrate a Google Form with Google Sheets for managing staff attendance and salary calculation. How I will be completing this project: - Develop a user-friendly Google Form for staff to mark their check-in & check-out timings. - Implement automation to update data in a linked Google Sheet in real-time. - Create formulas for automatic calculation of date, day, month, total working hours, present/absent days, and monthly salary based on input rates. - Set up a clean and reliable system for easy use by staff and managers. - If feasible, enable monthly report generation and automatic sending. What tech stack I will be following: - Google Forms for data input - Google Sheets for data storage and calculation - Google Apps Script for automation and integration I have worked on similar solutions in the past, ensuring a successful outcome for this project. I will deliver a Google Form for attendance logging, a Google Sheet with automation for salary calculations and reports, and comprehensive documentation for system usage and maintenance. Let's collaborate to create an efficient attendance and salary management system that meets your requirements. Feel free to share your budget expectations, and I will provide a competitive quote. The project can be completed within 5-7 days from the start date.
₹1,500 INR in 7 days
3.5
3.5

Hello, I have good experience in google sheets and can easily prepare for you google forms which will be filled by employees, and these forms will automatically give updated data in google sheet, where the employees salaries will be calculated. I will be happy to discuss the details of the project and wait for your message. Thankyou
₹3,700 INR in 5 days
3.2
3.2

As an experienced and passionate professional in data entry, analysis, and management, I believe my proficiency in Microsoft Excel combined with my attention to detail makes me an excellent fit for your project. Over the years, I've not only honed my typing skills to be fast but also accurate, ensuring that your textual and numerical data are entered into Excel without discrepancies.
₹8,500 INR in 7 days
1.2
1.2

As an experienced and professional Google Sheets user with expertise in data management, complex formulas, and automation, I am the ideal candidate for your project. Over the last 10 years, my team and I have been successfully executing tasks such as yours while consistently delivering a top-quality result with a short turnaround time. We have gained valuable experience with platforms like Google Forms and Sheets and we can set up forms to track check-ins and check-outs and automatically update data in linked Sheets. Another strong advantage of choosing me is my proficiency in generating detailed documentation; at the end of your project, you'll have a comprehensive guide on how to navigate and maintain the system. To further enhance our collaboration, we have a robust communication plan so that any queries or updates can be swiftly addressed. Let's equip your organization with an efficient attendance and salary automation system that will save you time and money
₹12,500 INR in 7 days
0.0
0.0

Hello, I can create a Google Form and Sheet system for staff attendance and salary calculation. Staff will mark Check-in & Check-out on the Form. All data will update automatically in Google Sheet. Sheet will calculate date, day, month, working hours, present/absent days, and salary per employee. I can also set up automatic monthly reports if needed. The system will be clean, simple, and easy to use. I will provide documentation for maintenance and usage. I can complete this within 5–7 days. My quote: ₹ 9000
₹9,000 INR in 5 days
0.0
0.0

Dear Client, I am pleased to submit this proposal for your staff attendance management system. As a Data Entry & Payroll Specialist with over 8 years of experience, my skills in Google Forms and Google Sheets are a perfect match for your needs. I have a proven track record of creating efficient, automated systems for employee data. I will build a complete solution that is both accurate and reliable: Google Form: A user-friendly form for staff to easily mark check-in and check-out times. Automated Data Flow: The data will automatically update in a linked Google Sheet, removing the need for any manual input. Automated Calculations: I will implement custom formulas to instantly calculate total working hours, present/absent days, and salary based on your provided rate. As a bonus, I can implement a script to automatically generate and email monthly attendance reports to a designated address. My meticulous attention to detail ensures this system will be highly accurate, saving you significant time and effort. I am confident in my ability to deliver an exceptional solution that streamlines your processes. Thank you for your time. I look forward to discussing this project with you. Sincerely, Mira Agrivina AdeyafrisMira Agrivina
₹8,000,000 INR in 7 days
0.0
0.0

Since i have worked for HRs who has created sheets regarding employee activities, i can pull the best out of it
₹7,500 INR in 7 days
0.0
0.0

Hello, I can create and integrate a complete Google Form + Google Sheet automation system for staff attendance and salary calculation as per your requirements, and I will deliver it within 5–7 days. ✅ What I will deliver: A Google Form for employees to check-in & check-out Automatic syncing of data into a linked Google Sheet Calculation of: • Date, day, and month of each entry • Total working hours per employee • Present/absent days • Monthly salary based on working days/hours and employee rate Clean and easy-to-use setup with step-by-step documentation (Bonus) Automated monthly reports generated directly from Google Sheets ✅ Why me: Experienced with Google Sheets automation, advanced formulas, and reporting Skilled at building error-free, reliable, and user-friendly systems Committed to completing the project within 5–7 days ? I can complete this project for ₹6,500, ensuring accuracy, usability, and full documentation so your team can maintain the system easily in the future. Looking forward to your response and to building this solution for you. Best regards, Prince
₹6,500 INR in 6 days
0.0
0.0

As an experienced corporate project manager, I am well-versed in handling complex data management tasks using Excel and Google Sheets - just like the one you have in mind. My proficiency in these tools along with my excellent typing and content writing skills makes me a perfect fit for creating an automated attendance and salary system. I understand the critical aspects of staff attendance as it relates to salary calculations, which empowers me to create a robust solution tailor made to your needs. With a keen eye for detail, I can ensure that your Google Form is seamlessly linked with Google Sheets where data will update in real-time, allowing you to easily monitor check-in and check-out times while maintaining accurate attendance records. Moreover, through smart formulas, I will calculate total working hours per employee, their presence/absence days and using the rate that you provide per employee, calculate their monthly salary. I'm committed to delivering an efficient system that doesn't compromise on ease of use or reporting capabilities. If required by you, I'll make sure monthly reports are automatically sent your way. My experience provides me the foresight of potential obstacles and allows me to plan strategies accordingly to meet agreed-upon deadlines punctually. Let's get started on creating a system that helps you efficiently manage your staff attendance and automate salary calculations!
₹7,000 INR in 7 days
0.0
0.0

Highly motivated, adaptable, and tech-savvy professional with strong communication skills, ideal for remote work
₹7,000 INR in 7 days
0.0
0.0

Hello Sir, I can build a professional Google Form + Google Sheet automation system for staff attendance and salary calculation. ✅ Staff check-in/out via Google Form ✅ Auto-updated records in Google Sheet ✅ Automatic calculation of working hours, days & salary ✅ Monthly report generation (bonus feature) ✅ Clean, simple & reliable setup with documentation Why me? Strong experience in Google Sheets automation & formulas Fast delivery within 5–7 days Support after completion until you are fully satisfied Budget: ₹7,000 Timeline: 7 days I am confident I can deliver exactly what you need. Let’s start ? Best Regards, [Abhishek Kumar]
₹7,000 INR in 7 days
0.0
0.0

I will create a professional Google Form + Google Sheet automation system with check-in/out, auto working hours calculation, attendance tracking, and accurate monthly salary reports. Easy-to-use and error-free solution within 3 days.
₹7,000 INR in 7 days
0.0
0.0

I have completed a live project on Excel with HCL Tech using advanced Excel. I have made an interactive dashboard for the live project for live tracking.
₹7,000 INR in 7 days
0.0
0.0

Proposal: Google Form + Google Sheet Automation for Staff Attendance & Salary Calculation Hello, I have carefully read your project requirements and I can deliver a complete solution to automate staff attendance and salary calculation using Google Forms and Google Sheets. With my strong experience in Google Workspace automation and Excel/Sheets formulas, I will ensure your system is easy to use, accurate, and fully automated. ✅ My Approach: Google Form Setup A simple and user-friendly form for staff to mark Check-in and Check-out. Google Sheet Integration Attendance data from the form will automatically update in the linked Google Sheet. Automated calculation of Date, Day, Month, Working Hours, Present/Absent days, and Salary (based on per-employee rate). Salary & Reports Salary will be calculated automatically at the end of each month. (Bonus) Monthly report generation can be automated and emailed directly. Documentation & Handover Clear instructions on how to maintain and use the system. ✅ Why Choose Me: 10+ years of professional experience in Excel, Google Sheets, and automation. Successfully delivered similar attendance & payroll automation projects. Deliverables: Fully functional Google Form (for attendance logging). Linked Google Sheet with automation for attendance & salary. Step-by-step documentation for future use. Looking forward to working with you. Best Regards, Ramesh Kumar
₹7,000 INR in 2 days
0.0
0.0

Delhi, India
Member since Aug 29, 2025
$750-1500 USD
₹12500-37500 INR
₹100-400 INR / hour
€250-750 EUR
£20-250 GBP
$10-30 USD
$25-50 USD / hour
$15-25 USD / hour
$1500-3000 USD
$30-250 USD
$30-250 USD
₹600-1500 INR
$30-250 AUD
₹12500-37500 INR
$250-750 AUD
$2-8 USD / hour
$25-50 CAD / hour
$15-25 USD / hour
$2-8 CAD / hour
₹1500-12500 INR