Q: How do i paste into another file through app script I am using this code:
function copyInfo() {  
  var ss = SpreadsheetApp.getActiveSpreadsheet();  
  var copySheet = ss.getSheetByName("Product-analyse");  
  var pasteSheet = ss.getSheetByName("Blad18"); // get source range  
var source = copySheet.getRange(93,7,39,6);  // get destination range  
var destination = pasteSheet.getRange(pasteSheet.getLastRow()+1,1,39,6); // copy values to destination range  
source.copyTo(destination);  // clear source values
source.clearContent();
} 



*

*Now its pasting in "Blad18". Instead I want it to be pasted in another file.

*I tried adding {contentOnly: TRUE}. Though this didnt seem to work

I cannot figure this out unfortunately. Everything else is correctly set already.
Any help is greatly appreciated.
Updated script I am using:

function copyInfo() {  
  var ssSource = SpreadsheetApp.getActiveSpreadsheet();  
  var copySheet = ssSource.getSheetByName("Product-analyse"); 
  var ssPaste = SpreadsheetApp.openById("1qhnA8L3ZkU-iEyOJtszAC4OW58sg2TJZSa_rmN_EXBI"); // the id of the other spreadsheet
  var pasteSheet = ssPaste.getSheetByName("Submitted Data"); // get source range  
  var source = copySheet.getRange(93,7,39,6);  // get destination range  
  var destination = pasteSheet.getRange(pasteSheet.getLastRow()+1,1,39,6); // copy values to destination range  
  source.copyTo(destination);  // clear source values
  source.clearContent();
}


A: Try this:
function copyInfo() {
  var ss = SpreadsheetApp.getActive();
  var csh = ss.getSheetByName("Sheet0");
  var psh = ss.getSheetByName("Sheet1");
  const cshsr = 2;
  var crg = csh.getRange(cshsr, 1, csh.getLastRow() - cshsr + 1, csh.getLastColumn());
  var prg = psh.getRange(psh.getLastRow() + 1, 1); 
  crg.copyTo(prg); 
}


A: I believe what you want to do is copy from one spreadsheet file to another spreadsheet file.  Here is an example
function copyInfo() {  
  var ssSource = SpreadsheetApp.getActiveSpreadsheet();  
  var copySheet = ssSource.getSheetByName("Product-analyse"); 
  var ssPaste = SpreadsheetApp.openById("dfsfhsfhskfhaskjfhsjkfas"); // the id of the other spreadsheet
  var pasteSheet = ssPaste.getSheetByName("Blad18"); // get source range  
  var source = copySheet.getRange(93,7,39,6);  // get destination range  
  var destination = pasteSheet.getRange(pasteSheet.getLastRow()+1,1,39,6); // copy values to destination range  
  source.copyTo(destination);  // clear source values
  source.clearContent();
}

Reference

*

*SpreadsheetApp.openById()
