https://www.labnol.org/code/google-forms-response-sheet-210429
function getResponseSheetForGoogleForm() {
const formId = "<<Google Form Id>>";
// Open an existing Google Form by Id
const form = FormApp.openById(formId);
// Are the form responses stored in Google Sheets
const destinationType = form.getDestinationType();
if (destinationType !== FormApp.DestinationType.SPREADSHEET) {
Logger.log("This form is not saving responses in Google Sheets");
} else {
// Get the Id of the response spreadsheet
const destinationId = form.getDestinationId();
// Open the Google Workbook and iterate through each sheet
const formSpreadsheet = SpreadsheetApp.openById(destinationId);
const [formSheet] = formSpreadsheet.getSheets().filter((sheet) => {
// Returns the URL of the associated Google form
// that is sending its user responses to this sheet
const associatedFormUrl = sheet.getFormUrl();
return associatedFormUrl && associatedFormUrl.indexOf(formId) !== -1;
});
Logger.log(`The form responses are stored in ${formSheet.getName()}`);
}
}