G-Stack Proposal Command

Google Apps Script proposal automation for repeatable client delivery

What this is

G-Stack Proposal Command is a Google Apps Script automation module that generates branded proposal documents from structured intake data. It standardizes proposal assembly, PDF export, and outbound delivery so teams can respond faster with consistent output quality.

What it does

• Captures and validates proposal intake fields from a Google Form.
• Maps service types to the correct proposal template.
• Generates a document, exports to PDF, and sends via Gmail.
• Logs proposal records and status in a tracking spreadsheet.
• Provides setup/test helpers for bootstrap and verification.

How it works

Google Form Submit
        |
        v
onFormSubmit(e)
        |
        v
parse + validate response
        |
        v
select template by service type
        |
        v
generate document -> export PDF
        |
        +------> send proposal email
        |
        +------> write tracking row

Quick start

# 1) Install clasp and authenticate
npm install -g @google/clasp
clasp login

# 2) Create your own script project and set local .clasp.json
clasp create --type standalone --title "G-Stack Proposal Command"

# 3) Push project files
clasp push

# 4) Open Apps Script IDE and run bootstrap
clasp open
# run setupProposalGenerator() in Apps Script editor

Project structure

g-stack-proposal-command/
├── appsscript.json
├── config.js
├── proposal-generator.js
├── setup.js
├── utils.js
├── Dashboard.html
├── templates/
│   ├── email-template.html
│   ├── proposal-document-outline.md
│   └── proposal-form-structure.json
├── docs/
│   ├── SETUP-GUIDE.md
│   ├── installation-guide.md
│   └── user-guide.md
├── TestRunner.gs
└── Tests.gs

License

MIT. See LICENSE.

Built by

Jacob Johnston | True North Data Strategies LLC | SDVOSB