Automate downloading a .CSV file daily on Google Drive

Closed Posted 6 years ago Paid on delivery
Closed Paid on delivery

I want to automate a process. Basically, I do the following manually (every weekday):

Login to [login to view URL], download a .csv file containing a list of stocks.

I save it on my local drive. Then, I run a Powershell script that filter this .csv file and created a new .csv file that I manually analyze.

What I would like to happen:

Download automatically the .csv file from [login to view URL] to my Google Drive (@ 5h00 PM every weekday - or when the stock market is open). The script must be run from the cloud (not from my computer). We must be logged in to the website to download a .csv file. Look at this page: [login to view URL] See the download button on the upper right of the table. The URL of the .csv file is generated by [login to view URL] through a JavaScript (it`s not a hard link)

Then, another script is run just after. It filter this .csv (based on some criteria) and create a new .csv file, also saved on my Google Drive.

It can send me the results by email (optional).

I would like to have a kind of notification if it fail (probably email).

The scripts must be run from a cloud based service.

I think a Google App Script would do the job. Python would be good (as I would like to learn it), but I don`t know if it can be run on the cloud with GDrive.

However, I am open to use IFTTT or Zapier (as long as there is no monthly cost involved).

I have attach

Google App Engine Google Cloud Storage JavaScript Python Scripting

Project ID: #16146195

About the project

29 proposals Remote project Active 6 years ago

29 freelancers are bidding on average $461 for this job

ramzitra

Hi, I am interested in your project related to build a Python script to be run daily to download a csv and put it on google drive as well as filter it based on some criteria. The script could be run on a VPS i'll recom More

$400 CAD in 3 days
(527 Reviews)
8.8
mingxiao2008

Dear,Sir How are you? I have read your project description and I am ready for starting your project. i am going to use using pydrive python package. I will work very hard and best for you. Best Regards

$400 CAD in 10 days
(104 Reviews)
8.0
lkhelladi

Hello, I'd be glad to develop a python script that automates the csv download and processing for you. Looking forward to chat with you soon for more details. Best regards,

$400 CAD in 3 days
(199 Reviews)
8.0
seaanddream

Hi, my name is Sevinc. I read your "Automate downloading a .CSV file daily on Google Drive" project descriptions carefully before bidding. I checked the target url, and attached document as well... I got what you nee More

$500 CAD in 7 days
(29 Reviews)
7.3
jayshreeganeshha

hi,software developer here and i have gone through your requirements. i am aware of automation works and i can complete your project. I hope to get chance to work on this. I will create server side solution so you c More

$400 CAD in 10 days
(119 Reviews)
7.1
bestit4u

Hi,sir I have read your post and I am very interested in your project. I have good skills with the program language including C/C++, C#, java, php, asp.net, python, VB.NET. So I have expert and smart technic with we More

$555 CAD in 10 days
(75 Reviews)
6.7
NayaPakistan

A proposal has not yet been provided

$500 CAD in 5 days
(142 Reviews)
6.4
Ajcm623

Hi. Thank you for your job posting. I can do that with python or google script. But if you want to download the file in specific time, there must be a some kind of process. Or we can use cron job. I think we have More

$555 CAD in 10 days
(50 Reviews)
6.0
sgatich

Hi. I'm a programmer from Russia with strong skills in Python. You can see the full list of my skills on my profile page. I'm also good in web-scraping, browser automation and data extraction. I use Grab, Requests, Sel More

$333 CAD in 5 days
(17 Reviews)
5.6
rajat100493

Hi. I love a lot when I find projects in which people try to automate their daily tasks to make their life easier. GO PYTHON This is a very simple script and can be done in Python for way less than your budget. I can More

$277 CAD in 7 days
(33 Reviews)
5.4
ByteSols

Hello, This is Mills, I have gone through your project detail and ready to work on the feature that you are looking, We have a very good team of designer and developer located in Los Angeles CA. Some of my skills ar More

$600 CAD in 10 days
(4 Reviews)
5.1
kripanidhi

I WILL BUILD THE AUTOMATION SCRIPT FOR YOUR WORK AUTOMATION USING PYTHON , SELENIUM, PHANTOMJS , CASPERJS OR OTHER HEADLESS BROWSERS

$500 CAD in 5 days
(19 Reviews)
4.9
filalizakariae

Hello, well, I can create a python script that does this for you (including sending the result as email), and we can run it with a cron every weekday whenever you want. The script can be hosted in digital oceans More

$666 CAD in 10 days
(8 Reviews)
4.7
kharota

A proposal has not yet been provided

$250 CAD in 7 days
(17 Reviews)
4.2
yh2013

I have many projects developed in Python for web scraping in most of them (similar to your project). Python can interact with google drive, it is required a key from Google, do you have it?

$250 CAD in 10 days
(9 Reviews)
4.0
robinsjp

Hi What you need is a scraper script. The thing which makes this tricky is the fact that the front end is in JS, so you need to find a smart way of constructing the download script from the JS source files. The More

$400 CAD in 3 days
(5 Reviews)
3.8
mike199

Hey, I specialise in web development. I live in Oxford. Your project seems interesting and I do have the required skills. I've done something similar recently, will be happy to share.

$555 CAD in 10 days
(1 Review)
3.2
zdesign77

Hey, how are you? I’m Mike, I’m a Web Designer & Developer located in Boston. I’m confident that my skills match your requirements perfectly. I recently did a very similar project which I can share with you.

$555 CAD in 10 days
(0 Reviews)
0.0
mamadpurbo

A proposal has not yet been provided

$444 CAD in 2 days
(0 Reviews)
0.0
tropicalzed

I have done work related to interacting with websites programmatically, namely I automated using python/selenium to download all my old online notes for medical school. I used a lot of xpath and inspecting of html elem More

$360 CAD in 14 days
(0 Reviews)
0.0