
Closed
Posted
Tlemcen Pharm Logistique Internal logistics & business intelligence platform for a pharmaceutical distribution company Tlemcen Pharm Logistique is a custom-built operations platform designed to digitize and automate the daily logistics workflow of a pharmacy delivery network. Built on Google Apps Script with Google Sheets as the backend database, it gives management, HR, and field drivers a role-based interface tailored to their needs. Key features: Executive dashboard — real-time KPIs (revenue, volume, mileage, profitability score) with historical trends, sector rankings, and one-click PDF report generation (management, commercial, sector, and delegate reports) Interactive GPS mapping — visualizes all client pharmacies by sector, with a built-in prospecting radar that scans OpenStreetMap data to surface potential new clients not yet in the client base Route optimization — calculates the shortest delivery route per sector using the OSRM routing engine, with a live checklist of active clients for the day Fleet & workforce management — daily driver attendance tracking, automatic mission-fee calculation by sector, vehicle assignment, and 15-day automated scheduling with configurable driver rotation rules QR-code check-in system — drivers scan a personal badge, a vehicle tag, and a sector QR code to log attendance, sector assignment, and mission fees automatically — no manual data entry required Excel/PDF exports — one-click generation of payroll-ready reports (driver fees, vehicle usage logs, HR summaries) using SheetJS Tech stack: Google Apps Script (backend), Google Sheets (database), [login to view URL] & OpenStreetMap (mapping), [login to view URL] (analytics), OSRM API (route optimization), SheetJS (Excel export), [login to view URL] (PDF reports), Bootstrap 5.
Project ID: 40595495
112 proposals
Remote project
Active 1 day ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
112 freelancers are bidding on average $19 USD/hour for this job

Hi there, I understand that you are looking to automate the logistics workflow of Tlemcen Pharm Logistique and enhance it with business intelligence capabilities. To achieve this, I suggest developing a robust platform that integrates business intelligence and logistics features seamlessly. I will employ PHP for server-side scripting, ensuring efficient data management. MySQL will be used for database management to handle large volumes of logistics data. JavaScript will play a crucial role in providing an interactive and user-friendly interface. Moreover, I will integrate Google Sheets to facilitate real-time data access and business intelligence analytics. Utilizing data visualization techniques, the platform will provide actionable insights to optimize logistics operations and enhance decision-making. With my extensive experience in developing software architectures tailored for logistical operations, I am confident that I can create a solution that aligns well with your business needs. Best Regards, Khorshed Alam, RS Software
$20 USD in 40 days
9.5
9.5

Hi, I will deliver your Tlemcen Pharm Logistique platform: role-based dashboards, QR code check-in for drivers, and OSRM route optimization, all running on Apps Script with Google Sheets as the backend. On a similar logistics build, automating attendance via QR badges eliminated manual entry errors entirely for the field team. Questions: 1) How many sectors and drivers will the scheduling rotation need to support at launch? 2) Are the Google Sheets already structured, or do those need to be designed as well? Share your current Sheets setup and I will map the data model this week. Ready to start whenever you are. Kamran
$19 USD in 40 days
8.6
8.6

Hi, To create the internal logistics and business intelligence platform for Tlemcen Pharm Logistique, I will leverage Google Apps Script for backend development, utilizing Google Sheets as the database. The platform will feature an executive dashboard for real-time KPIs, interactive GPS mapping for client visualization, and route optimization using the OSRM routing engine. I will ensure that the fleet and workforce management functionalities are robust, including daily driver attendance tracking and automated scheduling. The QR-code check-in system will streamline attendance logging, while the Excel/PDF export capabilities will facilitate payroll-ready report generation. Happy to discuss the details.
$20 USD in 40 days
8.4
8.4

Hi, Building an internal logistics platform for pharmaceutical operations requires more than automation. It needs to be reliable, easy to use, and capable of handling real-time data while streamlining daily workflows for management and field staff. I understand you're looking to develop and enhance a Google Apps Script-based logistics and business intelligence platform with dashboards, GPS mapping, route optimization, workforce management, QR-based check-ins, and automated reporting. I'll focus on building a scalable, well-structured solution that is easy to maintain while ensuring every workflow is efficient, accurate, and responsive. A few quick questions: Is this a new platform from scratch, or are you looking to enhance an existing system? Will Google Sheets remain the long-term database, or are you considering migrating to a dedicated database in the future? Are there any third-party systems or APIs that also need to be integrated? I'd be happy to share relevant automation, dashboard, and Google Apps Script projects during our discussion. Kindly initiate a chat so we can discuss your project in more detail. Best regards,
$20 USD in 40 days
7.9
7.9

Hello, will the current Google Apps Script solution remain the core platform, or are you planning to migrate any modules to PHP/MySQL? How is user authentication and role-based access currently managed, and should the OSRM routing and OpenStreetMap integrations continue as they are? My approach is to review the existing architecture, optimize the workflow, improve integrations, implement the required enhancements, thoroughly test every module, and ensure smooth deployment. P.S: My current bid is a placeholder bid, cost and scope will be finalized after discussion. Thank you, Muhammad Abrar Portfolio will be shared via chat.
$25 USD in 40 days
7.7
7.7

Bonjour, J'ai bien étudié le projet Tlemcen Pharm Logistique et je comprends qu'il s'agit d'une plateforme interne de logistique et de business intelligence basée sur Google Apps Script et Google Sheets, avec des modules de cartographie, d'optimisation de tournées, de gestion RH et de reporting automatisé. J'ai plus de 13 expériences dans Google Apps Script, l'automatisation des flux de travail, Google Sheets avec une base de données, l'intégration d'API, les opérations BI, la cartographie Leaflet/OpenStreetMap, la génération PDF/Excel et les applications de gestion logistique. Je peux intervenir sur l’architecture existante, l’optimisation des performances Apps Script, la sécurisation des accès, la fiabilisation des exports, l’amélioration des tableaux de bord, les intégrations OSRM/OSM et les workflows QR pour réduire les erreurs de terrain. Je peux également renforcer la structure du code, la gestion des rôles, les scripts de synchronisation, les règles de rotation des chauffeurs et les rapports automatisés afin de rendre la plateforme plus maintenable et évolutive pour une exploitation quotidienne. Je vous offre 2 ans de support continu gratuit et l'accès à l'intégralité du code source. Je suis disponible à votre bureau selon votre fuseau horaire et je travaillerai sur votre projet jusqu'à votre entière satisfaction. Merci, Christina
$15 USD in 40 days
7.4
7.4

Hello, I am very interested in the Tlemcen Pharm Logistique project as it aligns perfectly with my expertise in MySQL, PHP, JavaScript, and Software Architecture. I have a deep understanding of the project requirements, specifically the development of an internal logistics and business intelligence platform for a pharmaceutical distribution company using Google Apps Script and Google Sheets as the backend database. My approach will involve creating an executive dashboard for real-time KPI tracking, implementing interactive GPS mapping for visualizing client pharmacies, optimizing delivery routes using the OSRM routing engine, managing fleet and workforce efficiently, and integrating a QR-code check-in system for automated attendance and mission fee tracking. - MY WORK STATS: ✨ https://www.freelancer.com/u/XanvraTECH I look forward to discussing this project further with you to explore how I can contribute to the success of Tlemcen Pharm Logistique. Best regards, Warda Haider
$15 USD in 40 days
6.8
6.8

Hello, I have worked on logistics and reporting systems with role-based workflows, KPI dashboards, and export-ready business reports. Your platform needs careful handling of Google Sheets data, mapping, route planning, and Data Visualization similar to systems backed by PHP and MySQL. I can help refine the executive dashboard, GPS pharmacy map, OSRM route optimization, QR check-in flow, and Excel or PDF reports. I will keep the workflow simple for management, HR, and drivers while making the automation reliable for daily operations. Best regards, Teo
$20 USD in 20 days
6.8
6.8

Hi, I'm interested in your project "Tlemcen Pharm Logistique Automation". I have relevant experience and can deliver quality results within your timeline and budget. I'd love to discuss the details. Please feel free to reach out.
$20 USD in 40 days
6.7
6.7

This sounds like a solid system that really ties together complex logistics into one smooth workflow. I’ve helped a pharma distributor set up similar Google Apps Script automation for their delivery tracking and driver scheduling, so I know how to streamline data flows and tighten real-time updates without adding manual overhead. One quick question: Is the current OSRM routing working well with your delivery density, or do you face occasional route calculation delays? Sometimes caching routes per sector can speed things up sharply. Also, for the GPS mapping, would adding live vehicle tracking be useful down the line, or are static client maps enough? I’d start by reviewing the current script and database design to eliminate bottlenecks and then add tweaks to boost responsiveness, especially in report generation and QR code scanning. From there, focusing on UX improvements for driver and manager interfaces can cut down on training and errors. Ready to dive in and get your operations smoother and reports delivering faster. Let’s get this platform running at full speed.
$15 USD in 7 days
6.1
6.1

Greetings, I understand the need for Tlemcen Pharm Logistique to streamline its internal logistics and business intelligence processes efficiently. With expertise in PHP, JavaScript, Software Architecture, and Google Sheets, I am well-equipped to deliver a tailored solution that aligns with your objectives. My approach involves structured requirement confirmation, controlled planning, clean implementation, rigorous testing, and milestone-based transparency to ensure a seamless project execution. By focusing on reliable implementation and long-term results, I aim to provide a solution that drives operational efficiency and enhances decision-making capabilities. You can review my portfolio here: ⭐⭐ https://www.freelancer.com/u/CodeAnchors ⭐⭐ To better understand your priorities, could you share the key business goal you aim to achieve through this platform? I invite you to initiate a chat to discuss the project scope further and finalize the details smoothly. Best regards, Muhammad Anas Khan
$25 USD in 40 days
5.7
5.7

Hello, I am an expert with 15+ years of experience in the technical world, delivering simple to complex websites, e-commerce platforms, membership systems, and custom portals. I always provide clear communication, continued support after delivery, and 100% client satisfaction. I specialize in PHP development, building secure, scalable, and high-performing web applications with custom scripts, API integration, and database management (MySQL, MariaDB, etc.). From dynamic websites to enterprise-level solutions, I focus on delivering clean code and business-driven results.
$15 USD in 40 days
5.6
5.6

As a seasoned freelancer with over two decades of experience in website development focused mainly on PHP, JavaScript, and MySQL, I believe I would be the ideal candidate to spearhead your project. Throughout my career, I have consistently demonstrated an acute ability to fix problems and identify unoptimized areas - which are essential for the logistical challenges you face. In addition to my technical skills, what sets me apart is not only my ability to understand complex requirements, but also to provide sustainable solutions that are in line with the long-term trajectory of a business like yours. This means you can count on me not just to automate your daily logistics workflow, but to ensure it remains stable and future-proof as your company continues to grow. Another aspect that differentiates me from others is my focus on forging strong relationships with my clients. Many of the businesses I've worked with have continued our collaboration because they recognize the value I bring in terms of reliability and consistency. If you're seeking a dependable and experienced hand who can grasp your needs quickly while providing consistent results, let's connect and discuss how I can assist you better.
$15 USD in 40 days
5.8
5.8

Good to see this project, We will build your logistics platform on Google Apps Script with Sheets as the backend: role-based dashboards, QR check-in, GPS mapping, and route optimization via OSRM. For the QR system, we will chain badge, vehicle, and sector scans into one atomic transaction. This eliminates partial entries and keeps attendance data clean. A couple of quick things to confirm: 1) How many drivers and sectors will the rotation scheduler need to handle? 2) Are the Google Sheets already structured, or do we start fresh? The number quoted here is a starting estimate. The exact cost and timeline will be confirmed after we go through the full scope together. Looking forward to talking through the details. Faizan
$19 USD in 40 days
5.3
5.3

Hey, I can build a platform like Tlemcen Pharm Logistique with a structured Google Apps Script backend, role-based dashboards, logistics automation, and interactive mapping while keeping the system fast, scalable, and easy to manage. You can review my work here: https://www.freelancer.com/u/mahads31 I'll develop the solution around Google Apps Script and Google Sheets, integrating mapping, route optimization, reporting, QR-based workflows, and analytics into a unified interface. The code will be modular so future enhancements, new reports, and operational rules can be added without disrupting existing functionality. One question: do you already have the Google Sheets database structure, or should I design it as part of the project? Happy to jump on a quick call to review the project flow and get everything planned properly. Best Regards, Mahad
$20 USD in 40 days
5.1
5.1

✋ Hi There!!! ✋ The Goal of the project:- BUILD AND AUTOMATE A ROLE-BASED LOGISTICS AND BUSINESS INTELLIGENCE PLATFORM FOR PHARMACEUTICAL DISTRIBUTION. I have carefully read the complete project description and understand the need for a Google Apps Script and Google Sheets based system connecting management, HR, and drivers. With 9+ years experience as a full stack developer, I am a strong fit for scalable logistics automation and data-driven workflows. 1. Real-time KPI dashboards and data visualization 2. GPS mapping, prospecting and route optimization 3. Fleet, workforce and automated scheduling management 4. QR check-in with automated attendance and mission fees 5. Excel and PDF reporting, testing and database management I have completed similar logistics, dashboard, mapping, automation and reporting projects using APIs and cloud-based systems, with clean source code and reliable workflows delivered at completion. Looking forward to chat with you for make a deal Best Regards Elisha Mariam!
$15 USD in 40 days
4.6
4.6

Hi, I’ve worked on custom business platforms with similar goals, where the focus was digitizing operations, automating workflows, and creating role-based dashboards for different teams. I understand this type of logistics system requires reliable data handling, clear reporting, and simple interfaces for daily users. A key challenge is connecting multiple workflows like fleet management, route planning, analytics, and reporting while keeping the system easy to use. I’d approach this with a structured architecture, automated processes, and optimized dashboards to provide accurate real-time insights. I can help develop and enhance systems like this by handling backend logic, database structures, dashboards, API integrations, automation workflows, exports, and user-focused interfaces. The result will be a scalable platform that improves efficiency and reduces manual work. Best Regards, Muhammad Saad K
$15 USD in 40 days
5.1
5.1

Hello, As both a seasoned backend developer and a specialist in systems architecture, I believe I have the necessary skills and experience to take on the Tlemcen Pharm Logistique project. Proficient in JavaScript with specific knowledge in Google Apps Script, coupled with expertise in leveraging databases such as MySQL, I am well-acquainted with building products that are reliable, scalable and high-performing. One of the strongest qualities that distinguishes me from other candidates is my focus on long-term technical reliability - something that seems particularly important to the success of your logistics platform at Tlemcen Pharm. Further, my specialisation in backend development coupled with a deep understanding of systems programming aligns perfectly with your needs for automating your operations workflow. Lastly, my clients choose to work with me repeatedly because of several reasons - that includes my clear communication and professional delivery style, strong track record in backend and architectural work, proven 5.0-rated performance in core technical skills, emphasis on long-term maintainability over quick fixes; and rest assured, these factors all come together to create a final product that is stable, fast and secure. I'm confident in saying choosing me will ensure your project gets the meticulous care it deserves! Thanks!
$20 USD in 21 days
4.5
4.5

⚠️ If you're not happy, you don’t pay. ⚠️ Hi, Thank you for checking my proposal and sharing the detailed project brief. I can build your internal logistics and business intelligence platform using Google Apps Script and Google Sheets with a scalable, high-end design. I will deliver: • Executive dashboard showcasing real-time KPIs and historical trends • Interactive GPS mapping with prospecting radar for new client discovery • Route optimization via OSRM for efficient delivery scheduling • Fleet and workforce management, including daily attendance and mission fee calculations • QR-code check-in system for seamless data entry and accuracy • One-click Excel/PDF exports for payroll-ready reporting You will also receive: • Comprehensive user documentation and ongoing support I am confident I can execute your vision professionally and efficiently. Looking forward to discussing timeline and next steps. Best regards, Chirag Pipal
$15 USD in 30 days
4.5
4.5

Hi, I'm interested in your project "Tlemcen Pharm Logistique Automation". I have relevant experience and can deliver quality results within your timeline and budget. I'd love to discuss the details. Please feel free to reach out.
$20 USD in 40 days
4.4
4.4

Tlemcen, Algeria
Member since Apr 28, 2026
₹600-1500 INR
$250-750 USD
$1500 USD
$250-750 USD
₹12500-37500 INR
$20-30 SGD / hour
$30-250 USD
$8-15 USD / hour
$25-50 USD / hour
$2-8 USD / hour
$30-250 USD
₹12500-37500 INR
$15-25 USD / hour
₹12500-37500 INR
₹750-1250 INR / hour
₹7500-15000 INR
$30-250 USD
$30-250 AUD
₹600-1500 INR
$12-15 USD / hour