Cron scheduled imports of CSV data to Google Sheets via FTP (and potentially further to Google Calendar)

€30-250 EUR

Completed

Posted

over 6 years ago

€30-250 EUR

Paid on delivery

Hi there, Hope you are well. I'm lookling to setup up cron scheduled / automatic imports of data from a CSV file that's released/updated daily on a FTP server. The CSV file contains rows with book titles in it. One of the columns is for the release date of each title and I'd like to automatically have these release dates and titles added as events in a Google Calendar. Also, sometimes the release dates will be changed and this solution should also be able to update the Google Calendar events accordingly (so no duplicate events with different dates). If you can build the whole process (from FTP to Google Calendar), then that would be great! Otherwise, if you can get the data from the FTP server to Google Sheets, then I can use Zapier to synchronise between Google Sheets and Google Calendar. I've found a similar (but different) job to this here on Freelancer.com: https://www.freelancer.com/projects/php-excel/ftp-scripts-google-spreadsheets/ And I've also found a bit of Google Apps Script code, which might be useful as a starting point: [login to view URL] I'm open to other ways to achieve this as long as the end result is the same. Hope this is of interest and let me know if you have any questions. Thanks, Jonas

Project ID: 15028467

About the project

37 proposals

Remote project

Active 7 yrs ago

Looking to make some money?

Email address

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

Awarded to:

@matmunk

Hi, I can offer you a Python script that will automate the entire process using the Google Calendar API. I suggest running it as a cron job from Google App Engine, which I will also set up for you. Relevant Skills and Experience Python, Google Calendar API, and Google App Engine. Proposed Milestones €111 EUR - Project delivered Please get back to me for further discussion. I think this sounds like a pretty cool project.

€111 EUR in 3 days

5.0

(1 review)

2.2

37 freelancers are bidding on average €191 EUR for this job

@stevensargent

Hello, I have read your job description. I have built many mobile-friendly website using wordpress,shopify, woocommerce, html, php, jQuery, CSS up to now.I can start to work just now.I can deliver your job in a certain time.I hope you contact with me.

€155 EUR in 3 days

5.0

(385 reviews)

8.0

@schoudhary1553

Greeting, i can deliver you the 100% results with in the timeliness. Please check the profile deliver almost 240 projects with 100% client satisfaction. Relevant Skills and Experience I have the 5 years of experience with excellent knowledge. please give me a chance to work on your project Proposed Milestones €250 EUR - payment after work completion

€250 EUR in 3 days

4.9

(392 reviews)

8.1

@mithusamsukha

I can setup up cron scheduled / automatic imports of data from a CSV file that's released/updated daily on a FTP server. Relevant Skills and Experience Kindly provide me FTP and SSH root detail so i can start work on it !! Proposed Milestones €320 EUR - Cron Job Regards : Mithu

€320 EUR in 3 days

5.0

(84 reviews)

7.9

@latatestTech

A great team is here for your service!! I read the project description properly, and I agreed to fulfill 100% of all your requirements. I can start your important project right away. Relevant Skills and Experience Let's start! To achieve goal with 100% quality we have team of 27 Professional Software Engg. Reply us so that we can move ahead to get this software successfully run. Proposed Milestones €200 EUR - final

€200 EUR in 5 days

4.8

(169 reviews)

7.9

@gangabass

I can automate the whole process (from FTP to Google Calendar) using Python or PHP script. Relevant Skills and Experience I have worked on similar task before (but without Calendar part) so I know what I'm talking about. Proposed Milestones €200 EUR - Script to import CSV into Google Sheets / Calendar

€200 EUR in 3 days

5.0

(538 reviews)

7.6

@sritechnocrat

Hello. My cost might be but high but I will be doing research as well as implantation for your requirement. Bit research will including analysing yuh requirement and providing you best solution which is long lasting. Please ask me if you have any questions.

€833 EUR in 30 days

4.7

(83 reviews)

7.6

@steven6

Hi, I can deliver this project within 1-2 days (including Calendar). I would need to ask a few questions to clarify the scope. Please send me a message if you're interested. Thank you. Relevant Skills and Experience . Proposed Milestones €30 EUR - .

€30 EUR in 3 days

4.9

(50 reviews)

7.3

@BitLabs

Dear sir, My name is Farid, I have analyzed that I have right experiences in (Excel, Google App Engine, Javascript, PHP, Python) to execute your project "Cron scheduled imports of CSV data to Google Sheets via FTP (and potentially further to Google Calendar)". I will complete your project within 2 days, LIFETIME error free guarantee and provide 365 days (ONE YEAR) support... Relevant Skills and Experience Excel, Google App Engine, Javascript, PHP, Python

€188 EUR in 4 days

5.0

(117 reviews)

6.7

@nvbishr

where you want run the code? .................................................. pls send me details ............................. Stay tuned, I'm still working on this proposal.

€100 EUR in 3 days

5.0

(57 reviews)

5.8

@anuyadav1

hello . i can make it from getting data from ftp to google calenders , complete process automated . looking forward to work on this project . thanks

€198 EUR in 4 days

4.8

(83 reviews)

6.2

@nbprince

Hi, dear employer, I have already done many projects on google sheets and csv's I read your project carefully. I can carry out your task with the lowest budgets than anybody. Thanks, Regards: Nasir Relevant Skills and Experience php, code igniter , wordpress are my top skills We can decide the exact budget when you will get back to me in inbox with exact requirements. I hope you'll be good luck. Proposed Milestones €150 EUR - initial

€150 EUR in 3 days

4.9

(73 reviews)

5.7

@abbalove

Hey Jonas, I can build that. I am experienced. Rocky Stay tuned, I'm still working on this proposal.

€150 EUR in 3 days

4.9

(48 reviews)

5.1

@softwarevamp

Hello, I can do this in a timely, accurate and professional manner. Looking to work with you At your disposal for any query. Please get in touch and talk more about details. Regards, Weifeng Relevant Skills and Experience API PHP GOOGLE API Proposed Milestones €150 EUR - final deliverable

€150 EUR in 3 days

5.0

(26 reviews)

5.2

@BeautiCG

I believe that my 9+ years of programming experience makes me highly qualified for this project. I believe that I would be an asset to this project. Relevant Skills: Excel, Google App Engine, Javascript, PHP, Python,

€155 EUR in 1 day

4.4

(18 reviews)

4.9

@djcarras

hi, i can help you with your project. send me more information about via freelancer.com chat. regards Habilidades y experiencia relevante linux php html5 boostrap jquery google api Htos propuestos €13 EUR - freelancer.com fee €120 EUR - final milestone

€133 EUR in 3 days

4.9

(15 reviews)

4.1

@elegentcoder

We stand out as a web design and development company by insisting on pushing the boundaries of website performance, and by delivering work of the highest quality on-time and on-budget. Relevant Skills and Experience Our mission to stand out doesn’t stop with our internal goals. Proposed Milestones €222 EUR - To achieve goal with 100% quality we have team of 15 Professional Software Engg/Developer.

€222 EUR in 3 days

4.9

(5 reviews)

4.3

@arksong123

I have lots of experiences in developing FTP project like yours. I will provide the best service and best result for my clients. Please discuss with me more details. Thanks. Relevant Skills and Experience Excel, Google App Engine, Javascript, PHP, Python Proposed Milestones €166 EUR - all

€166 EUR in 5 days

4.9

(14 reviews)

4.2

@vinitsinha1240

Hello Sir, This is a very interesting project, and I would like to do the project. I would create a java program that reads the csv file from FTP server and writes the required data to the GS Relevant Skills and Experience Java, Excel, Google Docs Proposed Milestones €70 EUR - Initial Please let me provide the CSV file so that I can create a java program and show you the result.

€70 EUR in 2 days

4.9

(21 reviews)

3.8

@imuli

Create a script to parse csv file and create/update google calendar events. Relevant Skills and Experience I've worked with google apis before, parsing csv is no problem, and am flexible with language choice. Proposed Milestones €250 EUR - final script

€250 EUR in 3 days

5.0

(3 reviews)

3.4

@mdmahbubhelal

Hello Jonas, I can build the script to create calendar events and change accordingly on change. The only issue is google apps script can't get data from an FTP server. it can only make HTTP request. Relevant Skills and Experience javascript, google apps script Proposed Milestones €111 EUR - On complete So my question is will you be able to host it over HTTP?

€111 EUR in 3 days