I am having trouble understanding how to take data logged to the SD card (say, every 5 minutes) and then periodical send the new data to a google spreadsheet (every hour).
The SD card example shows appending a file, I was thinking that I would have to keep a variable of the first line number that was appended after the last write to google Spreadsheet and go through a loop that reads from SD and writes to google until the data aren't available in the SD file.
Alternatively, I thought to create a new file on the card after the upload, so there would be 24 files per day in my example above.
I am looking for something pretty easy. I even thought to just upload the data to dropbox but I still run into the same problem. Imagine uploading a file that is growing bigger and bigger to overwrite the old one each time. That seems very inefficient.
Full disclosure: Any help with or without code is So very appreciated. This is for a research project I am doing as a (non-Federal) postdoc at the EPA. I will reference any help I receive from the community here. - Thank you.