Hello there,
I understand your need for a custom script to connect to the Trimble Maps API and update a Google Sheet with data such as miles, hours, and toll cost, based on dynamic parameters like Origin and Destination Zipcodes. At TechView365, our expertise in MERN & MEAN Stack Development, Web Scraping, Backend Solutions, Java Development, and Spring Boot, aligns well with the skills required for API integrations and automation tasks.
For your project, you need a developer proficient in Java, JavaScript, and APIs, with experience in Google Sheets scripting. The developer should:
1. Understand the Trimble Maps API, particularly how to make POST requests and handle responses.
2. Be capable of writing a custom script in Google Sheets that dynamically updates rows based on the API's response.
3. Ensure the script efficiently handles the dynamic parameters (Origin and Destination Zipcodes) and updates the relevant columns in the sheet without the need for existing add-ons.
Given the project's requirements, it's important to select someone who can carefully integrate the API with Google Sheets, ensuring accuracy and reliability in the data update process.
Regards,
Manish,
TechView365 Team