Automation Expert Needed – Data Pipeline for Multi-Teacher Class Logging & Payment Tracking

I run an online educational academy with a pool of teachers assigned to students. Class logging and payment tracking are currently done manually across separate Google Sheets I need someone to build an automated data pipeline within Google Sheets (no external software) that handles data extraction, transformation, and syncing across sheets, so that: When I assign a student to a teacher, that data flows automatically into the teacher's workbook. As teachers log their classes, the data is automatically extracted and piped into a central progress tracker and a finance/payment sheet — no manual copying or re-entry. Teachers only see their own workbook; I have full visibility across the entire data flow from one place. Skills Needed: Experience with Google Sheets API, IMPORTRANGE, QUERY, and cross-sheet data architecture Google Sheets API, data extraction & cross-sheet data pipelines ETL-style logic (extract, transform, load) within Sheets Prior work on tutor/teacher management or payroll-tracking systems is a plus Deliverables: Fully working automated data pipeline connecting all sheets Short documentation or walkthrough on how to use/maintain it Testing with sample data to confirm the pipeline syncs correctly Please share relevant past work when applying.