sheets2docs.gs

/**
 * Create a new document for every row in a spreadsheet. This code assumes that
 * the data is in the first sheet (workbook) in the spreadsheet and has the
 * columns "Title", "Content", and "Emails" in that order, with multiple email
 * addresses separated by a comma.
 */
function createDocsFromSpreadsheet() {
  // Open the spreadsheet and get the data.
  const ss = SpreadsheetApp.openByUrl('ENTER SPREADSHEET URL HERE');
  const sheet = ss.getSheets()[0];
  /** @type {string[][]} */
  const data = sheet.getDataRange().getValues();

  // Remove any frozen rows from the data, since they contain headers.
  data.splice(sheet.getFrozenRows());

  // Create a document for each row.
  data.forEach(function(row) {
    const title = row[0];
    const content = row[1];
    const emailsStr = row[2];

    // Split the emails into an array and remove extra whitespace.
    const emails = emailsStr.split(',').map(function(email) {
      return email.trim();
    });

    // Create the document, append the content, and share it out.
    const doc = DocumentApp.create(title);
    doc.getBody().appendParagraph(content);
    doc.addEditors(emails);
  });
}