Google Sheets → PDF Invoice & Certificate Generator (Apps Script)
A self-contained Google Apps Script that turns each spreadsheet row into a branded PDF — invoice, certificate, quote or receipt — saves it to Google Drive and (optionally) emails it to the recipient automatically.
What it does:
• One row → one branded PDF (company header, accent colour, itemised table, auto Subtotal / Tax / Total)
• Per-row Tax % with live Tax & Total formulas
• Per-row "buttons": tick ☑ Make PDF or ✉ Send Email to run a single row
• Generate / email all rows or just the selected rows
• Saves each PDF to Drive and writes the shareable link back to the sheet
• Fully configurable from a Settings tab (company, logo colour, currency, tax)
• Pure Apps Script — no add-ons, no third-party tools; runs inside the client's own Sheet
• Adapts to certificates, quotes and receipts by editing one HTML block
Built by Ozgur Denizlioglu — Google Sheets / Apps Script automation.