Google-sheets – Google Form to a spreadsheet

You will need to use Google Apps Script and to use the old Google Forms as the new one doesn't include yet a way to add the following script.

To add the script,

1. Open the form in the form editor.
2. Go to Tools > Script Editor.
3. Paste the below code.
4. Save the project and give a name to it.
5. Run once time to authorize it.

Note: The original code included a line to add the link to edit the response. That line was converted to a comment to meet the requirements stated in the question.

// Adaptation from http://securitasdato.blogspot.mx/2014/11/sending-confirmation-emails-from-google.html

function setup() {

  /* First, delete all previous triggers */
  var triggers = ScriptApp.getProjectTriggers();

  for (var i in triggers) {
    ScriptApp.deleteTrigger(triggers[i]);
  }

  /* Then add a trigger to send an email on form submit */
  ScriptApp.newTrigger("sendConfirmationEmail")
  .forForm(FormApp.getActiveForm())
  .onFormSubmit()
  .create();
}

function sendConfirmationEmail(e) {
  // e is a Form Event object - see https://developers.google.com/apps-script/guides/triggers/events#google_forms_events

  // Edit this to set the subject line for the sent email
  var subject = "Registration Successful";

  // This will show up as the sender's name
  var sendername = "Your Name Goes Here";

  // This is the body of the registration confirmation message
  var message = "Thank you for registering.<br>We will be in touch.<br><br>";
  message += "Your form responses were:<br><br>";

  // response is a FormResponse - see https://developers.google.com/apps-script/reference/forms/form-response
  var response = e.response;

  var textbody, sendTo, bcc;

  // Get the script owner's email address, in order to bcc: them
  bcc = Session.getActiveUser().getEmail();

  // Now loop around, getting the item responses and writing them into the email message
  var itemResponses = response.getItemResponses();
  for (var i = 0; i < itemResponses.length; i++) {
    var itemResponse = itemResponses[i];
    message += itemResponse.getItem().getTitle() +": " + itemResponse.getResponse() + "<br>";
    // If this field is the email address, then use it to fill in the sendTo variable
    // (Optional) Check that your form item is named "Email Address" or edit to match
    if (itemResponse.getItem().getTitle() == "Email Address") {
      sendTo = itemResponse.getResponse();
    }else{
      // If the form don't ask the respondent email address use the following one
      sendTo = 'sendconfirmationemail@googlegroups.com'; //replace this email address by your own default email address.
    }
  }
 // The following line was commented in order to avoid to include the link to edit the response
  // message += "<br>If you wish to edit your response, please click on <a href="\""" +="" response.geteditresponseurl()="" "\"="">this link</a>.";
  message += "<br><br>";
  textbody = message.replace("<br>", "\n");

  GmailApp.sendEmail(sendTo, subject, textbody,
                       {bcc: bcc, name: sendername, htmlBody: message});
}

Reference

• Sending Confirmation Emails from Google Apps Forms

I know this answer is super-late, but I just found your question via google since I had the same thought. The answer is query parameters. According to this article about using merge tags in Mailchimp to auto-populate google forms, if you pass query parameters after the form URL in the format form.url?key=value, e.g.https://docs.google.com/forms/path/to/stub?<entry.###########>=<url-encoded prefill value>. After generating the form, inspect the field you want to prefill. Its name attribute will be in the format <entry.###########>, where .###########> is some long number. Fill in <url-encoded prefill value> with whatever you want to go into that form, as long as it is properly URL-encoded. Hope that helps anyone else with the same question as us.