Automate downloading a .CSV file daily on Google Drive (2)

$30-250 CAD

已取消

已发布

将近 6 年前

$30-250 CAD

货到付款

I want to automate the following process. I do the following manually (every weekday at the end of the day): Login to [login to view URL], download a .csv file containing a list of stocks. Stocks --> New Highs & Lows --> Select a Custom View --> Click download (see the screenshot attached) I save the .csv file on my local drive. Then, I run a Powershell script that filter this .csv file and created a new .csv file (based on differents criteria like the price, volume, etc...) The output is a new .csv file with only the stocks that match my criteria. What I would like to happen (the automation): Download automatically the .csv file from [login to view URL] to my Google Drive (@ 5h00 PM every weekday) (We must be logged in to [login to view URL] to download a .csv file.) Look at this page: [login to view URL] The URL of the .csv file is generated by [login to view URL] through a JavaScript (it`s not a hard link) (need web scraping capabilities). 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. Send me the results by email. We can't use the Barchart API for that. The scripts must be run from a cloud based service, ideally, Google App Scripts (not from my computer) I have attach some information.

项目 ID: 17511403

关于此项目

38提案

远程项目

活跃6 年前

想赚点钱吗？

电子邮箱地址

在Freelancer上竞价的好处

设定您的预算和时间范围

为您的工作获得报酬

简要概述您的提案

免费注册和竞标工作

38威客以平均价$210 CAD来参与此工作竞价

@e3d

Hi, I can create such script. please give me barchart credentials so I can check how the download link is generated and give me more details on which rules you use to reformat that csv into the final format. Thanks!

$255 CAD 在3天之内

5.0

(274条评论)

8.8

@zekovicm

Hi there,I am Miljan,Automating expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this job ! I can start immediately and finish it within the agreed deadline. Check out my profile, portfolio and former clients feedback - that'll let you know everything about me. Please feel free to contact me so that we can discuss further details. Thank you for taking the time to read my proposal.I am looking forward to hearing from you. Best regards, Miljan

$277 CAD 在2天之内

4.9

(176条评论)

8.0

@schoudhary1553

Hello, I can help with you in your project Automate downloading a .CSV file daily on Google Drive (2) I have more than 5 years of experience in Google App Engine, Google Cloud Storage, Javascript, Scripting, Web Scraping. We have worked on several similar projects before! We have worked on 380+ Projects. Please check the profile reviews. I can deliver your job with in your deadline. Please ping me for more discussion. I can assure the 100% job satisfaction. Thanks,

$250 CAD 在3天之内

4.9

(112条评论)

7.3

@RobustTechServ

Greetings! I have read the project and actually I have thought of several ways of performing this task. Using Java/Selenium to automate the process could be a good choice as I think of it. Anyway the filtering is easy in any but I may as well do it in Java so you only have a standalone to worry about. Have a good day.

$222 CAD 在5天之内

5.0

(18条评论)

7.0

@SigmaVisual

Hi, I have extensive experience of working on similar automation related projects. I can help to automate downloading of .CSV file and automate other steps according to your requirements. Please let me know when you are available so we can discuss further. Please see below for few similar automation related projects and reviews/ratings on freelancer that I have completed successfully in past: WooCommerce: ERP API integration with WooCommerce site - https://www.freelancer.com/projects/php/ERP-API-integration-with-WooCommerce-16472100/ Automate post loading in a wordpress - https://www.freelancer.com/projects/php/automatizar-carga-post-wordpress/ External Wordpress Automation - https://www.freelancer.com/projects/Wordpress/External-Wordpress-Automation/ Wordpress Cloning and Installation Script - https://www.freelancer.com/projects/PHP-Script-Install/Wordpress-Cloning-Installation-Script/ Opencart: Import Icecat data project for opencart system. - https://www.freelancer.com/projects/PHP-MySQL/Import-Icecat-data-project-for.4509417/ Virtuemart: Scraping ecommerce site into virtuemart - https://www.freelancer.com/projects/Web-Scraping-eCommerce/Scraping-ecommerce-site-into-virtuemart/ virtuemart update from cvs - https://www.freelancer.com/projects/PHP-Data-Processing/virtuemart-update-from-cvs/ Others: Pinnacle cart / inventory update script - https://www.freelancer.com/projects/PHP-Script-Install/Pinnacle-cart-inventory-update-script/

$150 CAD 在3天之内

5.0

(70条评论)

7.1

@kunitsynartem

Hello! I'm sure your task can be done using Python. I can make a script (cloud-based, so your computer will not be envolved. you can propose your cloud-service provider, or I can do this for you.), that will log-in using Selenium and download the CSV file. Selenium can handle JavaScript-generated content, so your csv-link can be found easily. Then, again using Python, we can filter csv file as per your requirements and create new file with results.

$200 CAD 在3天之内

5.0

(43条评论)

6.4

@kanwalrafique

Hello, I read your project brief. I have experience in writing Google Apps Script for Google Apps including Google Sheets and Google Drive. I can write an Apps Script for you to automate the task you currently have to perform manually. I can set a time interval for the Apps Script to run automatically on the weekdays at 5:00 PM and send you an email with filtered CSV as an attachment. About me ======== I'm a Software Developer. I have experience in writing Google Apps Script which is basically a form of JavaScript language. I have done several Apps Script projects for various clients here on Freelancer.com. You can check reviews on my profile to get an idea. But if you'd still like to see my previous work yourself then I can show it you to assure you that I can do this task. If you would like to discuss your project with me then feel free to send me a message. I usually respond within a few minutes when online and within a few hours when offline. Thank you.

$200 CAD 在5天之内

5.0

(67条评论)

6.5

@dmitriyButeiko19

Hello, I have experience with google scrips.I already completed 3 project using google app scripts. Javascript Applications That I wrote on Freelancer.com: https://www.freelancer.com/projects/javascript/Coding-challenge-solutions/ https://www.freelancer.com/projects/html/JavaScript-Experiment-Debug/ https://www.freelancer.com/projects/php/JavaScript-Image-Fix/ https://www.freelancer.com/projects/php/implement-javascript-have-the-code/ https://www.freelancer.com/projects/css/Create-web-application-with-Angular/ https://www.freelancer.com/projects/php/Adjustment-for-JavaScript-Project/ https://www.freelancer.com/projects/html/Javascript-HTML-expert/

$88 CAD 在2天之内

5.0

(98条评论)

6.2

@freelance4hire80

Hi I have go through the job description. I can come out a program / script to automate the manual process for you. I can help you to install the script on vps as well

$200 CAD 在3天之内

5.0

(31条评论)

6.1

@elbruninh

Hi, i'm interested, could you give me more details please? are you interesting in a PHP solution? if so, can you send me the login credentials? i can do it regards

$150 CAD 在1天之内

4.9

(72条评论)

6.0

@nisthark

Hi Sir, My name is Nisthar. I am a Software & Web developer. I can build a automation script in NodeJS(Javascript) that can scrape dynamically created csv and save it to your drive. I can also make it create the new csv file based on the criteria you provide. I can do this. Please contact me. Thanks.

$250 CAD 在1天之内

4.7

(19条评论)

5.8

@archanaoswal

I can achieve all the objectives in Google Sheets using the Google Apps Script. I have excellent command on Google Apps Script and I know how to: - Login to a website and download files - Convert CSV files to Google Sheet files - Transform the output to the required format - Mail the transformed file I have completed complex projects before in Google Sheets using Google Apps Script. For instance - Extract csv files daily from gmail and convert it to Google Sheets for further processing - Get live cyptocurrency data and create dashboard using coinmarket API - Upload and Manage Videos in Vimeo using JSON API in google sheets - Extract mails and attachments from gmail to google sheet and drive respectively - Twitter functionality like retweet, auto-tweet, and so on - Integrated Google Sheets, Forms and docs to create a dashboard and tracking system to track health data of individuals for a health care organization You can see the reviews of the same in my profile

$200 CAD 在3天之内

4.8

(26条评论)

5.3

@dany3j

Hello Mr. I can help you with this task. I would like to know more about this project. I've done similar projects. contact me by chat to get more information. Best Regards

$222 CAD 在5天之内

5.0

(48条评论)

5.2

@DarkKnight2206

I am a python developer. I have great experience in web scraping and I am an expert in it. I have all necessary skills by which I can scrape any website. I have even scraped sites like google, whatsapp web, instagram, etc,. which you can check in my portfolio. Ping me to discuss in detail.

$125 CAD 在2天之内

4.7

(27条评论)

5.4

@CodingExpertz

Hi, Let me do it for you. I have 12+ years of experience on web technologies and would love to work on your project. I look forward to the possibility of working together! Regards, Nand

$300 CAD 在3天之内

5.0

(13条评论)

4.3

@Vijayabhaskar96

I have done automation tasks like this, in python for javascript rendered websites. Contact me if you're interested in hiring me.

$200 CAD 在3天之内

5.0

(15条评论)

3.9

@andrewemel

Hi there, I would like to be considered for your project. I have 3+ years of experience in Python and Web Scraping. I'll be glad to help. Best regards, Andrew

$90 CAD 在2天之内

5.0

(7条评论)

3.9

@ekoomitsolution

I would like to do function on your Exel sheet for automatic download . Let me know if you are interested.

$155 CAD 在3天之内

4.8

(8条评论)

3.5

@pnathansango

I would love to do this work, please drop me a message, I have all the qualities you were looking for. Warm regards, Paul Nathaniel Sango

$155 CAD 在3天之内

5.0

(1条评论)

0.3

@bidhanbaralvw

Hello, I'm a Web Developer as well as designer , and I'm very interested in your job post. I have consistently delivered many projects on time and under budget. I believe my skills would be ideal for your project. Looking forward to hearing from you :) With Thanks and Regards, Bidhan

$250 CAD 在7天之内