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!