function onOpen() {
  var ui = SpreadsheetApp.getUi();
  ui.createMenu('PandaDoc')
  .addItem('Create Document', 'createSampleDocuments')
  .addToUi();  
}

function createSampleDocuments() {
  
  
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Setup");
  var data = sheet.getDataRange().getValues();
  
  var payload = {};
  payload.name = sheet.getRange('B5').getValue();
  payload.template_uuid = sheet.getRange('B3').getValue();
  
  
  //we are only collecting one recipient on the sheet but it can easily be extended
  //by adding another recipient object into the array
  var recipient = {};
  recipient.email = sheet.getRange('E2').getValue();
  recipient.first_name = sheet.getRange('E3').getValue();
  recipient.last_name = sheet.getRange('E4').getValue();
  recipient.role = sheet.getRange('E5').getValue();
  payload.recipients = [];
  
  if ( recipient.email != "" ) 
  {
    payload.recipients.push(recipient);
  }
  
  
  //build tokens array from provided fields 
  payload.tokens = [];
  
  for(var n=1;n < data.length;++n)
  {
    var token = {};
    if(data[n][5])
    {
      token.name = data[n][5]; 
      token.value = data[n][6];
      payload.tokens.push(token);
    }
  }
  
  //build pricing table array from products list
  payload.pricing_tables = [];
 
  var pt = {};
  pt.name = "PricingTable1"; //This is default name for first pricing table. If you want to save products to a different table you will have to change this!
  pt.options = {currency:"USD"};
  pt.sections = []; // you can have mutliple sections. We are just using one.
  
  var section = {};
  section.title = "Sample Section";
  section["default"] = true; //first section in table Title is not displayed
  section.rows = [];

  
  // Need to get row data from sheet data starts at row 15 COl a-e
  var productSheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Products");
  var products = productSheet.getRange(1, 1, productSheet.getLastRow(),4).getValues();
  
  for(var n=1;n < products.length;++n)
  {
    var row = {};
    row.data ={};
    if(products[n][0])
    {
      row.data.name = products[n][0]; 
      row.data.descripiton = products[n][1];
      row.data.price = products[n][2];
      row.data.qty = products[n][3];
      row.options = {}; // Options object is required
      section.rows.push(row);
    }
  }
  
  // Add section to sections array
  pt.sections.push(section);
  
  //add pricing table objec to pricing table array
  payload.pricing_tables.push(pt);
  
  var access_token = sheet.getRange('B2').getValue();
  
  var createOptions = {
    'method': 'post',
    'headers': {
      'Authorization': 'Bearer ' + access_token,
      'Content-Type': 'application/json;charset=UTF-8'
    },
    'payload': JSON.stringify(payload)
  };
  
  var response = UrlFetchApp.fetch( "https://api.pandadoc.com/public/v1/documents", createOptions);
  var responseJson = JSON.parse(response);
  
  sheet.getRange('B8').setValue("https://app.pandadoc.com/a/#/document/v1/editor/"+ responseJson.id);
  sheet.getRange('B9').setValue(responseJson.id);
  sheet.getRange('B10').setValue(responseJson.name);
  sheet.getRange('B11').setValue(responseJson.date_created);
  
}