AppSheet Automation for Google Sheets Update -- 2

I need an AppSheet automation set up to update a Google Sheet when items are purchased at a physical store.

The updates should include:
- Item list
- Average purchase price
- Stock levels

The automation should trigger updates when an item is bought.

Ideal skills and experience:
- Experience with AppSheet and Google Sheets integration
- Familiarity with automation tools
- Attention to detail