# Create a weekly summary email using Schedule Workflow **URL:** \ **Category:** Ask for Help\ **Created:** [March 21, 2025, 1:09pm UTC](https://community.glideapps.com/t/create-a-weekly-summary-email-using-schedule-workflow/80887 "2025-03-21T13:09:32Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Andrew\_Davies](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/andrew_davies/32/41838_2.png) [@Andrew\_Davies](https://community.glideapps.com/u/Andrew_Davies)\ **Post date:** [March 21, 2025, 1:09pm UTC](https://community.glideapps.com/t/create-a-weekly-summary-email-using-schedule-workflow/80887/1 "2025-03-21T13:09:32Z")
Hello all I have a maintenance log for a museum - and would like to email various people a weekly report of outstanding maintenance issues. Can this be done within Glide without resorting Make? Hoping so, but not had any success trying to work it out for myself. Am thinking a scheduled workflow could loop through the list of issues, filtering as necessary, and build some HTML dynamically which forms the body of an email. I guess another option would be to create a Query in a table - and use that to build the HTML ? Thoughts welcome! Andrew ---
**Author:** ![MaximeBaker](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maximebaker/32/80877_2.png) [@MaximeBaker](https://community.glideapps.com/u/MaximeBaker)\ **Post date:** [March 21, 2025, 2:16pm UTC](https://community.glideapps.com/t/create-a-weekly-summary-email-using-schedule-workflow/80887/2 "2025-03-21T14:16:06Z")
Well everything can be done in the schedule workflow within Glide. ---
**Author:** ![MaximeBaker](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maximebaker/32/80877_2.png) [@MaximeBaker](https://community.glideapps.com/u/MaximeBaker)\ **Post date:** [March 21, 2025, 2:16pm UTC](https://community.glideapps.com/t/create-a-weekly-summary-email-using-schedule-workflow/80887/3 "2025-03-21T14:16:31Z")
You can use computer columns and integration to make custom emails in a loop. ---
**Author:** ![Andrew\_Davies](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/andrew_davies/32/41838_2.png) [@Andrew\_Davies](https://community.glideapps.com/u/Andrew_Davies)\ **Post date:** [March 21, 2025, 2:18pm UTC](https://community.glideapps.com/t/create-a-weekly-summary-email-using-schedule-workflow/80887/4 "2025-03-21T14:18:28Z")
I know it is wrong to reply to my own post, but I worked it out - unless there is a better way? This is how I did it in case it helps others For each row of the maintenance log - a template column to create some HTML ![Screenshot 2025-03-21 at 14.15.57](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/4/a411348f28d84a9c61ecc70494ccf07191f969e9.jpeg) ![Screenshot 2025-03-21 at 14.14.44](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/a/1af9665a148ddcfaa4e856ae22ba976e9a77f1ae.jpeg) 1 - A query to get new issues 2 - Lookup the template column 3 - Convert to a joined list - removing the comma 4 - Repeat 2 and 3 for in progress issues 5 - Pop it all into a template ![Screenshot 2025-03-21 at 14.17.48](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/2/02b74abbba2ebdeea202f2acbe8b927dbd39f19c.png) 6 - Loop through the users table and email to each Quite easy in the end! ---
**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:** [March 22, 2025, 12:12am UTC](https://community.glideapps.com/t/create-a-weekly-summary-email-using-schedule-workflow/80887/5 "2025-03-22T00:12:41Z")
It’s quite amazing what we can do within Glide these days, ain’t it. ---
**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:** [March 29, 2025, 12:13am UTC](https://community.glideapps.com/t/create-a-weekly-summary-email-using-schedule-workflow/80887/6 "2025-03-29T00:13:00Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.