Automate downloading a .CSV file daily on Google Drive

Fermé Publié le il y a 6 ans Paiement à la livraison
Fermé Paiement à la livraison

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

Moteur Google App Google Cloud Storage JavaScript Python Scripting

Nº du projet : #16146195

À propos du projet

29 propositions Projet à distance Actif il y a 6 ans

29 freelances font une offre moyenne de 461 $ pour ce travail

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 Plus

$400 CAD en 3 jours
(527 Commentaires)
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 en 10 jours
(104 Commentaires)
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 en 3 jours
(199 Commentaires)
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 Plus

$500 CAD en 7 jours
(29 Commentaires)
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 Plus

$400 CAD en 10 jours
(119 Commentaires)
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 Plus

$555 CAD en 10 jours
(75 Commentaires)
6.7
NayaPakistan

A proposal has not yet been provided

$500 CAD en 5 jours
(142 Commentaires)
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 Plus

$555 CAD en 10 jours
(50 Commentaires)
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 Plus

$333 CAD en 5 jours
(17 Commentaires)
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 Plus

$277 CAD en 7 jours
(33 Commentaires)
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 Plus

$600 CAD en 10 jours
(4 Commentaires)
5.1
kripanidhi

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

$500 CAD en 5 jours
(19 Commentaires)
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 Plus

$666 CAD en 10 jours
(8 Commentaires)
4.7
kharota

A proposal has not yet been provided

$250 CAD en 7 jours
(17 Commentaires)
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 en 10 jours
(9 Commentaires)
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 Plus

$400 CAD en 3 jours
(5 Commentaires)
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 en 10 jours
(1 Évaluation)
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 en 10 jours
(0 Commentaires)
0.0
mamadpurbo

A proposal has not yet been provided

$444 CAD en 2 jours
(0 Commentaires)
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 Plus

$360 CAD en 14 jours
(0 Commentaires)
0.0