Write a python script to automate sending new data from Active Campaign
- or -
Post a project like this1512
£25/hr(approx. $31/hr)
- Posted:
- Proposals: 12
- Remote
- #2703996
- Awarded
Top Web, Mobile Developer for B2B | B2C | Online Learning | MarketPlace | Travel
Solihull
software engineer|Full-Stack Software Developer| web developer| App developer | AI Engineer | WordPress
Indore
WordPress Expert✮Shopify Expert✮Graphic Designer✮AutoCAD 2D & 3D✮CV Writer & Designer✮Fullstack developer
Rawalpindi
970117351470500685142971318883802378577241756626277542841151342717135277393636573
Description
Experience Level: Expert
We are running a social media campaign using Active Campaign and need to automate sending new data to the client via SFTP everyday. We're looking for someone to write a script which we can use to do this. We'd house all the datas and like this to end up being a completely automated process.
This is a breakdown of what needs to be done:
- Remove any commas from the existing data in the excel spreadsheet/google sheet by parsing the file and removing any commas within the quoted portions
- Turn the excel spreadsheet/google sheet into a .csv file
- Send that spreadsheet daily to a folder housed on a PC
- Write a Python script to parse the file for records with the day’s date, rename it, save it to another folder on the PC, SFTP it our client’s server
This is a breakdown of what needs to be done:
- Remove any commas from the existing data in the excel spreadsheet/google sheet by parsing the file and removing any commas within the quoted portions
- Turn the excel spreadsheet/google sheet into a .csv file
- Send that spreadsheet daily to a folder housed on a PC
- Write a Python script to parse the file for records with the day’s date, rename it, save it to another folder on the PC, SFTP it our client’s server
Catsnake Film
100% (48)Projects Completed
10
Freelancers worked with
10
Projects awarded
42%
Last project
20 Apr 2022
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies