Google Sheet Auto-PDF Script

I have designed a worksheet in Google Sheets that doubles as a pre-formatted form. My data-entry team must be able to type a new record’s demographic fields into a quick, user-friendly interface and, at the press of a button, have three things happen:

1. The data is appended to a master log sheet in the same file (one row per submission, no risk of overwriting).
2. The visual form sheet refreshes with the freshly entered values.
3. That completed form is instantly saved as a properly named PDF (same layout as the sheet) in a Drive folder and optionally opened for printing.

Everything has to run end-to-end in Google Apps Script, preferably exposed through a custom menu or sidebar so my team never sees the script itself. The script must work for any future rows we add and keep file names unique—date-time stamp plus one key field is fine.

Deliverables
• Clean, commented .gs file(s) ready to paste into the Script Editor
• Brief “How to install & use” doc (one page is enough)
• One short Loom or GIF demo showing the workflow from entry to PDF

Acceptance criteria
• No manual copying or formatting required once the user hits “Submit/Print”
• PDF output matches the current sheet’s print view exactly
• New submissions never overwrite existing rows
• Runs under the standard account permissions (no Admin console changes)

I will share a view-only link to the sheet layout once we agree to proceed. Show More