Write script in Google Sheets to pull data from either csv url, RSS Feed or FTP Feed
Budget: $15 – $25 USD
Background - I sell on Ebay, FB Shops and other marketplaces. The items i sell are supplied by wholesalers through csv of ftp files. I am aiming at setting up data files in google sheets to store and dessiminate selected portions of this data to respective marketplaces.
(1) Design sheet to pull data from suppliers data feed which may be in the form of a CSV URL, RSS FEED or FTP FEED.
(2) Data to be pulled on a set automatic schedule eg Hourly, Daily, Weekly.
(3)Map the "pulled data" to secondary sheet(s) (headers are different)
(4) Use checkbox at the start of each row to send data or remove data from the secondary sheet.
(5) Set up standaridized data in secondary sheet where info is not available from main sheet.
(6) The layout of the sheet is already created with a script but will need modifying or correcting
(7) As the design develops their may be need to add additional work requirements.
(8) Work will need to progress over a few weeks to accomodate budget.
(9) A Dashboard will need to be developed further in the project.
(1) Design sheet to pull data from suppliers data feed which may be in the form of a CSV URL, RSS FEED or FTP FEED.
(2) Data to be pulled on a set automatic schedule eg Hourly, Daily, Weekly.
(3)Map the "pulled data" to secondary sheet(s) (headers are different)
(4) Use checkbox at the start of each row to send data or remove data from the secondary sheet.
(5) Set up standaridized data in secondary sheet where info is not available from main sheet.
(6) The layout of the sheet is already created with a script but will need modifying or correcting
(7) As the design develops their may be need to add additional work requirements.
(8) Work will need to progress over a few weeks to accomodate budget.
(9) A Dashboard will need to be developed further in the project.