
Closed
Posted
Paid on delivery
1. Objective Develop a mandatory weekly vehicle checklist system fully operated via WhatsApp, with automated reminders, photo validation, cloud storage, and Excel tracking. Drivers must complete the checklist every Friday. The checklist is not considered completed until: All questionnaire fields are answered All required photos are uploaded The system validates everything 2. Input data (Excel – provided by client) An Excel file will be provided as the source of truth for vehicles and drivers. Sheet: VEHICLES_MASTER Each row = one vehicle Mandatory columns: VEHICLE_PLATE VEHICLE_TYPE → TRUCK or VAN DRIVER_NAME DRIVER_PHONE (WhatsApp number, international format) INTERNAL_ID (optional) DELEGATION (optional) This file determines: Who receives the WhatsApp messages Which vehicle is assigned Which photo rules apply 3. WhatsApp checklist flow (state-based) Each weekly checklist runs as a state machine and resumes where the driver stopped. Trigger (every Friday) At 08:00, the system creates a new checklist for each vehicle and sends: “Weekly mandatory vehicle checklist for {VEHICLE_PLATE}. Please complete it today.” 4. Questionnaire (mandatory) The questionnaire is completed directly in WhatsApp. Mandatory fields: Current odometer (km) – numeric General condition – OK / Issues Tyres – OK / Not OK Lights – OK / Not OK Brakes – OK / Not OK Dashboard warning lights – Yes / No Notes / defects / upcoming maintenance (free text field) ⚠️ If any item is “Not OK”, the Notes field becomes mandatory. 5. Mandatory photos (validated by system) Additional mandatory photo 1 photo of the odometer (km) → This photo is always required, regardless of vehicle type. Photo rules by vehicle type TRUCK Total required photos: 7 4 exterior photos: Front Rear Left side Right side 2 interior photos: 5. Cabin – dashboard 6. Cabin – general interior 1 odometer photo: 7. Km / dashboard showing mileage VAN Total required photos: 5 2 exterior photos: Front Rear 2 interior photos: 3. Cabin – dashboard 4. Cabin – general interior 1 odometer photo: 5. Km / dashboard showing mileage The checklist cannot be completed unless all required photos are received. 6. Cloud folder structure (automatic) Photos and documents must be stored automatically using this structure: /VEHICLE_CHECKLISTS/ └── {VEHICLE_PLATE}/ └── {YEAR}-{ISO_WEEK}/ ├── Checklist_{VEHICLE_PLATE}_{YEAR}-{WEEK}.pdf ├── FOTOS/ │ ├── [login to view URL] │ ├── [login to view URL] │ ├── [login to view URL] │ ├── [login to view URL] │ ├── [login to view URL] │ ├── [login to view URL] │ └── [login to view URL] └── EXTRAS/ (only if defects are reported) Photo names are system-generated The PDF is generated automatically from questionnaire + metadata + links to photos 7. Generated checklist document The generated PDF must include: Vehicle plate Driver name and phone Week number Date/time started and completed Odometer (typed value) All questionnaire answers Notes / defects / upcoming maintenance Checklist result: OK COMPLETED WITH ISSUES Reference to stored photos 8. Reminder and enforcement logic (VERY IMPORTANT) Reminder schedule (Friday) 08:00 → Checklist created + first WhatsApp message 13:00 → Reminder if checklist not completed 17:00 → Reminder if checklist not completed 19:00 → Final warning message if checklist not completed Final message at 19:00: “⚠️ You have NOT completed the mandatory vehicle checklist. Please complete it immediately.” The system must check status before sending each reminder. 9. Excel tracking (auto-filled by system) Sheet: WEEKLY_CONTROL Rows = vehicles (plate + driver + phone) Columns = ISO weeks (2026-W05, 2026-W06, etc.) Each cell: ✅ Green = checklist completed ❌ Red = not completed Optional: Cell contains a link to the checklist folder or PDF ⚠️ Yellow if completed with issues This sheet is updated automatically when a checklist status changes. 10. Completion rules A checklist is marked as COMPLETED only when: Questionnaire is fully answered Notes field completed if required All required photos are received and validated PDF is generated successfully Otherwise, status remains PENDING and reminders continue. 11. Technical notes WhatsApp Business API (or provider) Webhook-based message handling State machine per checklist Configurable reminder times Cloud storage (Drive / OneDrive / S3) Excel update via API (Google Sheets or Microsoft Graph)
Project ID: 40210866
65 proposals
Remote project
Active 7 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
65 freelancers are bidding on average €136 EUR for this job

Hi I can build this WhatsApp only weekly vehicle checklist as a reliable state based workflow with automated Friday reminders photo rules by vehicle type cloud storage naming PDF generation and Excel tracking updates. I focus on automation systems where completion rules and enforcement are strict and the process must resume exactly where the user stopped. I will implement a webhook driven WhatsApp flow where each driver is identified by phone number and each checklist runs as a state machine tied to the vehicle plate and ISO week. The system will ask the questionnaire step by step enforce required notes when any item is not OK then request the mandatory photo set with validation and guided prompts so drivers upload the correct angles. Media will be saved into the exact folder structure with system generated filenames and the final PDF will be created only when all requirements are met. Reminders will run on a schedule and will always check status before sending. Excel tracking will update automatically to green red or yellow and can include a link to the folder or PDF. The solution will be built modular so storage provider and Excel target can be swapped between Drive OneDrive or S3 and Google Sheets or Microsoft Graph. Best, Justin
€140 EUR in 7 days
6.6
6.6

Hello, I will develop your MOBILE APPLICATION for Android and IOS both platforms with Web admin panel. I am Tulsiram. I have 10 years of experience working as Native and Crossplatform mobile application developer. I am understood your requirements. I am glad if we are working together. If you interested then let's connect. I will provide you Daily updates ,source code after development completed, 1 Year maintenance Support in following Steps: I will available daily 10-12 hours in Working days for you. I will provide you regular updates according to which modules we will decided. After approval each module by you then i will provide your complete source code of your project and will shift on your Domain. Thanks
€120 EUR in 15 days
6.5
6.5

Hi, there, As an experienced freelance engineer with expertise in data management, automation, and mobile app development, I am excited to propose a solution for the development of the WhatsApp Weekly Vehicle Checklist system. Leveraging my skills in database management and technical documentation, I am confident in delivering a tailored solution for your project. ✅ To initiate the project, I will configure a state-based system with automated reminders and photo validation, ensuring seamless checklist completion on WhatsApp for drivers every Friday. ✅ Implementing a robust algorithm, I will automate the workflow based on the provided Excel data, assigning tasks to drivers, and monitoring checklist progress. ✅ The system will validate each checklist entry and enforce completion rules, ensuring all mandatory fields and photos are submitted for successful checklist generation. ✅ Utilizing cloud storage, I will create a structured folder system for storing checklist data, including vehicle details, questionnaire responses, and validated photos. ✅ Implementing a customizable reminder system, I will set up scheduled reminders on Friday to prompt drivers for checklist completion, ensuring compliance and timely submission. I look forward to working with you. Best Regards. Brayan
€200 EUR in 3 days
6.0
6.0

Hello, I am really excited about the opportunity to collaborate with you on this project! It aligns perfectly with my skill set and experience, and I’m confident I can contribute meaningfully to your vision. I genuinely enjoy working on projects like this, and I believe we can create something both functional and visually engaging. Please feel free to check out my profile to learn more about my past work and client feedback. I’d love to connect and discuss the project details further your goals, expectations, and any specific features or ideas you have in mind. The more I understand your vision, the better I can bring it to life. I am ready to get started right away and will put my full energy and focus into delivering quality results on time. My goal is not just to complete the project, but to exceed your expectations and build a long-term working relationship. Looking forward to hearing from you soon! With regards! Nikhil
€250 EUR in 7 days
6.3
6.3

Hi There!!! ⚜⭐⭐⭐⭐⚜(( DEVELOP A MANDATORY WEEKLY VEHICLE CHECKLIST SYSTEM OPERATED VIA WHATSAPP ))⚜⭐⭐⭐⭐⚜ This project requires a comprehensive WhatsApp-based system that manages weekly vehicle checklists, with automated reminders and photo validation. The checklist must be completed by drivers every Friday, and the system should only mark the task as complete once all fields are filled, and photos are uploaded and validated. I specialize in developing automated workflows, integrations with WhatsApp Business API, and Excel data tracking, making this project a perfect fit for my skills. Here’s my plan for your project: * Automate the WhatsApp checklist flow with reminders and status checks * Integrate with cloud storage for photo and data management * Auto-fill Excel tracking for vehicle checklist completion Let’s get started on building this streamlined process! Warm Regards, Farhin B.
€110 EUR in 10 days
6.5
6.5

As a seasoned and highly-skilled FULL STACK SOFTWARE ENGINEER with over 12 years of experience in web and mobile app development, I possess the expertise you require for this WhatsApp weekly vehicle checklist project. I am intimately familiar with all the technologies involved, including Excel, API Development, and even AWS, which is key to implementing the cloud storage structure. I'm confident that my proficiency in PHP, Python (including Django framework), and many others aligns perfectly with the needs of this project. Your project's scope demands intricate coordination between different systems such as WhatsApp messaging, automated reminders, photo validation, cloud storage structuring and Excel tracking - bordered by strict timelines. Fortunately, as someone who has developed numerous applications handling large volumes of data while incorporating similar functionalities like this checklist system, I am well-equipped to handle these complexities deftly. Moreover, I understand the vision behind your project: enhancing accountability and compliance through streamlined processes is something I deeply value, appreciate and strive to embody in my work. Additionally, in regards to your schedule and enforcement priorities - my commitment to meeting deadlines is unparalleled. While designing the weekly reminder schedule that respects different time zones will require careful thought, it aligns with my software design ethos - usability first and foremost above complexity.
€100 EUR in 7 days
5.7
5.7

✋ Hi There!!! ✋ The Goal of the project:- Build a fully automated WhatsApp based weekly vehicle checklist system with reminders, photo validation, cloud storage, PDF generation, and Excel tracking to enforce mandatory compliance every Friday. I have carefully reviewed the full specification including the Excel driven vehicle master, WhatsApp state based checklist flow, conditional questionnaire logic, vehicle specific photo rules, automated reminders, cloud folder structure, PDF generation, and weekly Excel status updates, and I understand that completion is strictly validated only when all steps are fulfilled. I am the right fit because I have hands on experience building WhatsApp API driven automation systems with strict validation and reporting requirements. • WhatsApp Business API integration with webhook based state machine and reminder enforcement • Automated cloud storage, photo validation, PDF generation, and structured folder management • Excel or Google Sheets auto update with status colors and links I will provide clean UI flow design within WhatsApp, secure database management, full testing, automation setup, and full source code delivery at project completion. I bring 9+ years experience as a full stack developer and have already completed similar WhatsApp workflow automation, fleet compliance tracking, and document generation systems for logistics and operations teams. Looking forward to chat with you for make a deal Best Regards Elisha Mariam!
€111 EUR in 11 days
5.5
5.5

Timeline: 10 days | Cost:€700 | Proven experience Hello . I’ve solved this exact problem before and can deliver a WhatsApp-based weekly vehicle checklist system with automated reminders, photo validation, and cloud storage in 14 days. Based on my past experience, the real challenge is not sending messages, just ensuring the state machine correctly tracks each driver’s progress and enforces all photo and questionnaire rules. On a similar project, careful state handling and automatic PDF generation prevented incomplete submissions and streamlined reporting. To proceed, I only need your Excel VEHICLES_MASTER file, preferred cloud storage setup, and WhatsApp Business API credentials. This is a straightforward project for me, and I’m confident in delivering a fully automated, compliant, and trackable vehicle checklist system. Happy to go into more detail in the chat.
€700 EUR in 10 days
5.6
5.6

Hi, I am a full-stack developer with 8 years of experience building automation systems and workflow-driven applications that rely on messaging platforms, state-based logic, and strict completion rules. I’ve delivered systems where data validation, reminders, and audit-ready outputs are critical to daily operations. I am familiar with WhatsApp Business API integrations, webhook-based message handling, state-machine workflow design, automation scheduling, cloud storage structuring, PDF generation, Excel and Google Sheets API updates, backend validation logic, database-driven status tracking, and API-based system integrations. For this project, I would implement a WhatsApp-driven state machine that guides drivers through the checklist, validates all mandatory answers and vehicle-type photo rules, enforces timed reminders until completion, generates the final PDF automatically, stores assets in the defined folder structure, and updates the weekly Excel control sheet in real time based on checklist status. I'm an individual freelancer and can work on any time zone you want. Please contact me with the best time for you to have a quick chat. Looking forward to discussing more details. Thanks. Emile.
€30 EUR in 7 days
5.3
5.3

Hi there, Your project to build a WhatsApp-driven weekly vehicle checklist with automated reminders, photo validation, cloud storage, and Excel tracking is exactly the kind of challenge I excel at. With solid experience in WhatsApp Business API integrations, stateful workflows, and automated document generation, I’m confident I can deliver a robust, user-friendly system that ensures checklist completion, enforces reminders, and syncs perfectly with your Excel data. I fully understand the importance of validating photos and questionnaire fields before marking tasks complete and can implement the cloud folder structure and PDF generation as specified. Looking forward for your positive response in the chatbox. Best Regards, Arbaz T
€180 EUR in 7 days
5.3
5.3

Hi, I can develop your fully automated WhatsApp vehicle checklist system with state-based flow, mandatory photo validation, timed reminders, automatic PDF generation, structured cloud storage, and real-time Excel tracking via API—ensuring strict completion rules and reliable deployment. Best regards, Shakila Naz
€150 EUR in 7 days
5.1
5.1

Hello, I hope this message finds you well. I understand that you are looking to develop a comprehensive vehicle checklist system that operates via WhatsApp, including automated reminders, photo validation, cloud storage, and Excel tracking. With over five years of experience in building automated systems and integrating messaging platforms like WhatsApp, I am well-equipped to deliver this project. My expertise in using APIs, webhooks, and cloud storage solutions will ensure seamless functionality and reliability. To successfully complete your project, I propose the following approach: - Develop a state machine to manage the weekly checklist process, ensuring it resumes where drivers left off. - Implement automated WhatsApp messaging for reminders and checklist completion, tailored to your specified schedules. - Set up a robust validation system for photos and questionnaire responses, ensuring all criteria are met before marking a checklist as complete. - Create a cloud storage system that organizes checklist documents and photos in the required directory structure for easy access. I am eager to start this project and confident in my ability to deliver high-quality results on time. I would welcome the opportunity to discuss your project further and clarify any details. Please let me know a convenient time for you. Thank you for considering my proposal.
€140 EUR in 7 days
4.8
4.8

Hello, I’m excited about the opportunity to contribute to your WhatsApp-based weekly vehicle checklist system. With strong experience building WhatsApp-driven, webhook/state-machine automations and integrating cloud storage plus Excel tracking (via Microsoft Graph or Google Sheets API), I can deliver a robust flow that enforces completion exactly as you described—questionnaire + conditional notes + mandatory photo set by vehicle type + validated storage + PDF generation—before a checklist is ever marked complete. I’ll implement the Friday scheduler and reminder enforcement (08:00/13:00/17:00/19:00) with status checks before every message, keep each checklist as a resumable state machine per vehicle/ISO week, and auto-generate the required folder structure, photo naming, and checklist PDF with links to stored photos. The WEEKLY_CONTROL sheet will be updated automatically on every status change (✅ green, ❌ red, ⚠️ yellow for issues) with optional links to the PDF/folder, while VEHICLES_MASTER remains the source of truth for assignments and rules. You can expect clean, documented code, reproducible configuration (reminder times, storage provider, Excel target), and a reliable system that prevents “partial” submissions from slipping through. Best regards, Juan
€140 EUR in 1 day
5.0
5.0

⭐Hello [ClientFirstName], I’m ready to assist you right away!⭐ I believe I’d be a great fit for your project since I have extensive experience in technical documentation, data management, automation, mobile app development, web development, API development, software development, Excel, database management, and data extraction. I am thrilled by the challenge of developing a mandatory weekly vehicle checklist system fully operated via WhatsApp, with automated reminders, photo validation, cloud storage, and Excel tracking. This project aligns perfectly with my expertise and skills, ensuring a seamless and efficient implementation. I am confident in meeting your timelines and budget requirements, delivering high-quality results that meet your expectations. If you have any questions, would like to discuss the project in more detail, or would like to know how I can help, we can schedule a meeting. Thank you. Maxim
€30 EUR in 6 days
4.4
4.4

Dedicated Freelancer Ready to Elevate Your Project for WhatsApp Weekly Vehicle Checklist – Developer Specification. I have a solid background in Automation, API Development, Software Development, Mobile App Development, Web Development, Excel, Data Management, Technical Documentation, Data Extraction and Database Management, I bring valuable expertise to your project. I have successfully completed many projects with 100% client satisfaction. Clear and timely communication is my priority. I believe in keeping you informed throughout the project lifecycle. I am available for a discussion at your earliest convenience. Please feel free to contact me to further discuss your project details. Thank you for considering my bid. I am excited about the opportunity to contribute to the success of your project. Please visit my portfolio to check my previous work samples, here - https://www.freelancer.com/u/GraphicsHub2k24?page=portfolio&w=f&ngsw-bypass= Best regards, Muhammad Asim Khan
€30 EUR in 1 day
4.4
4.4

Hello, how are you? I am a senior full stack developer with over 10 years experience. I am confident that I can successfully complete your project. Wish to work for you. let's discuss more detail in the chat. Thanks.
€140 EUR in 7 days
4.5
4.5

With over 9 years of experience in web and mobile development, my team and I have the technical prowess and understanding necessary to tackle the intricacies of your WhatsApp Weekly Vehicle Checklist project. We possess a strong background in Java, PHP,.NET, HTML/HTML5/CSS and have sound knowledge about different platforms including Android and iOS. Our expertise extends to cloud-based projects as well which aligns perfectly with your project requirements. Moreover, my fluency in using Excel for data management and processing complements the need of extensive tracking and reporting required for this project. By choosing us, you will be getting a combination of quality, efficiency and cost-effectiveness. With us, you can be assured of a system designed according to your exact specifications that would not only automate the checklist process but also track its status through reminders at precise timings, perform photo validation, store them systematically on cloud and generate an automated report as ready-to-use PDFs. To top it all off, we offer free after-support of 3 months which means we will be readily available should there be any query or issue after project completion. Our commitment to client satisfaction has garnered us strong relationships with several clients who would vouch for our expertise and dedication. Choose us to transform your idea into a reality! Thank you for considering our bid.
€140 EUR in 7 days
5.2
5.2

Hi there. This works when each driver has a resumeable WhatsApp state flow tied to one vehicle and one ISO week, with strict completion gates for answers, required photos, and PDF generation. Pitfalls are duplicate webhook events, missing or wrong photo counts by vehicle type, timezone mistakes for Friday reminders, ISO week rollover edge cases, cloud folder naming drift, and Excel update conflicts. First I will ingest your VEHICLES_MASTER file into a small database, then build the checklist state machine with webhook handlers plus validation rules and a scheduler that checks status before each reminder, then generate the PDF and upload photos with system filenames into the required folder structure and update WEEKLY_CONTROL on every status change. Which WhatsApp provider will you use and do you already have a verified WhatsApp Business API number and templates approved? Should the tracking sheet be Google Sheets or Microsoft Excel on OneDrive, and which cloud storage do you prefer for folders and PDFs? I have built WhatsApp automation flows with state machines, media capture validation, scheduled reminders, PDF generation, and Sheets Graph updates with idempotency and audit logs. I can start today, get one vehicle end to end running fast, then scale to all vehicles and hand you a clear readme. Danylo Podolskyi
€140 EUR in 7 days
4.5
4.5

Hi there, I’ve read your WhatsApp Weekly Vehicle Checklist spec and I’m confident I can deliver a robust, automated solution that runs on the WhatsApp Business API with stateful checklists, photo validation, and seamless Excel tracking. I have deep experience in building end-to-end automation pipelines, API-driven workflows, and cloud storage integrations that ensure data integrity and timely reminders for drivers. What you’ll get: a state-machine driven flow that creates a weekly checklist every Friday at 08:00, automated reminders at 13:00, 17:00, and 19:00 if incomplete, and a strict validation that all questionnaire fields and required photos are completed before marking a checklist COMPLETED. Photos are organized in a deterministic cloud folder structure and a generated PDF includes all metadata, answers, and links to photos. The WEEKLY_CONTROL sheet automatically reflects status with color codes and optional links. Next steps: I can sketch the data mapping from VEHICLES_MASTER to the WhatsApp flow, outline the API endpoints for photo validation and PDF generation, and deliver a working prototype within a short 1-2 week sprint after I review the Excel schema in detail. Best regards,
€100 EUR in 2 days
4.0
4.0

Hi there, I'm Kristopher Kramer from McKinney, Texas. I’ve worked on similar projects before, and as a senior full-stack and AI engineer, I have the proven experience needed to deliver this successfully, so I have strong experience in Excel, Software Development, Mobile App Development, Web Development, Database Management, Automation, API Development, Data Management, Technical Documentation and Data Extraction. I’m available to start right away and happy to discuss the project details anytime. Looking forward to speaking with you soon. Best regards, Kristopher Kramer
€120 EUR in 3 days
4.8
4.8

La Ràpita, Spain
Payment method verified
Member since Feb 4, 2026
€250-750 EUR
€250-750 EUR
€30-250 EUR
₹12500-37500 INR
₹600-1500 INR
£1500-3000 GBP
₹1500-12500 INR
$250-750 USD
₹1500-12500 INR
₹600-1500 INR
$30-250 USD
€12-18 EUR / hour
₹100-400 INR / hour
$10-30 USD
₹600-1500 INR
$10-30 USD
₹12500-37500 INR
₹600-900 INR
$250-750 USD
$2-8 USD / hour
$15-25 USD / hour
$30-250 USD
₹600-1500 INR