# Gps coordinates to link to google sheet

**URL:** https://community.glideapps.com/t/gps-coordinates-to-link-to-google-sheet/57433
**Category:** Ask for Help
**Created:** [February 2, 2023, 11:18pm UTC](https://community.glideapps.com/t/gps-coordinates-to-link-to-google-sheet/57433 "2023-02-02T23:18:58Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![AmiJoule](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/amijoule/32/53709_2.png) [@AmiJoule](https://community.glideapps.com/u/AmiJoule)
#### Post date: [February 2, 2023, 11:18pm UTC](https://community.glideapps.com/t/gps-coordinates-to-link-to-google-sheet/57433/1 "2023-02-02T23:18:58Z")

</div>

Hello everybody,  
i need to link user mobile location, to google sheet, later i should count how many people are in one area.  
How can I do?  
Thank you for your attention.

---

<div class="post-metadata">

### Author: ![glide](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/glide/32/53398_2.png) [@glide](https://community.glideapps.com/u/glide)
#### Post date: [February 2, 2023, 11:19pm UTC](https://community.glideapps.com/t/gps-coordinates-to-link-to-google-sheet/57433/2 "2023-02-02T23:19:05Z")

</div>

_This is an experimental reply from a bot. Please like it if it’s correct._

You can use the Location component to log the device’s current location and store it in a column in your project’s Data Source. You can then use the Distance to Location Computed Column to calculate the distance between two locations. This will allow you to track the user’s location and store it in your Google Sheet. For more information, please refer to the links below.

[Glide • Distance to Location](https://www.glideapps.com/docs/reference/computed-columns/distance-to-location)

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/6/a64c94ffc1dce2cfb5fcc22de39cc73a1b391e06.jpeg) [Glide • Location](https://www.glideapps.com/docs/reference/components/location)

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [February 3, 2023, 12:01am UTC](https://community.glideapps.com/t/gps-coordinates-to-link-to-google-sheet/57433/3 "2023-02-03T00:01:42Z")

</div>

Seems like it’s the same question you asked here. Please don’t create multiple duplicated posts. I will lock this one.

> [@Geofencing](https://community.glideapps.com/t/geofencing/57400):
>
> Hello everybody, I try to explain what I would like to do: I would like to count how many people are in an area I set. I thought that: 1) I should activate Geofencing, and set the position where I would like to count people, 2) when a person enters the area I set, he automatically writes an id and a number in a column, and when he leaves the zone should cancel and scale down the number. I would like some advice, has anyone tried something like this yet? Thank you for your attention.

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [February 3, 2023, 12:01am UTC](https://community.glideapps.com/t/gps-coordinates-to-link-to-google-sheet/57433/4 "2023-02-03T00:01:54Z")

</div>


