I need a Google Apps Scripter
Budget: $30 – $250 USD
I need a developer to create Google Apps Script to do the following for my online business.
I get enquiries for my services from schools, care homes and parties. I need the enquiries from parties automating.
Steps.
1. Open new Gmail enquiries (parties only)
2. Ignore enquires from schools and care homes.
3. Read the zip code on that email.
4. Check that zip code against a database of other zip codes in Google sheets. (This database will change overtime)
5. Find which zip code is the closest in that database
6. Calculate the driving distance to that zip code using Google Maps
7. Calculate the cost of travel (£0.45 per mile)
8. Add in the cost of travel to a Gmail
9. Send a standard Gmail reply but also include the cost of travel that has been calculated.
I get enquiries for my services from schools, care homes and parties. I need the enquiries from parties automating.
Steps.
1. Open new Gmail enquiries (parties only)
2. Ignore enquires from schools and care homes.
3. Read the zip code on that email.
4. Check that zip code against a database of other zip codes in Google sheets. (This database will change overtime)
5. Find which zip code is the closest in that database
6. Calculate the driving distance to that zip code using Google Maps
7. Calculate the cost of travel (£0.45 per mile)
8. Add in the cost of travel to a Gmail
9. Send a standard Gmail reply but also include the cost of travel that has been calculated.