We need someone to build an API within Google Sheets. We are pulling weather information for different cities.
Here is the template: https://docs.google.com/spreadsheets/d/1MEwUqFPQ-8A-JrhRK8rw_8Cs-779chGoDQ_vFShcjw0/edit#gid=763047195
The inputs are what are going to given in the Google Sheet. The outputs are what need to populate from the API. We anticipate calling the API twice per day with approximately 30 rows of data (with the 6 columns of input). We need to be able to use the API without any other assistance. This needs to be automatic and pain-free. A few other notes:
1. We want the API to exist in Google Sheets, not downloading a CSV
2. There are two services that you can consider using: DarkSky and AccuWeather. However, the DarkSky API requires lat/long and the AccuWeather API requires the what it calls the "location key." We need a faster way to get them so we can pull the rest of the data; we want to call the API twice per day to fill out the outputs without any additional work.
3. Not sure if Python / Ruby knowledge would be useful here.
Please let me know when you have time for a quick phone call and a time/cost estimate for this project. We'd like this completed within 2 weeks.
24 freelancer đang chào giá trung bình $987 cho công việc này
Hello. I am really interested in your project, as an experienced web developer with wealth of knowledge in all aspects of web development. Hope to go further discussion on your project. Thanks.