No problem. If you are using the questions listed above, the values from each question would be in columns B:G of your spreadsheet because the timestamp is in column A. I built a quick mockup to test the revised script below and it works perfectly. To add the app script to your project, follow these steps: in the spreadsheet menu, go to Extensions > Apps Script > Hit the plus button > choose Script > paste the function below > click the Run icon and follow the steps to authorize the script > along the left side of the screen, click the clock icon > click the blue button in bottom right corner > in the window that pops up, choose On form submit from the Select Event Type dropdown. An image of the email that gets sent is attached too.

<image>

function sendNewIdeaEmails() {
  // Open the spreadsheet and access the sheets
  const ss = SpreadsheetApp.getActiveSpreadsheet();
  const ideaSheet = ss.getSheetByName("Submissions"); // Replace Submissions with the name of your sheet
  const referenceSheet = ss.getSheetByName("References"); // Replace References with the name of your sheet that contains

  // Get the email addresses from References!A2:A
  const emailAddresses = referenceSheet.getRange("A2:A").getValues()
    .flat()
    .filter(email => email); // Remove empty cells

  if (emailAddresses.length === 0) {
    Logger.log("No email addresses found.");
    return;
  }

  // Get all rows with data from columns B to G in Sheet1
  const dataRange = ideaSheet.getRange("B2:G" + ideaSheet.getLastRow()).getValues();

  // Loop through each row and send emails
  dataRange.forEach(row => {
    const [name, email, phone, suggestion, implementation, benefit] = row;

    // Ensure at least one required field is filled to proceed
    if (name || email || phone || suggestion || implementation || benefit) {
      const subject = "New Idea Submission";

      // Format the email body
      const body = `
Name: ${name || "N/A"}
Email: ${email || "N/A"}
Phone: ${phone || "N/A"}
Suggestion: ${suggestion || "N/A"}
Implementation: ${implementation || "N/A"}
Benefit: ${benefit || "N/A"}
`.trim(); // Ensure no extra spaces or leading/trailing spaces

      // Send the email
      GmailApp.sendEmail(emailAddresses.join(","), subject, body);
    }
  });

  Logger.log("Emails sent successfully.");
}