Expert Google Sheets Developer: Automated Real Estate "200-Step" Project Tracker

UpworkUSNot specifiedexpertScore: 72
Google SheetsGoogle Apps ScriptJavaScriptAutomationAPI
I have an existing "200-step" home-buying spreadsheet that is about 90% of the way there. I need a pro spreadsheet designer and project manager to turn this into a high-end, automated, and user-friendly "RASCI" style dashboard. The goal is to provide my clients (Buyers) with a foolproof roadmap where they can assign tasks, see automated deadlines, and trigger actions with a single click. Key Features to Build: -Dynamic RASCI Header: The spreadsheet must feature column headers for "Buyer 1," "Buyer 2," and "Trusted Friend/Family." Tasks should be assignable to these roles with clear accountability. -Automated Date Logic (Dependencies): * At the top of the sheet, buyers will input a "Target Move-in Date" and "Target Location." -The spreadsheet should automatically calculate and "flow" proposed deadlines for all 200 steps based on these inputs. -When a task is marked "Done," subsequent task dates should dynamically shift or confirm based on real-time progress. -One-Click Email Automation (Google Apps Script): * For specific tasks (e.g., "Find a home inspector"), I want a button or checkbox that automatically drafts an email in the user’s Gmail. -The draft should pre-populate with specific details like the "Target Location" and the request for a recommendation, addressed to me. -UX/UI Cleanup: The sheet needs to look professional, intuitive, and non-intimidating. This includes frozen headers, conditional formatting for "Overdue" or "Current" tasks, and a clean "Start Here" input section. Technical Requirements: -Advanced Google Apps Script (for the email drafting and complex date triggers). -Expert-level Conditional Formatting and Data Validation. -Experience in Project Management workflows (Gantt logic, dependencies, and RASCI/RACI matrices). -Strong UI/UX eye—the final product should feel like an "app," not a messy data table. Deliverables: -Review of current "200-step" sheet. -Implementation of the automated date engine. -Setup of the RASCI assignment system. -Integration of the "One-Click" email draft scripts. -A brief loom video or document explaining how to maintain/update the logic. To Apply: Please share 1–2 examples of complex Google Sheets you have built that involve Google Apps Script or Automated Project Management. If you have experience in Real Estate workflows, that is a huge plus. Share your proposal for this project. Please address the following:" -Fixed Price per Milestone: What is your estimated cost for each of the three milestones listed above? -Timeline: How many days/weeks do you estimate for the full 200-step build? -Communication: Will you provide a brief screen-recording (Loom) at the end of each milestone to show how the logic works?
View Original Listing
Unlock AI Intelligence, score breakdowns, and real-time alerts
Upgrade to Pro — $29.99/mo

Client

Spent: $102,852.27Rating: 4.8Verified