Track attendance and location of user in a Google Sheet

[SteveJG]

Welcome.

Here is an example that shows part of what you desire using a CloudDB (or perhaps FirebaseDB) rather than a GoogleSheet that you might find useful:

Social Distancing ... a CloudDB / Location Marker Tutorial

Social Distancing ... a CloudDB / Location Marker Tutorial The Project Determine how close an individual you share an app with is to you. You use a CloudDB, LocationSensor/GPS receiver, Map component, design time Markers and a StayAwake routine. Sound an alarm when someone comes too close or just have fun with the app to keep track of your family circle's whereabouts. Observe where everyone is on a Map. The app continually updates and calculates distance separation. The Social Distancing s…

Here is another that does something similar and uses a passcode How to broadcast a GPS location and share the information on a map with others in real time..CloudDB