Create a monthly speadsheet dump

Feature Requests
1

Hi there. Is there an idea how to make a dump of collected data in the spreadsheet to the new sheet or somewhere else and then clean rows once in the month.
I use it for monthly expenses tool so once in a month I need to grab all the data and save them. Then I need to have a virgin clear spreadsheet and app to fill it with new records in a new months.

2

Have you tried about Zapier Integration?
So you don’t need to worry about your data backup and you can clean your data sheet as you wish.
Please check at https://zapier.com/

3

it is too complicated to me to make it via zapier

1 Like
4

You can make it with a Script that takes all your data from row 2 to the last row, then append to the destination sheet, finally go back to the original sheet and clean all those rows.

1 Like
5

Could you please tell me more about that script?

6 
function TransferData() {
  
  //Get values from this week's submissions
  
  var sourceSS = SpreadsheetApp.getActive();
  var sourceSh = sourceSS.getSheetByName('Weekly Submission');
  var values = sourceSh.getRange('A2:J').getValues();
  
  //Copy this weeks submissions to Historical sheet
  
  var targetSS = SpreadsheetApp.openById("insert historical sheet ID here");
  var targetSh = targetSS.getSheetByName('Historical Data');
  var lastrow = targetSh.getLastRow();
  targetSh.getRange(lastrow + 1, 1, values.length, values[0].length).setValues(values);
  
  //Reset weekly submissions
  
  sourceSh.getRange('A2:J').clearContent();
7

Thank you for your reply. I do appreciate it. I will try to use that script. Thank you. :slight_smile:

1 Like
8

Do let me know if you run into any problems :wink:

1 Like