Hello. I get frequent updates from my employees by email that includes latitude and longitude coordinates. I am trying to figure out if there is a program/service that will automatically pull the lat/long from my email and plot it on a google map. I can probably figure out how to use google fusion to plot the coordinates to google maps, but I don't know how to have the coordinates automatically pulled from my email and put into a spreadsheet for google fusion. Or maybe there is a better way than a fusion table. I have a Windows computer at work and a Mac at home, so I can do it on either platform. I can use Exchange or Gmail. Thanks!
Posted 08 March 2016 - 08:13 AM
i don't know of any native ways to do it. but I do know there are some apps out there that can parse your email for specific formatted text. probably even easier if the email is always in the same format and always has the info you're looking for in the same place
https://mailparser.i...email-to-excel/ that's just a quick google search result. definitely not the only result.
http://www.slipstick...e-message-text/ here's a bit about using VBA in outlook. will take some combining with other scripts and such to get the data out into excel, but it seems to be able to do such a thing based on the comments. would likely benefit from having a SPECIFIC email address used JUST for the gps info.
Posted 16 April 2016 - 03:19 AM
If i am clear, you need to put all the e-mail list of your customer from the google to spreadsheet. A software can help you to Synchronize, i selected software which is integrated with google which can Synchronize Task, calendar, E-mail, notes all the details ( It gave me a complete solution).
Edited by nikitanewton, 16 April 2016 - 03:25 AM.
Posted 09 October 2017 - 10:47 AM
If you want an app to do that there is Email Parser. Here is an example that captures temperature reports from an email. It is not exacty latitude/longitude data but it may help:
Once you have all the data in the Excel file you can generate a map. There is a video of a guy doing that:
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users