Auto Send Reminder Emails from Google Sheets (Apps Script)

This is a Google Sheet that has Apps Script embedded to automatically send out reminder emails from Google Sheets. This use case template automatically sends email reminders to clients (or internal teams) based on how many days are left before a contract expires.

Key Features:

• ✅ Automatically checks all contracts in your sheet
• ✅ Sends HTML-formatted email reminder at key milestones: 30, 10, 3, and 1 day before expiration
• ✅ Sends emails to the contact listed in each row
• ✅ Logs every email sent into the next available "Reminder Sent" column

Versions:

1. Simple (from $0) : Send the same email content with dynamic contract name, client name and $ of days left

2. Enhanced (from $1): Send different email content for each reminder with dynamic contract name, client name and $ of days left

How to use:

1. After purchase, you will receive an email to view the product's content. If you're logged into Gumroad, you can find the contents in your Gumroad Library (https://app.gumroad.com/library).
2. Duplicate/make a copy of the Google Sheet, open the App-Script and run the code.

For personal use only

This product is intended for personal use exclusively. You are allowed to customize the templates to suit your needs. However, under no circumstances may you utilize this product for any commercial purposes, including charging fees, collecting payments, or receiving remuneration. Reselling, relicensing, or sub-licensing of this product is strictly prohibited.

Enquiries/Feedback

If you have any feedback or questions for Avo Tutorials, hit us up at kfkyyian@gmail.com

Hope this will help you get started on your automation journey.

Thank you! 🥑

Check out our YouTube channel. Avo Tutorials is created to document the interesting and cool things I've learned throughout my career/life. I hope the jubilant avocado brings you value too!