Automate Feedback Processing Based on Slack ID

Introduction

Easily manage and respond to feedback with this automated workflow. Depending on the user's details, you can send either an email or a Slack message, and update your records instantly in Google Sheets. Perfect for teams seeking to boost efficiency and keep communication clear.

Trigger Event: Scheduled Daily Check

This workflow starts automatically every day at 10 AM. It scans for any submitted feedback, ensuring timely processing without manual intervention.

Actions

1. Check for Feedback Submission

The workflow first checks if new feedback has been submitted. This ensures only relevant entries are processed, skipping those that haven't provided new input.

2. Determine Contact Method

Depending on the feedback details, the workflow chooses the best way to respond:

a. Send Email (Gmail)

If there is no Slack ID provided by the user, an email is sent directly to their address. This makes sure everyone gets a response, even if they're not using Slack.

b. Send Direct Slack Message

If a valid Slack ID is available, the workflow sends a direct message on Slack. This allows for quick, real-time communication with your internal team members or stakeholders.

3. Update Google Sheets Record

After sending the response, the workflow marks the feedback as processed in your Google Sheet. This helps your team track which items have been addressed, cutting down on missed or duplicate responses.

Benefits of This Template

• Saves Time: Automates feedback responses and tracking so your team stays focused on important work.
• Improves Communication: Always responds via the user's preferred method—email or Slack.
• Keeps Records Updated: Automatic tracking ensures your follow-up actions are always documented and organized.

This template is an effortless way to keep your feedback loop efficient, traceable, and reliable.