Rent reminders and late notices

Every morning this reads your Rent sheet and looks at the rent that is not marked Paid. Tenants get a friendly reminder 3 days before the due date. Five days after the due date they get a late-rent notice, with your property manager copied so they can follow up.

The sheet needs the columns Tenant, Email, Unit, Rent due date, Amount and Status. Rows marked Paid are skipped, and on a day with nothing to send, nothing is sent.

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 3

Yes

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.Gmail

No

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