title: Generate Array from Google Spreadsheet Data
body: <p>I am trying to use the Google Apps Script API and generate an array from an existing document and the data inside it. I was able to generate one with data directly like this but I need to generate one dynamically from sheet data.</p>
  
  <pre><code>var myStringArray = ["Q #1","Q #2","Q #3"];
  </code></pre>
  
  <p>I tried this but failed...</p>
  
  <pre><code>var ss = SpreadsheetApp.openById('0AvDqITxPHOGndENaZGJRTEkyTk9OQ1lqZEdPcTVsZWc');
  var sheet = ss.getSheets()[0];
  var myStringArray = sheet.getRange('A1:A50');
  </code></pre>