Answering automatically to emails?

[Triben]

Hello Everyone, very excited to be on this forum.

I have a question.

I receive hundreds of email every days from customer inquiring about product I rent for different amount of time.

I have 200 products, soon 500, then 1000

The emails are coming from different websites (partners) so they don't have the same format but we can identify 10 different formats, no more than that.

Here is a regular day (I know it is ridiculous):

- Receiving emails from different websites about customers
- Opening each of them to check what are:
- the product they inquire about (I recognize with the picture of the product because I am not a robot, but a robot would recognize with the name of the product or the listing number)
- number of people
- dates required
- I calculate with this information what will be the price
- I answer the email with a typinator answer (software to expedite the repetitive texting) and I paste the price calculated before, I also attach some more pictures and characteristics of the specific product they were inquiring about
- I store the email in a folder (2 different folders depending of the amount of the sale)

I averagely do that 200 times per day and I know this is a non sense.
I would like to set up a system which can allow me to do a lot more things than just tediously responding to every one of them

My question is:
I don't want anymore to use typinator, calculate by myself the price with tax and paste it in the email.

Can something do it easily? Like Automator or a payable software?



Thanks so much for your contribution
Triben

 

[miles01110]

You could probably set up a Rule of some sort... haven't looked into whether you can send an e-mail automatically via a Rule, but wouldn't be surprised if you could.

 

[numlock]

automator is definitely not enough.

i believe applescript should be able to handle it or something like google scripts if you use google apps for email. to me it seems you would need some sort of database with all these product numbers, product descriptions, prices etc.

from a scripting perspective is there no way that all the mails you receive can follow the same format?

if you want to look into a custom applescript i would advice you to check out macscripter