Find Jobs
Hire Freelancers

AccuWeather API in Google Sheets

$750-1500 USD

Closed
Posted about 5 years ago

$750-1500 USD

Paid on delivery
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. Thank you,
Project ID: 18865387

About the project

21 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
21 freelancers are bidding on average $969 USD for this job
User Avatar
Hi there, I'm sure that will be able to help you with your API integration. You will have your Google Sheet as is, but all API keys and logic for reading the data will be on a standalone PHP server. You will have ability either to upload new data automatically by google input or just by cron, it will be up to you. This script will take approx 5 days after start. So, if interested, just contact me by chat and we will discuss everything. Thanks
$1,000 USD in 5 days
5.0 (408 reviews)
7.8
7.8
User Avatar
Hello, I have good knowledge of AccuWeather API and i worked with it before . I have read your complete job post and i am interested to discuss further on it. I have in-depth knowledge of php, mysql, javascript , jquery, payment system integrations, API's, css, html, html5. I will look forward to discuss with you. Thank you.
$833 USD in 15 days
4.6 (331 reviews)
8.2
8.2
User Avatar
Hi, I have extensive experience working on custom CMS/web applications and API integration. I'll be happy to help you out. My solution is a back-end system combining both Google Sheets API and AccuWeather API/DarkSky API. Cheers.
$833 USD in 10 days
5.0 (66 reviews)
7.4
7.4
User Avatar
I have experience of google sheet and its script I am interested in API. Mohsan
$750 USD in 20 days
5.0 (103 reviews)
6.4
6.4
User Avatar
Hello there? I have enough experience in integrating google sheet api . I can display lat and longitudue, Weacher of differents city using googl sheet api. You can check my portfolio to know my skill and experience. If you are interested in my works, please contact me. I look forward to working with you. Regards. Ase naritoshi.
$1,250 USD in 20 days
4.9 (67 reviews)
6.7
6.7
User Avatar
Hi I have just checked project details. I have completed project similar to this project. I have rich experience with Javascript. I am confident and ready to start work. Wishing your reply. Best regards
$1,250 USD in 20 days
4.9 (68 reviews)
6.6
6.6
User Avatar
Hello, I am pleasure with your job for AccuWeather API in Google Sheets. Thank you for the job posting. It’s a pleasure to meet you. I’d really like to work with you on this one if possible! I do have a couple of questions, but first I’d like to make you an offer and some background so you can check my work out. I have been developing kind of project within 10+ years so I’m fluent experience to handle project. You’ll get all the expected stuff like a great professional service and a fast turnaround, at a bit less, and I get a bit more exposure. If the above offer sounds like something you would be interested in, I’d love to hear from you. Best regards, Georgy
$1,250 USD in 20 days
4.9 (55 reviews)
6.2
6.2
User Avatar
Hi I am a professional MERN Stack & PHP, Laravel Web Developer. I have also worked on many APIs, especially email marketing like Zoho, MailChimp, Salesforce etc. This one also looks similar. I am expert in making of CMS & CRMs using APIs, Laravel and ReactNative and ReactJS. I use PHP, NodeJS, React & MongoDB framework to built Websites & Apps. I have 5 yrs of exp in PHP and 4 years in web development with third-party APIs. I have developed some good websites on these. You will get value for money. Please have a look at my profile. For more discussion, Please come in the chat box.
$800 USD in 10 days
5.0 (44 reviews)
6.2
6.2
User Avatar
Hi there, The requirements are quite clear and straightforward to implement so no questions really. I've checked accuwheather docs and apparently we just need to send an additional request with zipcode to get back the location key. Then we can use it to fetch the data for 5 days and import it into the sheet. I am planning to use Google apps script to implement this. I think that's the best tool for your use case since you won't need any server or any other medium to host the code since it'll reside on google ecosystem. You can run it manually no assistance would be needed, further you wouldn't even have to do it manually instead set it to run automatically for instance 2 times a day to import the data. Still, if you prefer another language or platform I'm totally fine with it as well. Anyway, I expect this to be ready in 5 days at most, thanks.
$750 USD in 5 days
5.0 (58 reviews)
6.3
6.3
User Avatar
Hello Sir, hope you are fine, I am interested in your work "Accu Weather API in Google Sheets". i already work on google sheet api in previous. i good preexistence in api integration work in previous i will make that script in php and you need to add cron job in hosting for pulling request of latest data come in private chat we will discuss more
$999 USD in 20 days
4.9 (45 reviews)
5.5
5.5
User Avatar
I mainly work with API Integration project.I have passion about API. I have been in this field for more than 7 years. i have experience in C#,php,Perl,wordpress,Html,postgress ,Ubuntu,Crontab,Web Services, Rest Api, Zend ,YIi,Mysql. Relevant Skills and Experience so i am right candidate for your project because i have experience in C#,Perl,php,node.js,Ubuntu,Crontab,Crypto currency,Wordpress,Ebay,Amazon,Instagram,Mysql,Sqllite,Mongo Db, Soap Api projects.
$1,250 USD in 10 days
4.9 (22 reviews)
5.4
5.4
User Avatar
Hi, my name is Asim and I'm a freelance developer with extensive experience with Python and JavaScript development. Additionally, I also have experience with Google Sheets API. One approach to go about this would be to attach a Google Apps Script to your Google Sheet which will be triggered two times a day. e.g. Every 12 hours, and look for missing information and fetch it from your API of choice and fill the missing information. I believe that I have the required skills and expertise in Javascript to develop such system. If you are interested in my proposal, feel free to get in touch to discuss further details. I will be waiting for your PM. Thank you!
$800 USD in 14 days
5.0 (10 reviews)
4.8
4.8
User Avatar
Hey there, With a proven track record of successful achievements, I am pleased to present you my proposal For your Project. I will develop the exact app as you mentioned in project description apart from it I have developed 100+ projects over different platform you can interview me before hiring. i am ready for the test. I strongly believe I can make a significant contribution in your project. My expertise: Data Entry, Excel, Javascript, PHP, Software Architecture I possess excellent communication skills and can liaise effectively with both clients and work colleagues. I would be highly gratified if you consider me for this important Job. we can discuss in details Over chat Thanks
$1,250 USD in 20 days
5.0 (12 reviews)
5.0
5.0
User Avatar
I would like to work with this project and will complete the work in time without compromising the quality. I am Well-versed in Microsoft Excel and other applications.
$833 USD in 20 days
5.0 (7 reviews)
3.0
3.0
User Avatar
Hello, I am a developer with 6 years' experience in .Net, WP, Magento and Joomla. I am looking for customer collaboration for future. We always put reputation and quality first. You will never be disappointed when working with us. Certified skills and Specialized on: ✍ Algorithms, Data Structures, Networking , Cryptography, Databases, Operating Systems , Compilers, Data Mining , Web Scraping, Website Designing, SEO, Machine Learning, Hadoop, Spark, Hive, Data Analytics, Statistics, Sentiment Analysis, Natural Language Processing, Swift, Objective-C, Java, Kotlin for Native iOS(iPhone/iPad) , Android app development. React.js, React Native, Xamarin, Unity , Ionic, Phonegap for Hybrid Crossplatfom development. AngularJS, Laravel, Ruby, ROR, Python, Matlab, Wordpress, Cakephp, R programming language, C++, Joomla for website development. Mapkit, GPS, API(JSON, XML, Rest Api) integration Firebase, Parse, Back4App, Urban, Amazon, Social Integration, Backend development. + Webservices with Restful + PHP & MYSQL, HTML5, CSS3, JavaScript, jQuery, XML, JSON. + eCommerce, Magento,Open Cart, Magento 2, Prestashop payment module Give me a chance and believed in me . I will make you happy and satisfied because of that. I believe that the implementation will yield a value for you.
$750 USD in 1 day
5.0 (1 review)
1.0
1.0
User Avatar
Dear Sir, Madam, This letter is to express my interest in your posting.. With a Bachelor’s degree in Computer Science, Master’s degree in Information Technology, and hands-on experience using python, mysql and AWS to create and implement software applications, I am confident I will be an asset to your organization. Over 18 years experience in IT areas with developing software from ground up to the effective results. Results oriented developer in Python also very familiar with technologies like Go, Java, Perl, Lua (nginx + Lua as data content intelligence and caching) and C#.
 
 I am experienced in remote work with very high self discipline.
 Sincerely Hubert Piotrowski
$1,250 USD in 20 days
0.0 (0 reviews)
4.4
4.4

About the client

Flag of KOREA, REPUBLIC OF
Seoul, Korea, Republic of
0.0
0
Member since Feb 27, 2019

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.