Automate reminder emails for tickets with status "Waiting for Customer" and then auto-close after X days

Currently our "Waiting for Customer" status is configured to show in the Open Tickets view, so our agents can follow up (remind) customers that we're waiting on something for them.

This clutters the agent's "My Tickets" queue however, and also makes it difficult to load balance tickets across the team as some may have a high count of active tickets, but where many are really these waiting for customer tickets, skewing the active ticket count.

We want to set up something automated where:

For each day, once a day, for X number of days, an automated message is sent to the customer, reminding them that we are awaiting their response.
Then after X days of these email reminders, we want to send a different message that basically tells them that we have to close the ticket for now, but that they can reply back when they are ready to resume work on their ticket and their response will re-open their ticket (and at that point we want the ticket status to change from "waiting customer" to closed.

I did find some info about auto-closing tickets at the link below, but not sure how to combine this with the need to first send the customer several reminders over a span of X days, so that our agents don't need to follow up manually each day and so the ticket can remain in "waiting for customer" status (until customer replies or X days have passed which triggers auto-close of ticket)

https://help.zoho.com/portal/en/kb/desk/faqs/articles/using-automation-rules-to-auto-close-tickets

From a high level, what would be required to configure automated daily reminder emails for tickets in "waiting customer" status, and then have them auto-close (with a separate email notification explaining why the ticket is being closed)?

Thank you

Zoho Desk Resources

Desk Community Learning Series
Digest
Functions
Meetups
Kbase
Resources
Glossary
Desk Marketplace
MVP Corner
Word of the Day

Sticky Posts
Live Webinar - Work smarter with Zoho Desk and Zoho Workplace integration
Hello customers! Zoho Desk and Zoho Workplace are coming together for a webinar on 14th May, 2024. Zoho Workplace is a suite of productivity apps for email, chat, docs, calls, and more at one single place. Zoho Desk is closely integrated with a few tools
Apple iOS 17 and iPadOS 17 updates for Zoho Desk users
Hello Zoho Desk users! Apple recently announced the release of iOS 17 and iPad OS 17. These latest OS updates will help you stay productive and efficient, through interactive and seamless user experiences. Zoho Desk has incorporated the updates to help
Zoho Desk Partners with Microsoft's M365 Copilot for seamless customer service experiences
Hello Zoho Desk users, We are happy to announce that Zoho Desk has partnered with Microsoft's M365 to empower customer service teams with enhanced capabilities and seamless experiences for agents. Microsoft announced their partnership during their keynote
Zoho Desk Cheat Sheet For The Year-End
Check out these Zoho Desk best practices to end this year on a high and have a great one ahead! #1 Set Business (Holiday) Hours - If you have limited working hours, please make sure you restrict your business hours or set them as holidays for the coming days. Let your customers know when you will, and won't, be available. #2 Update the Annual Holiday List - Check the holidays for the new year and update the holiday schedule. Usually, holidays from the current year will be carried over for the next
Deprecation of older versions of ASAP Mobile SDK | Zoho Desk
Hello, everyone. Greetings from Zoho Desk ASAP! In order to continue to deliver the best and most secure experience to our mobile SDK users. On account of the recent enhancements and updates to the mobile SDKs, we have planned to mark the older versions