- Help me kind I.T experts of STW
Start here: freelancer and ask the same question.
The answer will depend on whether the data is still in the emails or if you can export them. From a programming point of view it quite easy, more so from a set if files than using Google’s API unless you are already familiar with it. he answer will depeand on wheter the data is still in the emails or if you can export them.Posted 3 years agoRob HiltonMember
HTH, Rob –Posted 3 years ago
I.TGoogle expert 😉MackemMember
A quick thing to try….
Export the messages to a file. (a comma separated one (CSV))
Try importing the CSV into EXCEL – If you are very lucky the relevant info will be in the same postion all the time and you’ll be able to just select the columns you need.
You might have to do some formatting of the mail body, you can split based on position. If it’s a auto email the data should be in the same place and you can do it yourself.Posted 3 years agoallthepiesMember
If you had a tech friend to call upon then they could use Google scripting to read the gmails and interpret the contents.
Would be easy to do but you do need a tech 🙂Posted 3 years ago
My boss has asked me to do something and I’m hoping there’s an easy way to do it,
I work in a very basic guesthouse, and we receive online bookings from an online travel agent.
He’s asked me to go through these emails and write some information into an excel spreadsheet
Guest name, email address, room type, dates, country, etc.
There are over 800 of these emails, and they’re all automatically generated by the OTA, so all have the same layout/format
Is there anyway to do this that doesn’t involve me going through every email getting the info. manually?
I can get some of the info really easily off the OTA’s website, but unfortunately not email address or room type
Help me STW, you’re my only hope
p.s its from gmail account if that makes a difference?Posted 3 years ago
The topic ‘Help me kind I.T experts of STW’ is closed to new replies.