I already maintain a master Google Sheet that lists every new job. What I need now is an automated way to dispatch each job to a field technician without letting them edit the master directly. Instead, they should receive a clean form—built with Google Forms, AppSheet, or a custom Apps Script front-end—where they can: • enter the job description and pricing • upload before-and-after photos • sign electronically on a phone or tablet Once the tech submits the form, the workflow should: 1. Append the data to the existing master sheet in the correct row. 2. Create (or update) a dedicated Google Drive folder for that job and store the uploaded images there. 3. Generate a nicely formatted PDF or Google Doc summary—including the signature—and email it to our billing address. 4. Keep everything organised so invoicing can be triggered later from the same dataset. You’re free to choose the best approach inside Google Workspace as long as the final solution is smooth for the techs, keeps the master sheet protected, and leaves us with a complete, shareable job packet ready for billing.