Lorixen.
EN

Creating Quote PDFs From a Google Sheets Template

Short answer: Keep the quote details in a Google Sheet (one row per quote), design the quote once as a Google Docs template with placeholders such as {{CLIENT}} and {{TOTAL}}, and use a short Apps Script (or a Make scenario) that copies the template, swaps in the row's values, exports a PDF into a Drive folder and writes the link back to the sheet. Let formulas in the sheet calculate subtotal, GST and total so the PDF never shows a figure someone typed by hand, and issue quote numbers from a single counter so two quotes never share a number. When you need accepted quotes to turn into invoices and payments automatically, that is the point to move to quoting software.

Set up the sheet

Create a spreadsheet with two tabs. Quotes, with one row per quote:

Column Example Notes
A Quote no. Q-1042 Filled by the script
B Date 19/11/2026
C Client Harbour View Cafe
D Client email accounts@example.com.au
E Site address 12 Example St, Newcastle
F Description Replace 6 m of guttering, supply and fit Use line breaks for several items
G Subtotal (ex GST) 1,250.00 Typed or summed from a line-items tab
H GST =ROUND(G2*0.1,2) Formula, never typed
I Total (inc GST) =G2+H2 Formula
J Valid until =B2+30 Formula
K PDF link Filled by the script

And Settings, holding the template Doc ID, the Drive folder ID and the last quote number used.

Australia's GST rate on taxable supplies is 10%, which is what the formula assumes. Whether each item is taxable, and what your documents must show, depends on your situation: a quote is not a tax invoice, but if you later issue invoices from the same data, check the ATO's tax invoice requirements. This is not tax advice; confirm with your accountant or BAS agent.

Design the Docs template

Make a Google Doc that looks exactly like your quote: logo, ABN, contact details, a table for the work description and totals, terms and a signature line. Wherever a value should appear, type a placeholder:

  • {{QUOTE_NO}}, {{DATE}}, {{VALID_UNTIL}}
  • {{CLIENT}}, {{SITE}}
  • {{DESCRIPTION}}
  • {{SUBTOTAL}}, {{GST}}, {{TOTAL}}

Keep placeholders as plain text in one run of formatting (do not bold half of a placeholder), or the replacement may not match. Copy the Doc's ID from its URL, the long string between /d/ and /edit, into the Settings tab.

Route 1: Apps Script inside the sheet

Open Extensions > Apps Script in the spreadsheet. This script creates a PDF for the row you have selected:

function createQuotePdf() {
  const ss = SpreadsheetApp.getActive();
  const quotes = ss.getSheetByName('Quotes');
  const settings = ss.getSheetByName('Settings');
  const row = quotes.getActiveCell().getRow();
  if (row < 2) throw new Error('Select a quote row first.');
  const v = quotes.getRange(row, 1, 1, 11).getDisplayValues()[0];

  const quoteNo = v[0] || nextQuoteNumber(settings);
  quotes.getRange(row, 1).setValue(quoteNo);

  const templateId = settings.getRange('B1').getValue();
  const folder = DriveApp.getFolderById(settings.getRange('B2').getValue());
  const fileName = quoteNo + ' ' + v[2] + ' ' + v[1].replace(/\//g, '-');
  const copy = DriveApp.getFileById(templateId).makeCopy(fileName, folder);

  const doc = DocumentApp.openById(copy.getId());
  const body = doc.getBody();
  const map = { QUOTE_NO: quoteNo, DATE: v[1], CLIENT: v[2], SITE: v[4],
    DESCRIPTION: v[5], SUBTOTAL: v[6], GST: v[7], TOTAL: v[8], VALID_UNTIL: v[9] };
  Object.keys(map).forEach(k => body.replaceText('\\{\\{' + k + '\\}\\}', map[k]));
  doc.saveAndClose();

  const pdf = folder.createFile(copy.getAs('application/pdf')).setName(fileName + '.pdf');
  copy.setTrashed(true);
  quotes.getRange(row, 11).setValue(pdf.getUrl());
}

Notes on the choices:

  • getDisplayValues() takes values exactly as formatted in the sheet, so currency and dates appear as you see them, not as raw numbers.
  • replaceText uses regular expressions, which is why the braces are escaped.
  • The intermediate Doc copy is moved to the bin after export, leaving only the PDF in the folder. Remove that line if you prefer to keep an editable copy.

The DocumentApp reference lists other options, such as replacing a placeholder with a table for itemised lines.

To make it a button, add a custom menu with an onOpen function that calls SpreadsheetApp.getUi().createMenu('Quotes').addItem('Create PDF for selected row', 'createQuotePdf').addToUi().

A quote number sequence that cannot collide

Numbers typed by hand eventually repeat or skip. Let one function issue them, with a lock so two people clicking at once cannot get the same number:

function nextQuoteNumber(settings) {
  const lock = LockService.getDocumentLock();
  lock.waitLock(10000);
  try {
    const cell = settings.getRange('B3');
    const next = Number(cell.getValue()) + 1;
    cell.setValue(next);
    return 'Q-' + next;
  } finally {
    lock.releaseLock();
  }
}

Start the counter at whatever number follows your last paper quote. Never reuse a number for a revised quote; use a suffix such as Q-1042-R1 so the history stays clear.

Route 2: Make instead of code

If you prefer no code, a Make scenario does the same job: a Google Sheets > Watch rows trigger (or a checkbox column you tick), Google Docs > Create a document from a template with the placeholders mapped, Google Drive > Download a file converted to PDF, then Update a row to write the link back. Make's template module uses the same {{placeholder}} style. It costs operations on your Make plan for every quote, while Apps Script runs within your Google account's quotas.

File naming and emailing

A consistent name such as Q-1042 Harbour View Cafe 19-11-2026.pdf makes quotes easy to find in Drive search and in the client's inbox. Keep all PDFs in one folder per year. To email from the sheet, add MailApp.sendEmail with the PDF as an attachment, or simply open the link and attach it manually after a last check; for quotes, a human glance before sending is often worth keeping.

When to move to quoting software

The sheet approach works well for a sole trader or small team sending a handful of quotes a week. Consider dedicated quoting or job management software when:

  • accepted quotes need converting into invoices and syncing with Xero or MYOB;
  • clients should accept and sign online;
  • several staff create quotes and you need approval steps;
  • you want follow-up reminders on unanswered quotes.

FAQ

Can the template show several line items?

Yes. Either put line items in one description cell with line breaks, or keep a separate line-items tab and have the script build a table in the Doc. The second takes more code but looks cleaner.

Why are my totals showing many decimal places?

Format the sheet columns as currency and use getDisplayValues(), as in the script, so the formatted value reaches the PDF.

Who can see the PDFs in Drive?

Whoever has access to the folder. Keep it shared only with staff, and share individual PDFs with clients only if you send links rather than attachments.

If you would like this built around your existing quote design, show us a recent quote and we will turn it into a template that fills itself.

Sources

WhatsAppBook a call