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.
File Management Desktop Utility Category: C, Programming, C#, Data Science, Excel, HTML, Photoshop Coding, Power BI, Powerpoint, Python, Word Budget: ₹12500 - ₹37500 INR
21-Feb-2026 17:04 GMT
Sri Lankan Short-Form Video Editor Category: Adobe Premiere Pro, After Effects, Social Media Marketing, Video Editing, Video Post Editing, Video Production, Video Services, Videography Budget: $30 - $250 USD
21-Feb-2026 17:04 GMT
Scrape Specific Site Data Category: BeautifulSoup, Data Extraction, JavaScript, Python, Scrapy, Selenium, Software Architecture, Web Scraping Budget: ₹1500 - ₹12500 INR
Curated Midwest Public Safety Contacts Mark Schroeder Category: Data Analysis, Data Collection, Data Entry, Data Management, Database Development, Database Management, Excel, Research, Web Scraping, Web Search Budget: $10 - $30 USD
21-Feb-2026 17:01 GMT
Fine Dining WordPress Sites Category: Elementor, HTML, JavaScript, Page Speed Optimization, PHP, SEO, Web Security, Web Design, WooCommerce, WordPress Budget: €750 - €1500 EUR
21-Feb-2026 17:01 GMT
Bespoke CRM for Insurance Team Category: API Development, Cloud Computing, CRM, Database Design, Database Development, MySQL, PHP, Software Architecture, Software Development Budget: $5000 - $10000 CAD
Buy 100k-Member Facebook Group Category: Digital Marketing, Facebook Ads, Facebook API, Facebook Development, Facebook Marketing, Social Media Management, Social Media Marketing, Social Networking Budget: $10 - $11 USD
