Create a Google Apps Script using Google Geocoding API and Google Places API
$30-250 USD
Completed
Posted almost 8 years ago
$30-250 USD
Paid on delivery
I need a Google Apps Script that will take the following information from a Google Sheet:
Facility Name (typically a hospital name)
City
State
... and then using Google's Geocoding API (server side geocoding, not client side) and Google Places API output the following in the appropriate columns (in the same Sheet):
Latitude
Longitude
Zip Code
Website (for the facility)
Ratings
Photo (first in the array)
The job requires help setting up Google API credentials so that I don't encounter the daily geocoding and places API limits. I'm expecting that the table will have several thousand rows.
I know that Google Places API can reply with multiple responses to a query with a facility name and city/state. In my experience, the first response is almost always the one I’m looking for, so when the API query is made, I would just take the first response that comes back.
Here’s a sample sheet:
[login to view URL]
I would be able to deliver in 24 hours. However if the lookups would be multiple thousands per day, you might have to enable billing (fees are likely to be around a buck or two). If this is just a one-time lookup, we could easily go without billing.
$77 USD in 1 day
0.0 (0 reviews)
1.7
1.7
8 freelancers are bidding on average $168 USD for this job
hey man,
I have worked on Google Maps api. I have used to place custom markers on a customer's project. Then these markers were used to calculate shortest path.
I am experienced in javascript. I can easily code this project for you
Please contact me! I am eagerly waiting for your message
Thanks
Greetings
Ready to work as per your requirement. Please share the link of your site and and let me know when can we discuss. As i am available and ready to start the work immediately.
I am expert in web development and insure you to provide the work as you are looking for.
Waiting for your Response.
Kind Regards