Automated Thread Reminder and Closure System

[akanshaaa19]

Summary

Implement an automated system to send reminders to inactive support threads after 7 days and automatically close them

Current Behavior

• Support threads can remain open indefinitely without any activity
• Manual intervention is required to close abandoned threads
• Risk of tickets being forgotten or overlooked

Solution

7-Day Inactivity Reminder

• Check daily for threads inactive for 7+ days (no messages from users)
• Only process threads in the support forum channel (CHANNEL_ID)
• Skip threads that already have "resolved" tag
• Send reminder message mentioning thread creator and support team that due to inactivity we are closing this ticket
• Add "resolved" tag when auto-closing
• Update Google Sheets with closure information