Google Sheets Stockout Automation

I need a Google Sheets integration for a stockout process. This will involve creating an outward form for stock entries to generate a packing list.

Requirements:
- Stockout form to include essential stock details.
- Packing list format: Google Sheets
- Stockout data entry: Automated via script
- Customer details get captured from customer database
- Rates are taken from the corresponding price luist

Ideal Skills:
- Google Sheets expertise
- Scripting experience (e.g., Google Apps Script)
- Familiarity with inventory management processes