Automate Google Sheet Invoice Processing

I need assistance in creating automation workflows for a Google Sheet to streamline our billing process. The automation should handle various tasks related to invoice management and practitioner allocation.

Key Requirements:
- Import billing reports in .csv format into the Google Sheet.
- Calculate the total amount from all invoices.
- Count occurrences of a $300 fee.
- Count occurrences of a $185 fee when the appointment length is 40 minutes.
- Add a new column replicating the invoice column, replacing $330 with $320 and $185 with $180 for 40-minute appointments, with no indication needed for changes.
- Move appointments to separate tabs based on practitioner names, ensuring only their invoices with amended values are displayed.

Ideal Skills and Experience:
- Proficiency in Google Sheets and Google Apps Script for automation.
- Experience with data manipulation and formula creation in spreadsheets.
- Ability to work with CSV data import and processing.
- Strong attention to detail to ensure accurate calculations and data handling.

I'm looking for someone who can efficiently implement these workflows to enhance our billing operations.