1. Tweaks so far:
  2. in collectTweets:
  3. var targetsheet=ss.getSheetByName("Archive");
  4. ...
  5. setArchiveRowsData(targetsheet, data);// write results to Archive sheet
  6. New function:
  7. function setArchiveRowsData(sheet, objects) {
  8. var headersRange = sheet.getRange(1, 1, 1, sheet.getMaxColumns());
  9. var firstDataRowIndex = sheet.getLastRow() + 1;
  10. var headers = normalizeHeaders(headersRange.getValues()[0]);
  11. var data = [];
  12. var itemCount=0
  13. //add things to the archive sheet in chronological order
  14. for (var i = objects.length-1; i > 0; i--) {
  15. var values = []
  16. //we need logic here:
  17. //if the newly found tweet id is greater than id of last tweet (or timestamp greater?) in archive, add row
  18. if (true){
  19. itemCount++;
  20. for (j = 0; j < headers.length; ++j) {
  21. var header = headers[j];
  22. values.push(header.length > 0 && objects[i][header] ? objects[i][header] : "");
  23. }
  24. data.push(values);
  25. }
  26. }
  27. if (itemCount>0){
  28. var destinationRange = sheet.getRange(firstDataRowIndex, headersRange.getColumnIndex(),
  29. itemCount, headers.length);
  30. destinationRange.setValues(data);
  31. }
  32. }