# Automating daily email send **URL:** \ **Category:** Ask for Help\ **Created:** [September 22, 2022, 2:03pm UTC](https://community.glideapps.com/t/automating-daily-email-send/49913 "2022-09-22T14:03:39Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![MortenSchroeder](https://avatars.discourse-cdn.com/v4/letter/m/ecccb3/32.png) [@MortenSchroeder](https://community.glideapps.com/u/MortenSchroeder)\ **Post date:** [September 22, 2022, 2:03pm UTC](https://community.glideapps.com/t/automating-daily-email-send/49913/1 "2022-09-22T14:03:39Z")
Hi Gliders! I am building a date reminder app where users can input a date, and then they will get an e-mail reminders as they get close to that date (think: Never forget your wedding anniversary again!). I have all functionality built and final step missing is getting the e-mails to send. I understand I need to use a Make/Zapier integration to get the e-mails to fire, but the issue I am struggling with is how to AUTOMATE the email sending even when the user has not clicked anything. I essentially need to set up a task that runs on a daily basis and checks if any e-mail alerts needs to be sent. THANK YOU so much! ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [September 22, 2022, 2:27pm UTC](https://community.glideapps.com/t/automating-daily-email-send/49913/2 "2022-09-22T14:27:35Z")
Steps to do it with Google Sheets: - First, let users choose a date first. This will come with a year, though, and I assume you don’t want the year part. - Add an arrayformula to calculate this year’s reminder. Extract the day and month of the original date, and append the current year. You might want to consider the 29th February case, though, since it’s an outlier with this approach. - Every day, say at 7AM, run a Make scenario to loop through all your “reminder” rows. Check if any rows has a date that matches the current day in Make (make sure you have the correct format to check, i.e both sides must follow the same format). - Send emails with the matching rows. ---
**Author:** ![MortenSchroeder](https://avatars.discourse-cdn.com/v4/letter/m/ecccb3/32.png) [@MortenSchroeder](https://community.glideapps.com/u/MortenSchroeder)\ **Post date:** [September 22, 2022, 4:38pm UTC](https://community.glideapps.com/t/automating-daily-email-send/49913/3 "2022-09-22T16:38:39Z")
ThinhDinh! Amazing. THANK YOU!! I have steps 1 and 2 sorted already. Users add a date (including year) and I strip the year away and append current year and then current year +1 (in case we already passed their birthday this year), so once we move to 2023, the whole approach shifts by itself so all good on this one. Any chance you can elaborate on the ‘run a Make scenario to loop through all your reminder rows’? Currently I’m hosting all the data inside Glide’s data editor (as opposed to Google sheet). Do you propose I first move the data out to sit in Google Sheet? And then there’s a functionality in Make where I schedule it to sift through all the rows looking for e-mails to send, correct? ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [September 23, 2022, 12:17am UTC](https://community.glideapps.com/t/automating-daily-email-send/49913/4 "2022-09-23T00:17:58Z")
> [@MortenSchroeder](#): > > Do you propose I first move the data out to sit in Google Sheet? And then there’s a functionality in Make where I schedule it to sift through all the rows looking for e-mails to send, correct? Yeah, that’s the plan. At the moment the “read” query for Glide Tables only work for business plans upwards, so that’s why I advised you to move things to Google Sheets. ---
**Author:** ![MortenSchroeder](https://avatars.discourse-cdn.com/v4/letter/m/ecccb3/32.png) [@MortenSchroeder](https://community.glideapps.com/u/MortenSchroeder)\ **Post date:** [September 23, 2022, 1:09am UTC](https://community.glideapps.com/t/automating-daily-email-send/49913/5 "2022-09-23T01:09:10Z")
Gotcha. I’ve migrated my page into Google Sheet now (What a pain. Very surprised there’s not just a function to sync your existing Glide data tables into GS). I basically had to rebuilt the whole thing from scratch, and once you change the data source, even the front-end updates. OH well. It’s done now. I will start exploring building the Make script. I hope it’s okay I reach out in case I can’t figure out to do it. But at least it sounds like I’m on the right track now 🙂 ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [September 23, 2022, 2:19am UTC](https://community.glideapps.com/t/automating-daily-email-send/49913/6 "2022-09-23T02:19:28Z")
> [@MortenSchroeder](#): > > I will start exploring building the Make script. I hope it’s okay I reach out in case I can’t figure out to do it. But at least it sounds like I’m on the right track now 🙂 Completely fine. Let’s keep the discussion here so if I’m not available, others can chime in, unless you need to share private data. ---
**Author:** ![MortenSchroeder](https://avatars.discourse-cdn.com/v4/letter/m/ecccb3/32.png) [@MortenSchroeder](https://community.glideapps.com/u/MortenSchroeder)\ **Post date:** [September 24, 2022, 5:22pm UTC](https://community.glideapps.com/t/automating-daily-email-send/49913/7 "2022-09-24T17:22:08Z")
Hi ThinhDinh, I’ve been looking into the Make integration and I’m running into an issue: The Make ‘watch’ integration watches the entire Google sheet workbook and not just a single column. So just adding a new birthday (a new row) triggers the watch integration and it includes all this irrelevant info. Do you have an idea how I can get around this issue? I have some ideas for solution but they are all really complicated and involves building macros that just make the whole thing even more complicated. Thanks ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [September 24, 2022, 5:39pm UTC](https://community.glideapps.com/t/automating-daily-email-send/49913/8 "2022-09-24T17:39:11Z")
> [@MortenSchroeder](#): > > The Make ‘watch’ integration watches the entire Google sheet workbook and not just a single row. Don’t use watch, use Search Rows: ![Screen Shot 2022-09-25 at 1.36.16 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/1/f160b450b7050b0ad800dcd4103d4d5ef38bec65.png) With that, you can specify exactly which sheet to search and which criteria to look for. And then set your whole scenario to run on a schedule, eg. once per day (or whatever). ![Screen Shot 2022-09-25 at 1.36.44 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/9/890bb5a33d4c274195d9df669508422dcbbe884b.png) ---
**Author:** ![MortenSchroeder](https://avatars.discourse-cdn.com/v4/letter/m/ecccb3/32.png) [@MortenSchroeder](https://community.glideapps.com/u/MortenSchroeder)\ **Post date:** [September 24, 2022, 5:52pm UTC](https://community.glideapps.com/t/automating-daily-email-send/49913/9 "2022-09-24T17:52:35Z")
BOOOM! Darren\_Murphy I think this is spot on. Let me try this approach. THANK YOU ---
**Author:** ![MortenSchroeder](https://avatars.discourse-cdn.com/v4/letter/m/ecccb3/32.png) [@MortenSchroeder](https://community.glideapps.com/u/MortenSchroeder)\ **Post date:** [September 24, 2022, 6:58pm UTC](https://community.glideapps.com/t/automating-daily-email-send/49913/10 "2022-09-24T18:58:05Z")
@Darren_Murphy You are genius! IT WORKS! I love this. I can come up with so many use cases of this. Thanks so much!! ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [September 25, 2022, 12:54am UTC](https://community.glideapps.com/t/automating-daily-email-send/49913/11 "2022-09-25T00:54:11Z")
In this case I would do it once a day. For cases where you need it to be more frequent than once a day, please beware that each search counts against your quota, so don’t do it too frequently (say every minute), otherwise you will run out of your quota in no time. ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [September 26, 2022, 12:54am UTC](https://community.glideapps.com/t/automating-daily-email-send/49913/12 "2022-09-26T00:54:43Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.