title: Export google spreadsheet to PDF, then save the PDF to drive with a specific name
body: <p>I'm a noob in need here I'm afraid, all the code I've found doesn't quite get the job done. Here's what I'm after:</p>
  
  <p>I need a script that, when run, exports the current sheet (not the whole workbook), in portrait and without gridlines, as a PDF, then saves the PDF to a specific file in google drive.</p>
  
  <p>That PDF needs to have a name derived from the values of certain cells in the sheet being exported.</p>
  
  <p>I've stumbled across bits and bobs of code but the only exporter that worked didn't allow for options to be set, and the solutions with a workaround (involving oauth) didn't work at all.</p>
  
  <p>I've tried this: <a href="https://gist.github.com/anonymous/4169590" rel="nofollow">https://gist.github.com/anonymous/4169590</a> with no luck.</p>