Build Prefilled Form UrlA Google Form with fields you already know from a sheet row — name, email, client id — and a recipient who shouldn't have to retype them…
Fill Doc TemplateA Doc full of {{Client}} and {{Amount}} placeholders, a sheet row with those headers, and a Drive folder for the finished copies…
Fill Html TemplateBuilding approval emails and HtmlService notices by concatenating strings is how < in a client name becomes a broken page — or worse…
Escape HTML for HtmlServiceStuffing sheet values straight into HtmlService HTML is how < in a client name breaks the sidebar — or worse, opens an XSS footgun…