在同一电子表格中处理多个Google Sheet onFormSubmit

 var formResponse = e.response;

 var itemResponses = formResponse.getItemResponses();

 // 处理表单提交的数据

 // ...

 // 将数据写入多个Google Sheet

 // ...

 var formResponse = e.response;

 var itemResponses = formResponse.getItemResponses();

 // 处理表单提交的数据

 // ...

 // 将数据写入多个Google Sheet

 var spreadsheet1 = SpreadsheetApp.openById('Spreadsheet1_ID');

 var sheet1 = spreadsheet1.getSheetByName('Sheet1');

 // 写入数据到Sheet1

 var spreadsheet2 = SpreadsheetApp.openById('Spreadsheet2_ID');

 var sheet2 = spreadsheet2.getSheetByName('Sheet2');

 // 写入数据到Sheet2

 // ...

 var formResponse = e.response;

 var itemResponses = formResponse.getItemResponses();

 // 处理表单提交的数据

 for (var i = 0; i < itemResponses.length; i++) {

   var question = itemResponses[i].getItem().getTitle();

   var answer = itemResponses[i].getResponse();

   // 处理每个问题和答案

   // ...

 }

 // 将数据写入多个Google Sheet

 var spreadsheet1 = SpreadsheetApp.openById('Spreadsheet1_ID');

 var sheet1 = spreadsheet1.getSheetByName('Sheet1');

 // 写入数据到Sheet1

 var spreadsheet2 = SpreadsheetApp.openById('Spreadsheet2_ID');

 var sheet2 = spreadsheet2.getSheetByName('Sheet2');

 // 写入数据到Sheet2

 // ...