Autofill Google Docs in 1-Click with 100% Free Apps Script Code

function onOpen() {
  const ui = SpreadsheetApp.getUi();
  ui.createMenu("OutrightStore")
    .addItem('Show Sidebar', 'showSidebar')
    .addToUi();

  // Automatically show sidebar when the spreadsheet is opened
  showSidebar();
}

// Function to create and display a custom sidebar
function showSidebar() {
  var html = HtmlService.createHtmlOutputFromFile('Sidebar4')
    .setTitle('Sidebar Form')
    .setWidth(300);
  SpreadsheetApp.getUi().showSidebar(html);
}

// Function to create headers dynamically from a form input
function createHeadersFromForm(headers) {
  const sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  const headerArray = headers.split(",");

  // Set headers in the first row
  sheet.getRange(1, 1, 1, headerArray.length).setValues([headerArray]);

  // Apply formatting
  const headerRange = sheet.getRange(1, 1, 1, headerArray.length);
  headerRange.setFontWeight("bold");
  headerRange.setFontSize(14);
}

// Function to generate documents from sheet data using a template
function createDocumentsFromSheet(templateFileId) {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheetByName("Sheet1"); // Replace with your sheet name
  var dataRange = sheet.getDataRange();
  var dataValues = dataRange.getValues();

  // Placeholders from the first row
  var placeholders = dataValues[0];

  // Template document
  var templateDoc = DriveApp.getFileById(templateFileId);
  var templateName = templateDoc.getName();

  // Create folder to store generated documents
  var folder = DriveApp.createFolder("Generated Documents");

  // Loop through rows, starting from row 2
  for (var i = 1; i < dataValues.length; i++) {
    var row = dataValues[i];

    // Make a copy of the template
    var templateCopy = templateDoc.makeCopy(folder);
    var doc = DocumentApp.openById(templateCopy.getId());
    var body = doc.getBody();

    // Replace placeholders with row data
    for (var j = 0; j < placeholders.length; j++) {
      var placeholder = "{{" + placeholders[j] + "}}";
      var value = row[j];

      // Format dates
      if (value instanceof Date) {
        value = Utilities.formatDate(value, Session.getScriptTimeZone(), "dd/MM/yyyy");
      }

      body.replaceText(placeholder, value);
    }

    doc.saveAndClose();

    // Rename the copied file
    var copiedFile = DriveApp.getFileById(templateCopy.getId());
    copiedFile.setName(templateName + " - Row " + i);

    // Send PDF via email
    var email = row[2]; // Assuming Email is in column C (index 2)
    if (email) {
      var subject = "Generated Document from " + templateName;
      var mailBody = "Please find the generated document attached.";
      MailApp.sendEmail(email, subject, mailBody, {
        attachments: [copiedFile.getAs(MimeType.PDF)]
      });
    }
  }

  Logger.log("Generated documents folder URL: " + folder.getUrl());
}