Create a Google Doc from each Sheet row

1 · Prepare

Put these pieces in place

• Create a Sheet tab named Projects.
• Put a person or project name in column A, a note in column B, and leave column C for the document link.
• Use short notes that you are comfortable placing in a new Google Doc. Run with one operator and do not edit or reorder the rows during execution.

2 · Review before running

What the script can access and change

3 · Copy

Paste this into the Apps Script editor

Create or open a script file, replace the example values marked above, then save the project.

function createDocsFromSheetRows() {
  const sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Projects');
  if (!sheet) throw new Error('Add a Sheet tab named Projects before running this function.');

  const firstDataRow = 2;
  const lastRow = sheet.getLastRow();
  if (lastRow < firstDataRow) return;

  const rows = sheet.getRange(firstDataRow, 1, lastRow - firstDataRow + 1, 3).getValues();
  rows.forEach((row, index) => {
    const [name, note, documentUrl] = row;
    if (!name || documentUrl) return;

    const document = DocumentApp.create(String(name) + ' project note');
    document.getBody().appendParagraph('Project note for ' + name);
    document.getBody().appendParagraph(String(note || 'No note was entered.'));
    document.saveAndClose();
    sheet.getRange(firstDataRow + index, 3).setValue(document.getUrl());
  });
}

4 · Run safely

Follow these steps in order

1. Prepare one test row

   Use the first row for headers. Add one row below it with a sample name and a short note; leave column C empty.

2. Add the script

   Open Extensions, choose Apps Script, paste the function, and save it.

3. Create and inspect the Doc

   Run createDocsFromSheetRows. Open the link in column C and inspect its text before adding more rows. Wait for each run to finish; after a failure, reconcile unlinked rows in Drive before rerunning.

5 · Confirm

How to tell it worked

Each unfinished row gets a new document link in column C, and running the function again leaves linked rows alone.

If the result is different

Troubleshooting

Nothing was created.

Check that the tab is named Projects and that at least one row has a name with an empty column C.

The same person needs a second document.

Clear the link cell for that row only when you intentionally want another document.

The run failed before a document link appeared.

Stop before rerunning. Search Drive for the row name and project note title, then inspect the document contents and creation time. Restore its link only if the document is complete; repair an incomplete document by hand. If several files match or the outcome is unclear, resolve that ambiguity first. File names are not unique, and overlapping runs can create duplicates.