Google Script for API access

I need your help with Google Scripting. My car has a datalogger that I can access via a web interface, but the interface has authentication (user/pw). I tried to create a Google Script to 'login' into the page but alas it is not my specialty, i think part of my issue is that the login redirected to another internal page. I want to access this site and access the API : [login to view URL]

Then, I want the data to be copied into a Google Drive spreadsheet (probably using the IMPORTHTML function?) and have it refresh every 15 minutes. I will then run an IFTTT task based on the value of some parameters.

Can you help? Below is the info if you want to take a look at how to do it:

Site : [login to view URL]

user/PW will be shared, msg me.


Below is an example of the data that is in the API:


"fleetName": "Charge the North - Eastern",

"fleetId": 624,

"vehicles": [


"reportId": "5040eef1-d2b5-45c3-991f-9bf1dda7dee9",

"lastDataUpdate": "2019-03-22T14:06:36Z",

"speed": null,

"maf": null,

"fuelRate": null,

"soc": 86.5,

"chargerPower": null,

"outsideTemperature": null,

"batteryPower": null,

"batteryVoltage": null,

"batteryCurrent": null,

"batteryTemperatureC": null,

"rpm": null,

"isCharging": false,

"isDriving": false,

"lastLocationUpdate": "2019-03-22T14:05:40.6Z",

"latitude": 45.573320555555554,

"longitude": -73.767056666666662,

"altitude": null,

"vehicleId": 106483,

"model": "e-Golf",

"make": "Volkswagen",

"year": 2018,

"vin": "WVWPR7AU1JW907496",

"licensePlate": null,

"unitId": null,

"identifier": "WVWPR7AU1JW907496",

"identifierWithModel": "WVWPR7AU1JW907496, (2018 Volkswagen e-Golf)",

"yearMakeModel": "2018 Volkswagen e-Golf"




Skills: Software Architecture

See more: google map api vba access, google maps api access, script google map api php, google sheets script editor, google sheets api, google apps script oauth2, google apps script execution api, google sheets script, google apps script rest api, google apps script json example, google apps script http request, google maps api script, google maps api script distance, google maps api ready script buy, professionell google maps api script, google map api access database, google maps api script generator marker, microsoft access visual basic google apps api, google maps api script php asp, google maps api access database

About the Employer:
( 0 reviews ) L'Ile-Bizard, Canada

Project ID: #19026545

2 freelancers are bidding on average $111 for this job


Hi there, Greetings! I am expert of Google scripts and have 5 years of experience init. Can we discuss in details. Regards Rahul

$111 CAD in 3 days
(2 Reviews)

i have 2 years of experience of app script in upwork. it's my first bid in freelancer.

$111 CAD in 3 days
(0 Reviews)