Apps Script Auto-Reminder Emails [FULL BUILD]

🔗 Get the full custom sheet here - https://www.gotsheet.xyz/products/anniversary-reminder 📞 Get 1:1 help: https://www.gotsheet.xyz/products/consulting-call-with-eamonn ⭐ Get good at spreadsheets and automations: https://gotsheet.xyz/c/gotsheet-youtube This is a complete walkthrough of how to build an auto-email sheet so you stop forgetting your friend's birthdays and other important dates. I built this for myself, and I'll walk you through exactly how to build your own. If you want to skip to just having the sheet that works, you can get it at this link: https://www.gotsheet.xyz/products/anniversary-reminder ──────────────────── 💰 Deals & Tools • Convert PDFs and images to Excel - https://lido.app/link/eamonn • Connect Google Sheets or Excel directly to your business systems like CRMs, databases, and APIs - https://coefficient.io/?via=eamonn • 20% off Beehiiv (3 mo.): https://beehiiv.com/partners/got-sheet?via=eamonn • My full tech stack: https://gotsheet.xyz/c/business-tech-stack • My recommended gear: https://amzn.to/4l47CyW *Disclosure: affiliate links may earn me a small commission at no cost to you.* ──────────────────── 🌐 Site: https://eamonncottrell.com 📇 LinkedIn: https://linkedin.com/in/eamonncottrell 🐦 X/Twitter: https://twitter.com/EamonnCottrell 00:00:00 - intro 00:00:14 - why not calendar 00:00:38 - custom sheet 00:01:12 - running script 00:01:44 - how to build the sheet 00:03:42 - what the script will do 00:04:10 - Store the email address 00:04:54 - Setup the daily trigger 00:05:59 - verify the trigger 00:06:20 - making it easier 00:09:26 - manually check if it works 00:10:39 - get the prebuilt sheet