Google-Based Staff Tracker & Daily Update System
Budget: ₹1,500 – ₹12,500 INR
Project Title:
Automated Daily Staff Update & Attendance Tracker (Google Forms + Sheets + Reminder System)
Background:
I run a medical clinic with multiple departments. We have staff who need to submit daily updates of their work and mark attendance. I want to eliminate manual tracking and switch to a Google-based system that is simple, reliable, and mobile-friendly.
Scope of Work:
1. Design Google Form for Daily Work Update
Fields to include:
Staff Name (Dropdown)
Centre (Nova or SASH)
Time-In
Work Done (Paragraph)
Pending Work / Follow-ups
Timestamp should be automatically captured.
Ensure a clean and mobile-optimized layout.
2. Link to Google Sheet
Responses should flow into a Google Sheet automatically.
Sheet must include:
Attendance status: “Present” if submitted before 6 PM.
Highlight staff who missed submitting.
A dashboard-style view (preferably with conditional formatting).
Export options if needed.
3. Automation: Reminder System
Send a daily WhatsApp message or SMS (via Twilio/WATI or alternatives) at:
10:00 AM → Morning reminder to fill the form.
5:30 PM → Reminder to fill before cut-off.
Automation should be trigger-based or time-based.
4. Security & Cleanup
After form is submitted, no data should remain on device (tablet or phone).
Data should be stored only in linked Google Sheet.
Preferably, restrict form access to clinic devices/staff.
Preferred Skills:
Google Forms & Google Sheets Automation
Google Apps Script (for logic & formatting)
Experience with WhatsApp API / WATI / Twilio
Familiarity with simple dashboard creation in Sheets
xperience working with clinics/healthcare (preferred but not mandatory)
Optional (Bonus):
If you can create a voice note-based version of the form that’s a plus.
Devices Used:
Staff may use Android phones or clinic tablets (local language support preferred - Tamil).
Deliverables:
Fully functional Google Form + Linked Google Sheet
WhatsApp/SMS integration with automation
Documentation & training guide for staff (if needed)
Optionally: Script to auto-update attendance based on time
Deadline:Need a working version within 7 days.
Automated Daily Staff Update & Attendance Tracker (Google Forms + Sheets + Reminder System)
Background:
I run a medical clinic with multiple departments. We have staff who need to submit daily updates of their work and mark attendance. I want to eliminate manual tracking and switch to a Google-based system that is simple, reliable, and mobile-friendly.
Scope of Work:
1. Design Google Form for Daily Work Update
Fields to include:
Staff Name (Dropdown)
Centre (Nova or SASH)
Time-In
Work Done (Paragraph)
Pending Work / Follow-ups
Timestamp should be automatically captured.
Ensure a clean and mobile-optimized layout.
2. Link to Google Sheet
Responses should flow into a Google Sheet automatically.
Sheet must include:
Attendance status: “Present” if submitted before 6 PM.
Highlight staff who missed submitting.
A dashboard-style view (preferably with conditional formatting).
Export options if needed.
3. Automation: Reminder System
Send a daily WhatsApp message or SMS (via Twilio/WATI or alternatives) at:
10:00 AM → Morning reminder to fill the form.
5:30 PM → Reminder to fill before cut-off.
Automation should be trigger-based or time-based.
4. Security & Cleanup
After form is submitted, no data should remain on device (tablet or phone).
Data should be stored only in linked Google Sheet.
Preferably, restrict form access to clinic devices/staff.
Preferred Skills:
Google Forms & Google Sheets Automation
Google Apps Script (for logic & formatting)
Experience with WhatsApp API / WATI / Twilio
Familiarity with simple dashboard creation in Sheets
xperience working with clinics/healthcare (preferred but not mandatory)
Optional (Bonus):
If you can create a voice note-based version of the form that’s a plus.
Devices Used:
Staff may use Android phones or clinic tablets (local language support preferred - Tamil).
Deliverables:
Fully functional Google Form + Linked Google Sheet
WhatsApp/SMS integration with automation
Documentation & training guide for staff (if needed)
Optionally: Script to auto-update attendance based on time
Deadline:Need a working version within 7 days.
Related categories:
PHP
Website Design
Project Management
CSS
HTML
Documentation
Twilio
Google Sheets
Automation
Data Management