Quick Google Sheets Data Import Automation & Video Overview (Time-Sensitive - 2-Day Turnaround)

---

---

Overview: We need a Google Sheets expert for a time-sensitive project to efficiently automate the import of specific data fields (starting with student birthdates/DOBs) from several Google Sheets into our central Masterlist. Beyond the DOBs, we require a clear explanatory screen recording (e.g., 5-minute Loom video) and brief reference notes empowering our team to replicate the core logic for 1-2 other similar, straightforward data fields. Solution via native Google Sheets formulas or lightweight, well-documented Apps Script. Project must be completed by EOD Friday, May 30th, 2025 (EST). Background: - Masterlist contains ~1,200 student records. - Source files: "Student Name" and "DOB" columns. - Data complexities: students appear multiple times in/across files; DOBs may not match or be consistently formatted. What We Need Delivered (Focus on DOBs as primary example): - Automated DOB Import (robust to column moves in Masterlist). - Duplicate Row Handling (duplicates in Masterlist preserved). - DOB Conflict Flagging. - Extensible Methodology (for team to adapt for 1-2 other simple fields). - Low Maintenance & In-House Control (Formula-preferred, lightweight script acceptable. Important: No third-party add-ons). Deliverables: - Functional Google Sheets Masterlist (automated DOB import, conflict flag). - Brief, essential written notes OR well-commented script/formula for key maintenance points (e.g., where to update source URLs, add new files). - Short (approx. 5-10 minute) screen recording (Loom video or similar) demonstrating the DOB setup, explaining maintenance, and clearly showing how our team can adapt the core logic for 1-2 other similar, straightforward data fields. - Availability for a brief follow-up Q&A call (15-30 minutes), if needed by our team after reviewing all delivered materials. Required Skills & Experience: - Advanced Google Sheets formulas & troubleshooting. - Google Apps Script (if proposing). - Data cleaning. - Clear communication in English & ability to explain technical solutions simply to non-technical users. Security & Access: - Temporary view/edit access to the live Masterlist & 3 sample live source spreadsheets. - NDA required. Project Terms & Timeline: - Project Type: Fixed Price - DEADLINE: All deliverables due EOD Friday, May 30th, 2025 (EST). Project must start immediately upon hiring (by Wednesday, May 28th). - Our Estimated Effort: We anticipate this requires 2-3 hours of focused expert work for all deliverables. - Budget Consideration: Non-profit registered charity seeking efficient, cost-effective solution. Future Opportunities: Beyond this initial fixed-price project, we are also looking to identify a reliable Google Sheets expert for potential ongoing hourly support for similar small-scale spreadsheet tasks or adjustments as needed in the future. How to Apply: Please include: - Example of similar Google Sheets automation/training project. - Your proposed approach (Formulas/Script) & rationale. - Explicit confirmation you can meet our FIRM May 30th deadline. - Your fixed-price bid. - Your hourly rate for ongoing similar small-scale spreadsheet tasks or adjustments as needed in the future. -------- We need a responsive Google Sheets pro for a quick, effective solution and team empowerment!

Keyword: Software Development

Price: $60.0

Google Apps Script Automation Data Extraction Task Automation Google Sheets Automation Spreadsheet Automation Google Workspace Google Docs Google Sheets