How to Use Google Sheets and Google Docs for Simple Document Generation

Sub GenerateDocsFromExcel()
    Dim ws As Worksheet
    Dim wdApp As Object 'Late‑bound Word.Application
    Dim wdDoc As Object 'Late‑bound Word.Document
    Dim tmplPath As String
    Dim outFolder As String
    Dim lastRow As Long, i As Long
    Dim placeholder As Variant
    Dim replaceVal As String

    Set ws = ThisWorkbook.Sheets("Data")
    tmplPath = "C:\Templates\ContractTemplate.docx"
    outFolder = "C:\GeneratedDocs\"
    lastRow = ws.Cells(ws.Rows.Count, "A").End(xlUp).Row

    Set wdApp = CreateObject("Word.Application")
    wdApp.Visible = False

    For i = 2 To lastRow 'Assume row 1 has headers
        Set wdDoc = wdApp.Documents.Open(tmplPath, ReadOnly:=True)
        For Each placeholder In ws.Rows(1).Cells
            replaceVal = ws.Cells(i, placeholder.Column).Value
            wdDoc.Content.Find.Execute FindText:="{{" & placeholder.Value & "}}", ReplaceWith:=replaceVal, Replace:=2
        Next placeholder
        wdDoc.SaveAs2 outFolder & "Contract_" & ws.Cells(i, 1).Value & ".docx"
        wdDoc.Close SaveChanges:=False
    Next i

    wdApp.Quit
    Set wdDoc = Nothing
    Set wdApp = Nothing
    MsgBox "Documents generated successfully.", vbInformation
End Sub

function generateDocs() {
  const SHEET_NAME = 'Data';
  const TEMPLATE_ID = 'YOUR_TEMPLATE_DOC_ID';
  const DEST_FOLDER_ID = 'YOUR_DESTINATION_FOLDER_ID';

  const ss = SpreadsheetApp.getActiveSpreadsheet();
  const sheet = ss.getSheetByName(SHEET_NAME);
  const data = sheet.getDataRange().getValues(); // 2‑dim array
  const headers = data[0];

  const destFolder = DriveApp.getFolderById(DEST_FOLDER_ID);

  for (let r = 1; r < data.length; r++) {
    const row = data[r];
    const copy = DriveApp.getFileById(TEMPLATE_ID).makeCopy(`Doc_${row[0]}`, destFolder);
    const doc = DocumentApp.openById(copy.getId());
    const body = doc.getBody();
    for (let c = 0; c < headers.length; c++) {
      const placeholder = `{{${headers[c]}}}`;
      body.replaceText(placeholder, row[c]);
    }
    doc.saveAndClose();
    // Optional PDF export and email
    // const pdf = DriveApp.getFileById(copy.getId()).getAs('application/pdf');
    // MailApp.sendEmail({to: row[2], subject: 'Your Document', attachments: [pdf]});
  }
  SpreadsheetApp.getUi().alert('All documents generated.');
}