How do I SIMPLY connect google docs and google sheets?

Question

myFunction(e){
var Name = e.values[1];
DocumentApp.create("Test");
DocumentApp.appendParagraph("hello" + Name);
DocumentApp.saveAndClose;
}

This is how simple I want it. "Name" is pulled from a sheet that is generated from a form and "Name" is inputted after form generates its data, upon edit

---

1. I am brand new to this. I mimicked the auto responder for when you get a form response, and "myFunction(e)" was name of function.
2. I would think bound to spreadsheet. Path from beginning to end: input data to form>collect data on spreadsheet>edit spreadsheet, add more data>create simple letter using most of data collected. Sample letter

DocumentApp....appendParagragh("dear " + Name + "\n\n I like your " + Product + ". Are you interested in selling?").

There is an error related to "var Name = e.values[1];"

"TypeError: Cannot read property "values" from undefined. (line 2, file "Code")"

Answer 1

The error that you are getting occurred because you tried to run your function using the Run button on the Google Apps Script editor as the function has e as parameter but it only gets an object automatically when it's called from a trigger.

A couple of related Q&A

• How can I test a trigger function in GAS?
• Getting TypeError in onFormSubmit trigger?
• How do I resolve this "TypeError: Cannot read property "values" from undefined. (line 2, file "Code")" based on the context below?

---

In order to get a value from a spreadsheet by using Google Apps Script we could use Class SpreadsheetApp. Example

The following script works on a bounded to spreadsheet script project.

function getName(){
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheetByName('Sheet1');
  var range = sheet.getRange('A1');
  var name = range.getValue();
  Logger.log(name);
}