Hello everyone,
I have a property work for a management company with 120 units. I need help on creating a zap to do the below task to make things easier on the company.
We have a google spreadsheet with 120 rows, Column A has the property address and column C has the date of expiration for the rental license, column D has the landlords email address. I need a zap that can examine column C everyday to see if a rental license is going to expire in exactly 45 days no more no less. If the zap finds there's a date in column C that is 45 days away, I would like a gmail sent only to that landlord in column D matching the property/expiration date saying something like this “hello, this is a reminder that your rental license for (insert property address from column A and whatever row aligns with what zap pulled from column C) on (insert the expiration date from column C) I have CC’d the inspector on here who can preform an inspection and renew the license. Please let me know how you would like to proceed and I can coordinate with the tenant if it's occupied. Thank you”
I can't figure out how to build this and would appreciate any help, thank you!
