Automate weekly plug request metrics to Slack

Introduction

Keep your team aligned with a crisp weekly summary in Slack—total requests plus status-wise counts, delivered automatically. ✅

Trigger Event

A scheduled (cron) trigger runs once a week to prepare and post the report.

Actions

• The workflow calculates the current date and the same weekday from last week to define the reporting window.
• It fetches all “Plug Requests” from your viaSocket Table created within that last-week range.
• It tallies the total number of records and counts each status (e.g., Not Started, Started, Stuck, Completed). Variants like NOT_STARTED/ and NOTSTARTED are normalized to Not Started for accurate totals.
• A clear Slack message is posted to your selected channel showing:
  • Total requests last week
  • Status-wise breakdown (Not Started, Started, Stuck, Stuck from Client, Completed, Closed, Less Description Available)

Benefits

• Weekly update sent automatically—no manual exports
• Clear status breakdown for faster standups and planning
• Fewer errors vs. manual counting or copy-paste
• Keeps stakeholders informed in the channel they already use