Automate downloading a .CSV file daily on Google Drive

終了済み 投稿 6年前 着払い
終了済み 着払い

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アプリケーションエンジン Google Cloud Storage JavaScript Python Scripting

プロジェクトID: #16146195

プロジェクトについて

29個の提案 リモートプロジェクト アクティブ 6年前

29人のフリーランサーが、平均$461 で、この仕事に入札しています。

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 もっと

$400 CAD 3日以内
(527件のレビュー)
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 10日以内
(104件のレビュー)
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 3日以内
(199件のレビュー)
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 もっと

$500 CAD 7日以内
(29件のレビュー)
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 もっと

$400 CAD 10日以内
(119件のレビュー)
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 もっと

$555 CAD 10日以内
(75件のレビュー)
6.7
NayaPakistan

A proposal has not yet been provided

$500 CAD 5日以内
(142件のレビュー)
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 もっと

$555 CAD 10日以内
(50件のレビュー)
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 もっと

$333 CAD 5日以内
(17件のレビュー)
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 もっと

$277 CAD 7日以内
(33件のレビュー)
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 もっと

$600 CAD 10日以内
(4件のレビュー)
5.1
kripanidhi

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

$500 CAD 5日以内
(19件のレビュー)
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 もっと

$666 CAD 10日以内
(8件のレビュー)
4.7
kharota

A proposal has not yet been provided

$250 CAD 7日以内
(17件のレビュー)
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 10日以内
(9件のレビュー)
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 もっと

$400 CAD 3日以内
(5件のレビュー)
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 10日以内
(レビュー1件)
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 10日以内
(0件のレビュー)
0.0
mamadpurbo

A proposal has not yet been provided

$444 CAD 2日以内
(0件のレビュー)
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 もっと

$360 CAD 14日以内
(0件のレビュー)
0.0