Live Remote Monitoring on field survery

The Goal

The client is starting to conduct her study, and one thing the client wanted is to track the progress of how many and where the respondents are. It's tedious to do it in manual GIS, constantly making new maps just to show here the progress of the field validation.

figure of the google spreadsheet during the client's on conducting field survey,

Since the data lived in the Google spreadsheet with coordinates, why not use it as an advantage? Luckily I have problem-solving skills in tech. How was it played out? The first thing is to fetch all the data using JavaScript and then locate the coordinates. The second is to add the coordinates to Leaflet. Lastly, deployed it for free using GitHub Pages.

"I can check the live updates of both the succeeding and failing surveys and track them. We're just using a phone, and it's updating live. -Client"