Find Jobs
Hire Freelancers

Script that extracts data behind a login and posts into Google Sheet once/day

£20-250 GBP

Closed
Posted over 5 years ago

£20-250 GBP

Paid on delivery
I need a script built that does the following once per day: 1) Visits [login to view URL] 2) Logs in (using our login credentials) 3) Goes to a URL that displays some data in a table ([login to view URL]!/app/reports/media) 4) Change some drop-down parameters (e.g. to show yesterday's data only AND select the option to display the tracking code) 5) Extracts the data displayed in the table and paste it into a Google Sheet. This must be outputted in the Google Sheet as shown below (one value per cell) so that we can run formulas on it. I.e. you CANNOT just take a screenshot of the data - it needs to be actually in the cells in Google Sheets. This script needs to automatically do this once per day. The login details need to be stored securely in the script. You can use Zapier to post the data into the spreadsheet if easier than authenticating with Google Sheets (i.e. you could just post the table data to a webhook). But it's up to you how you want to do it.
Project ID: 17816417

About the project

22 proposals
Remote project
Active 6 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
22 freelancers are bidding on average £162 GBP for this job
User Avatar
Hello, i have read your project details and i can help you with 100% quality and your satisfaction. I have delivered more than 400 project with client satisfaction. Please see my profile . I have more than 5 years of experience in Excel, Javascript, PHP, Python, Software Architecture. Please ping me for discussion. Thanks.
£250 GBP in 4 days
4.9 (480 reviews)
8.3
8.3
User Avatar
Hello sir, i will build a script to login on the site by your user ID and pass then it will get the data from the site as you showed in the attached files to update on google drive .
£200 GBP in 4 days
4.9 (217 reviews)
7.8
7.8
User Avatar
Hello Taylor, I can write scraping script in your google sheet. I have 5 years experience in Web scrapping and I can scrape data from Captcha enabled sites, Proxy restricted sites also. I can complete task within time with 100% accuracy. With Regards, Sai
£100 GBP in 3 days
4.9 (496 reviews)
7.6
7.6
User Avatar
Hello sir I am a qualified python developer with 8 years of professional experience. I got you and I am confident with this project. I am going to use 'Requests' library and 'Googlesheet' api. I am ready to start the work. Looking forward to hearing from you soon. Best Regards, Yongtao
£250 GBP in 3 days
4.9 (129 reviews)
7.6
7.6
User Avatar
Hello, I'm Abu Gosia. I'm interesting your project very well. I'm good in Website Design, Yii2, PHP, Laravel, Codeigneter, Wordpress, Open Cart, C#, .Net, MVC, Angular.js, ASP.NET. I m quite well experienced in these jobs. Let's go ahead with me. Thanks
£233 GBP in 9 days
4.8 (210 reviews)
7.0
7.0
User Avatar
Dear employer, I've gone through the screen shots of the page and required spreadsheet sample and can proceed with the automation of the data extraction, as per your requirement. I can provide you a java program that can be run daily to perform the task. Please let me know if that works for you. Looking forward for a positive response from you. Thanking you Shaik Allabakash.
£99 GBP in 5 days
4.9 (47 reviews)
5.2
5.2
User Avatar
Hi. I'm a programmer from Russia with strong skills in Python. I'm good at web-scraping, browser automation and data extraction. I use Grab, Requests, Selenium and BeautifulSoup libraries for this purpose. I offer to use Selenium. The script will log in to Trio-partners, set the parameters and extract data. Then the script will log in to Google and paste data into the spreadsheet. Maybe I'll use Google API to paste data. Or maybe I'll use the OpenPyXL library to work with XLS format. If you're interested, feel free to contact me. All the best, Sergey.
£88 GBP in 2 days
4.9 (16 reviews)
5.2
5.2
User Avatar
Hey Dear, I can do it using Python (made for bots), I Would like to discuss further about your requirements in complete details so that I can provide you the best solution accordingly. Why me? Full-Stack developer over 7 years of experience with highly experienced with PHP, Javascript (ES6), Webpack, Vuejs 2, jQuery, HTML5, CSS3 (LESS/SASS), Bootstrap, UI/UX design, and databases. PS: You can take a look at my profile. Thanks Best Regards, Med.
£133 GBP in 3 days
5.0 (5 reviews)
4.1
4.1
User Avatar
Hi, I have seen your proposal. I am an excel expert with very good knowledge of VBA, google scripts. I can do this task. Please come on chat for more details. Awaiting your response. Thank you.
£60 GBP in 3 days
4.4 (47 reviews)
4.6
4.6
User Avatar
Hello my name is Fares, I can get it done perfectly as you want let's chat when you are online, Thanks
£25 GBP in 3 days
4.7 (21 reviews)
4.0
4.0
User Avatar
Hi there, i understand your requirement and if you need a sample work,can provide within one hour. if you have any questions please let me know, can start now your project according to the your guide line with Confirmation.
£100 GBP in 1 day
4.9 (12 reviews)
3.6
3.6
User Avatar
Hi this can be done by web automation. I can create a Python script for this and it will take me max of 3 days to develop and test it. Please message me to discuss and work on it.
£55 GBP in 3 days
5.0 (9 reviews)
3.0
3.0
User Avatar
I would code this using Python or Node.js (whichever you prefer); I'm sure that I would be able to complete this project quickly since I've had experience with similar projects (using google sheets API and such). If you have any questions, feel free to contact me :)
£95 GBP in 1 day
5.0 (3 reviews)
2.3
2.3
User Avatar
Hi. It's me you are finding for. I've developed and I can show you my example. Why don't you send me message? I have a 9+ years of experience in skills you required. I have read your project with great care and I am sure I can do a perfect job for you. I have a experience in this side. I sincerely hope I work with you. If you hire me, I can provide top quality within your timeline and budget. I regard my honor than everything else. Thank you.
£66 GBP in 3 days
0.0 (1 review)
0.0
0.0
User Avatar
I have google experience in Google drive API and integration.
£77 GBP in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have vast experience of 8 years in web automation and java, and this project can be done by using both of these technologies. I have already done similar requirements and can finish this quickly with 100% quality. I’m good at creating readable and reusable code so that maintainability is very easy.
£50 GBP in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I can do this. I have around 7 years of experience in IT. let me know your interest.
£833 GBP in 30 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
Wallingford, United Kingdom
5.0
45
Payment method verified
Member since Aug 18, 2014

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)
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.