[mikeeje]

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!

[Advertisements]

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.

[dsenette]

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.

[nikitanewton]

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.

[cls357]

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:

 

https://www.emailpar...rite-excel-file

 

Once you have all the data in the Excel file you can generate a map. There is a video of a guy doing that:

 

[JamesThomason]

There are a lot of email parsers on the interenet. You can use, for example, https://parserr.com/. It works without any problems with excel and google sheet.

 

Edited by JamesThomason, 01 November 2018 - 05:04 PM.

[JamesThomason]

If you need more information about the parser, look at the knowledge base: https://parserr.com/support/knowledge-base/email-to-salesforce/