Create, manage, email, and print professional catering quotes with a searchable menu picker, sequential quote IDs, and PDF email integration.
Google Apps ScriptGoogle SheetsWeb App
This is a Google Apps Script application. It runs inside Google Sheets and cannot be opened directly in a browser. Follow the setup steps below to deploy it to your Google account.
Features
Searchable, categorized menu item picker with live price display
Separate pickup and delivery pricing per item
Sequential quote IDs (Q-2026-0001, Q-2026-0002, …) that never repeat
Save & Email — generates a PDF and emails it in one click
Quote history with Edit & Reuse — originals are never modified
Fully customizable email subject and body templates
Optional BCC on every sent quote
Auto-cleanup deletes quotes older than 30 days
Logo upload and per-location store details in Settings
Setup Steps
Create a new Google Sheet and name it CFA Catering Quotes.
Open Extensions → Apps Script in the sheet.
Paste the contents of Code.gs into the default script file.
Create an HTML file named Index and paste the contents of Index.html.
Run initializeSheet once — this creates the Settings, Menu, Quotes, and Quote_Sequence tabs.
Add your menu items to the Menu tab (Category | Item Name | Pickup Price | Delivery Price).
Deploy: Deploy → New Deployment → Web App. Set access to your organization and copy the URL.
Set up a nightly cleanup trigger: add a Time-driven trigger for cleanOldQuotes to run daily at midnight.