Google Sheet API Script
Budget: $10 – $30 USD
Google Sheet Script
I need an API connection to update a Google sheet row using preset parameters and POST requests.
There are two dynamic parameters, Origin ZIpcode, and Destination Zipcode, and based on those parameters the API will be called and update the column with the miles, hours, and toll cost.
For this project we will use Trimble Maps, here is the endpoint documentation and there are post-request examples, attached is the Google sheet screenshot from the required data.
NO EXISTING ADDONS, NEEDS CUSTOM SCRIPT.
https://developer.trimblemaps.com/restful-apis/routing/route-reports/post-route-reports/
I need an API connection to update a Google sheet row using preset parameters and POST requests.
There are two dynamic parameters, Origin ZIpcode, and Destination Zipcode, and based on those parameters the API will be called and update the column with the miles, hours, and toll cost.
For this project we will use Trimble Maps, here is the endpoint documentation and there are post-request examples, attached is the Google sheet screenshot from the required data.
NO EXISTING ADDONS, NEEDS CUSTOM SCRIPT.
https://developer.trimblemaps.com/restful-apis/routing/route-reports/post-route-reports/