email processing with a calcation possibly using zapier
$250-750 AUD
Zaprt
Objavljeno pred približno 7 leti
$250-750 AUD
Plačilo ob dostavi
We currently receive leads for people moving home in Australia, and these leads come with a list of items included.
This list contains a finite amount of items, and the list is always in the same order, but not always the same items.
The list is only available in email format.
We currently take the details from this form, and copy and paste it into a form on our website that enters it onto our database
Then we have to manually calculate the total volume of the list of items.
What I would like to achieve is the removal of the calculation part of this process
I would like to be able to send the emailed lead that we receive direct to a web hook, that does the following
Does a calculation based on the criteria below
Then send an email with the calculation completed, plus some of the fields from the original email.
Details:
If you look at the end of this description is a copy of the exit email we receive initially
The important part is the list of items
Each item on this list has a value to us in cubic meters.
What I am looking for is for some way to take this email, extract the data we need and calculate the total volume of space we need for each one
EG
Here is a list we received
Items to Move:
Queen bed x 1
King bed x 1
Bedside Table x 1
Chest x 1
Fridge x 1
4 Seater Sofa x 1
Coffee Table x 1
Large TV x 1
Small TV x 1
Shelves or Bookcase x 2
Washing Machine x 1
Outdoor Dining Table x 1
Small Box x 10
Medium Box x 4
Large Box x 4
Each item has a cubic value to us like i mentioned
Queen Bed is 1.8m3
King bed is 2.2m3
Bedside Table is 0.2m3 and so on
We need to somehow automate the calculation on this as we sometimes receive 20 - 30 leads per day, and its a very mundane job.
I will supply the entire list, as if someone had selected one of everything, and also every items cubic value.
I want something that the end result will be we have a total in cubic meters plus some data from the original email
This will need to be returned to us like this example below:
_____
Customer Details:
David
telephone ( on fomr this is actually a number but freelance wont let me have a telephone number here)
email ( on fomr this is actually a number but freelance wont let me have a email addre here)
Pickup:
Red Hill, QLD 4059
Property Type: Single Storey House (2 bedrooms)
Access Restrictions: None
Dropoff:
Sydney, NSW 2000
Property Type: Apartment Without Elevator (3rd Floor+) (2 bedrooms)
Access Restrictions: Loading zone at building rear
Items to Move:
Queen bed x 1
King bed x 1
Bedside Table x 1
Chest x 1
Fridge x 1
4 Seater Sofa x 1
Coffee Table x 1
Large TV x 1
Small TV x 1
Shelves or Bookcase x 2
Washing Machine x 1
Outdoor Dining Table x 1
Small Box x 10
Medium Box x 4
Large Box x 4
Total Meterage 23m3
________
I am open to suggestions on how to acheive this, either using zapier or some other means
Thanks
The original email we receive is like this below
Interstate Removalist Job
Status:
Open for quotes
Job closes in: 2 days 23 hrs
Customer: David
Pickup:
Red Hill, QLD 4059
Property Type: Single Storey House (2 bedrooms)
Access Restrictions: None
Dropoff:
Sydney, NSW 2000
Property Type: Apartment Without Elevator (3rd Floor+) (2 bedrooms)
Access Restrictions: Loading zone at building rear
Distance & Travel Time:
Approx road distance: 924km
Approx travel time: 10 hours 12 mins
When: 21/01/2017
Items to Move:
Queen bed x 1
King bed x 1
Bedside Table x 1
Chest x 1
Fridge x 1
4 Seater Sofa x 1
Coffee Table x 1
Large TV x 1
Small TV x 1
Shelves or Bookcase x 2
Washing Machine x 1
Outdoor Dining Table x 1
Small Box x 10
Medium Box x 4
Large Box x 4
Other Information:
urgent relocation to Sydney for work. Looking to move Fri/Sat this week. Access to new property from 2pm Saturday.
My Quote
$1.00
Fixed Rate (Inc GST)
Date of Quote:
18/01/2017
Active
Customer Details:
David
phone number
email address
Hi there - I’ve read your brief and I'm very interested in it.
I'm very good at php,javascript, Mysql, CSS, jquery, codeigniter,wordpress,angular.js and reactjs ...etc.
I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like
to view my previous work, take a look at my Freelancer Portfolios
Hello,
It's a pleasure to let you know that I've Completed and Delivered similar project before. All I need to work on customization part if we can proceed towards more discussion. I have gone through your project description and confident to accomplish your project.
I am an individual developer and you will be working directly with me if we proceed work on this project.
My key skills are –
1)Ruby
2)Ruby On Rail
3)Angular JS
4)Node JS
5)PHP with Codeigniter and Laravel Framework.
6)App development
Let's initiate our chat so we can proceed towards the conclusion of this project scope and give it a start as soon as possible.
Thanks & Regards
Hi ,
I am senior software engineer. I have done so many automation work.
I would make program for you . you need to double click and all work would be done in 2-3 minutes.
Pls ping me. Happy to work for you.
Thanks
Please send me the sample email and I will first show you the calculation with extraction of relevant info and and then you can pay me. I will be using PHP or NodeJS.