Google Form and Sheet for Order Management

Job ID: 38771152

Budget: $30 – $250 USD

I'm looking for an expert to create a Google Form for ordering physical goods. This form should be intricately linked to a Google Sheet for order tracking, which in turn links to another Google Sheet displaying live inventory.

Key requirements include:
- Google Form: Capturing customer information, product details, shipping information, and inventory status for each order.
- Google Sheets: One for order tracking and another for real-time inventory updates.

The ideal freelancer for this project should have:
- Proficient understanding of Google Forms and Google Sheets.
- Experience in developing systems for order management and inventory tracking.
- Ability to create real-time updates for inventory.

Please note that I need real-time inventory updates. Bids from those with prior relevant experience will be given priority.

The integration should have partial automation with some manual updates. Please set up email notifications for inventory alerts. Access to the Google Sheets should be view only for specified users. Please include custom reporting features in the Google Sheets for detailed analytics.