Description: We are looking for an experienced Google Sheets expert and Google Apps Script developer to build a property management system for our letting agency. The system should automate key property management processes, including rent collection, tenant communications, maintenance task management, and compliance tracking. Key Responsibilities: Set up Google Sheets for Property Management: Create separate sheets for tracking properties, tenants, rent payments, maintenance tasks, and compliance. Set up data validation for fields like task status (Pending, In Progress, Completed), rent payment status, and compliance status. Google Forms Integration: Create Google Forms to collect tenant applications and maintenance requests, automatically populating the data into the relevant Google Sheets. Automate Processes with Google Apps Script: Rent Payment Reminders: Automate email reminders for overdue rents and upcoming payments. Maintenance Task Automation: Automatically create tasks, assign them to contractors, and track progress. Certificate Expiry Automation: Automate certificate expiry alerts (e.g., EPC, Gas, EICR). Automated Communication: Create email templates for various processes such as tenant application confirmation, maintenance request updates, and rent reminders. Scripts will be provided. Reporting and Dashboards: Set up dashboard views to track key metrics (e.g., overdue rents, pending maintenance tasks, upcoming certificate renewals). Automate the creation of reports and send them periodically to stakeholders (agents, landlords). Testing & Validation: Ensure that all automation works seamlessly (e.g., email triggers, task creation, compliance tracking). Test the system end-to-end and provide guidance on system usage. A comprehensive list of testing requirements will be provided Skills and Experience Required: Advanced Google Sheets expertise: You must be highly proficient in Google Sheets, including formulas, data validation, conditional formatting, and VLOOKUPs. Google Apps Script expertise: Proven experience in writing Google Apps Script to automate workflows and email communication. Property Management Systems: Knowledge of property management tasks such as rent tracking, maintenance management, and tenant communication is a plus. Attention to Detail: Accuracy is key for automating financial data, task management, and compliance tracking. Communication: Must communicate effectively to ensure all features are implemented according to requirements and are working properly. Ability to Deliver on Time: Experience delivering functional systems with automated processes in a timely manner. What You Will Deliver: A Google Sheets-based property management system with automated workflows, reminders, and communication features. Google Apps Scripts for automating tasks such as rent reminders, maintenance tracking, and compliance monitoring. Reports and dashboards with automated data collection, tracking, and reporting features. A fully functional system that will significantly reduce manual effort in managing properties, tenants, maintenance, and compliance. Expected Timeline for Delivery: 4-5 weeks depending on the complexity of the features and automation. The setup should be complete in this time, including testing and refining the system for real-world use. Required Experience: Google Sheets: Advanced knowledge of data management and automation. Google Apps Script: Experience automating tasks and email communications in Google Sheets. Property Management Software: Familiarity with property management workflows (e.g., rent tracking, tenant communication, and maintenance task management).
How to Apply: Please provide:
Examples of previous work you’ve done with Google Sheets and Google Apps Script.
Estimated time frame to complete the project based on the description above.
Any questions or clarifications you have regarding the project.
Your hourly rate or a project price.
Why This Role is Important: This project will help streamline property management operations, reduce human errors, and ensure compliance in a more efficient manner. By automating routine tasks, the system will save time and improve the service provided to tenants and landlords alike.
Closing Thoughts: If you're skilled in Google Sheets and Google Apps Script, and have experience creating automated systems, this is an exciting opportunity to build a unique, valuable property management system for a growing letting agency. We look forward to working with a professional who can help us create this system and add automation to simplify our workflows. Final Notes: Simple, clear instructions will be provided for you to integrate the system. Collaboration with our team will ensure all required features are added and automated correctly. regular video calls will be required showing updates of work. samples of work must also be provided. there are approximately 20 sheets to set up. see attached.
