Emails tenants a reminder 3 days before rent is due and a late notice 5 days after, copying the property manager.
Uses
Gmail
Google Sheets
Rent reminders and late notices
Run every day at 09:00.Run every day at 09:00.
Rent sheetSet rentSheet to blank.Property manager's emailSet managerEmail to blank.Unpaid rent due in 3 days or 5 days lateRead the rows of rentSheet. Save it as rent_due.Google Sheets
For each tenant in rent_due.rows:For each tenant in rent_due.rows:
If tenant.days_until is 3If tenant.days_until is 3Yes
Remind the tenant that rent is coming dueSend an email to tenant.Email. Save it as reminder.
Subject: Rent reminder for unit tenant.UnitHi tenant.Tenant,
A friendly reminder that your rent of tenant.Amount for unit tenant.Unit is due on tenant.date_display.
If you have already paid, thank you and please ignore this note.GmailNo
Tell the tenant their rent is late, copying the managerSend an email to tenant.Email. Save it as late_notice.
Subject: Late rent notice for unit tenant.Unit
CC: managerEmailHi tenant.Tenant,
Our records show that your rent of tenant.Amount for unit tenant.Unit, due on tenant.date_display, has not been received. Please pay as soon as you can, or reply to this email if there is a problem so we can help.Gmail