Script to append data from local (Linux) csv file to Google Sheet, then rename csv file
Budget: $10 – $30 USD
Please read this carefully. We will select someone tomorrow.
The project description is as follows. How would you solve this and how long will it take?
Project Description
Local data is collected and appended to a local csv file that has a fixed name. (This is not part of the project. It's already happening.)
This data should be appended to an existing Google Sheet every 10 minutes (always the same sheet). Note - appended at the bottom, not replaced!
Then the local csv file should be renamed by adding a a timestamp to its filename; the original csv file will be recreated as soon as the next line of data is generated.
Part 1: Google Sheet script loads the csv and appends it to the Google Sheet.
Part 2: The local csv file is immediately renamed with a timestamp (maybe Google should call the csv file via a local script that reads the csv file, provides it to Google and then renames it)
(You must have your own server and Google Sheet for testing and development; you can generate a csv file where random data gets added every few minutes.)
The project description is as follows. How would you solve this and how long will it take?
Project Description
Local data is collected and appended to a local csv file that has a fixed name. (This is not part of the project. It's already happening.)
This data should be appended to an existing Google Sheet every 10 minutes (always the same sheet). Note - appended at the bottom, not replaced!
Then the local csv file should be renamed by adding a a timestamp to its filename; the original csv file will be recreated as soon as the next line of data is generated.
Part 1: Google Sheet script loads the csv and appends it to the Google Sheet.
Part 2: The local csv file is immediately renamed with a timestamp (maybe Google should call the csv file via a local script that reads the csv file, provides it to Google and then renames it)
(You must have your own server and Google Sheet for testing and development; you can generate a csv file where random data gets added every few minutes.)