Integrate Google Spreadsheet with Google Maps

The Google Maps integration enables SiteTrax.io users to visualize their asset data using Google My Maps. By following simple steps, users can import their SiteTrax.io Google Spreadsheet into Google My Maps to view and interact with asset locations based on GPS coordinates.

Prerequisites:

1. You have signed up for SiteTrax.io at the SiteTrax.io Intelligence (https://app.sitetrax.io)
2. You have scanned at least one asset with any camera
3. At least one asset is inside of a Google Spreadsheet (automatically pushed from SiteTrax.io).

Steps for Integration:

1. Open Your Data: Access your SiteTrax.io Google Spreadsheet
2. Open Google My Maps: Log into your Google Account to open Google My Maps (link here).
   
3. Create a New Map: Click the "Create a New Map" button in Google My Maps.
4. Import Data: Use the "Import" option to select your SiteTrax.io Google Spreadsheet from Google Drive.
5. Assign Coordinates: Map the latitude (gps_lat) and longitude (gps_lon) columns from your data to position asset markers.
6. Title the Markers: Select the "Text" column to title your asset markers.
7. View Data: You can now view and interact with your assets on the map, including searching for specific assets.

Data freshness and interpretation

Google My Maps displays the observations included in the most recent import. New rows arriving in the source spreadsheet do not automatically refresh an existing map. Reimport the data to show later observations and check their timestamps. A plotted location is where an asset was observed; it does not establish the asset’s current position or continuous presence.

For other Google connection options and their implementation status, see the Google section.