Watch Step By Step Video Tutorial Below





1. Accessing Pabbly Connect for Review Alerts

To detect negative customer reviews and alert your manager, start by accessing Pabbly Connect. Visit pabbly.com and log in to your account by clicking the login button in the top right corner.

After logging in, navigate to Pabbly Connect Access Now. This is where you will create your workflow to automate the alerting process for negative reviews.

2. Creating a Workflow in Pabbly Connect

Once in Pabbly Connect, click on “Create Workflow” to start a new automation. Name your workflow “Detect Negative Customer Reviews and Alert Your Manager” and choose a folder for organization.

After naming your workflow, you will see options to select a trigger and action app. For this integration, choose Google Forms as the trigger app and Slack as the action app.

  • Select “New Form Response” as the trigger event.
  • Connect your Google account to allow Pabbly Connect to access form responses.
  • Choose the specific Google Form you want to monitor for negative reviews.

Once set up, every new form response will trigger the workflow, allowing you to capture customer feedback efficiently.

3. Setting Up Webhooks in Google Sheets

Next, you need to set up webhooks to send data from Google Sheets to Pabbly Connect. Open your Google Form responses in Google Sheets, and install the “Pabbly Connect Webhooks” add-on.

Once installed, go to Add-ons > Pabbly Connect Webhooks > Initial Setup. Here, paste the webhook URL provided by Pabbly Connect. This URL will facilitate data transfer from Google Sheets to your workflow.

  • Ensure to set the trigger column to the last column where data will be entered.
  • Test the webhook by sending a sample response to confirm the connection.

This setup is crucial for ensuring that every new response is sent to Pabbly Connect for processing.

4. Filtering Negative Reviews in Pabbly Connect

In your Pabbly Connect workflow, add a filter step after the webhook trigger. This filter will check if the customer rating is 2 or below.

Choose the appropriate field from the Google Forms response that contains the rating. Set the filter condition to “is less than or equal to” and enter the value of 2. This ensures that only negative reviews trigger the next action.

  • Make sure to save the filter settings.
  • Test the filter to ensure it correctly identifies negative reviews.

With the filter in place, your workflow will now only proceed if a negative review is detected.

5. Sending Alerts to Slack

The final step is to set up an action that sends a message to your Slack channel when a negative review is detected. In Pabbly Connect, choose Slack as the action app and select “Send Channel Message” as the action event.

Connect your Slack account and specify the channel where you want to send alerts. Customize the message to include relevant details such as the customer’s name, comment, and rating. This ensures your manager receives all necessary information at a glance.

  • Use dynamic fields from the Google Forms response to populate the message.
  • Test the Slack message to confirm it sends correctly.

Now, every time a negative review is submitted via Google Forms, your manager will receive an instant alert in Slack, thanks to Pabbly Connect.

Conclusion

By following these steps, you can effectively use Pabbly Connect to automate alerts for negative customer reviews, ensuring timely responses and improved customer service. This integration not only saves time but also enhances communication within your team.