Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
feeding SmartSheet data to Google Earth
Hi, I'd like to take survey data entered into rows of SS and output it to Google Earth. Obviously I can do this with exports from SS and imports into GE, but I'd like to be realtime. Is this even possible? Is anyone doing something similar?
Comments
-
Brett - a couple of options, depending on what exactly you are looking to accomplish.
(1) if you haven't already, take a look at our maps app in smartsheet labs https://smartsheetlabs.com/smartsheetmaps. create a new map, point to your sheet and save. as you add rows to your sheet and reload your browser map view, it will map the new entries
(2) you can roll your own. unfortunately, it looks like the google earth api is in the process of being shut down https://developers.google.com/earth/documentation, but you can use the Smartsheet API http://smartsheet.com/developers/api-documentation and a third-party product like google maps or bing maps to create any sort of visualization you want
Cheers
-
Thanks Alex! The smartsheet maps could work for our application, at least to start. It appears that the map wants an address. Is there any way to feed it GPS coordinates? That would be incredibly helpful
-
Brett,
We use this process. It is a real time process. We use it for our delivery drivers. As we enter data into the sheet and it is lined out with the Smartsheet Labs it provides a google map for our drivers that is real time.
-
Brett - absolutely. Just put your coordinates into a single column, and have your Maps App configuration refer to a single address column (as opposed to multiple columns). Here is an example of a column with coordinates:
-
This would be huge for us in our business process as well.
Dashboard is great... Dashboard with an embedded Map is huge for us.
-
Hi Todd,
What type of map you use in the dashboard? Google Maps, I suppose, but do you use any api to make marks on it? I tried to import google maps nut it's empty, so it's just a map.
If I would be able to bring address pins, wow! that could be fantastic!
-
Hi Jeremy,
I know that your post is quite old now, but could you please let me know how do you use smartsheet labs to create google maps for drivers?
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 34 Webinars
- 7.3K Forum Archives