US Film Equipment Rental Company GPS Vehicle Tracking Automation

This project delivers a streamlined Automated Data Lookup Solution designed to save 8 hours weekly in updating vehicle information. It integrates the Samsara Fleet Management Platform with Office 365 Hosted Excel, ensuring seamless synchronization of vehicle mileage and asset details by VIN number.

Key Features:

• Integration with Samsara API : Retrieves up-to-date mileage and tracking data for all vehicles in the fleet.

• Excel 365 Synchronization via Microsoft Graph API : Automatically updates hosted spreadsheets with accurate vehicle information in real-time.

• Automation Workflow with Make.com : Coordinates data retrieval, transformation, and synchronization tasks, ensuring a fully automated process.

Benefits:

• Eliminates manual data entry, reducing errors and freeing up administrative time.

• Provides accurate, real-time fleet data for reporting and operational decisions.

• Enhances productivity by automating repetitive data updates.

Platforms Used:

• Samsara Fleet Manager : For tracking vehicle metrics and mileage.

• Excel 365 : For storing and managing synchronized fleet data.

• Make.com : For creating and managing automated workflows.

This solution optimizes fleet management processes, leveraging robust APIs and automation to deliver efficiency and precision.