Custom Sales Automation Google Sheet

Job ID: 37915231

Budget: $30 – $250 USD

I require a Google sheet to be built that operates as a sales automation tool.

Key Features:
- Capture and organize the following data: Customer names and Order quantities.
- Upon encountering a duplicate customer name, the system should automatically create a separate sheet for each customer as a way of managing duplicates.

Analytics:
- The Google sheet must be capable of producing specific sales analytics, especially a weekly sales summary, product-wise sales analysis, and an overview of top customers by sales.

Ideal Skills:
- Proficiency in Google Sheets and formulas
- Experience in sales data management and analysis
- Understanding of automation tools
Related categories: PHP Excel Google Adwords Google Analytics Google Sheets