• AI-Agent
  • Ready to Run

List Unsent Review Requests

Match completed orders to WhatsApp results and flag requests not sent

Use this Agent instantly or customize it - no programming needed

Reconcile completed-order review requests each morning
Reads
  • completed orders
    completed orders

    Your completed orders provide customer names, phone numbers, and order IDs for the daily check.

  • sent request results
    sent request results

    Your sent results show which review requests were recorded as sent and when.

  • unsent request results
    unsent request results

    Your unsent results show failed verification or sends and the recorded reasons.

Spreadsheet
Spreadsheet

Your spreadsheet supplies order details and WhatsApp results, then shows who needs follow-up.

Match each order to its latest logged result
Refresh each order's status and flag log issues
Writes
  • review request status
    review request status

    Your status tab shows each order's send status and flags missing or conflicting results.

List customers needing follow-up with phone numbers and reasons
Writes
  • follow-up list
    follow-up list

    Your list names customers with unsent or missing results, their phone numbers, and reasons for follow-up.

This Agent starts at your chosen morning time. It compares completed orders with logged WhatsApp results. It updates your spreadsheet with send statuses and a follow-up list.

Modify Agent

Customize this Agent to fit your needs using natural language.

Start Agent for Free

Enter your email address and we will send you a secure link to continue.

monday.com
Used as:
Show all Agents working with monday.com
Zoho Sheet
Used as:
Show all Agents working with Zoho Sheet

Made for your industry

List Unsent Review Requests is made for businesses in these industries.

Made for your role

List Unsent Review Requests is made for people in these roles.

Made for your department

List Unsent Review Requests is made for people in these departments.

How List Unsent Review Requests works

4 steps, in order, on every run.

  1. Read the review logRead completed orders and the sent and unsent WhatsApp results from your chosen spreadsheet.
  2. Match orders to resultsMatch entries by order ID and keep the latest result. Flag conflicting entries for your review.
  3. Flag requests needing follow-upFlag unverified numbers and failed or missing sends. Keep sent requests in the order status view.
  4. Refresh the follow-up listRefresh your spreadsheet with one status per completed order. List customers with phone numbers and reasons, or a missing-result flag.

How to Get Started

Connect your tools

Connect the tools you already use, such as monday.com or Zoho Sheet.

2 tools
Set your rules
  • Choose the spreadsheet and identify the completed-order, verified-and-sent, and unverified-or-not-sent tabs, with columns for order ID, customer name, phone number, verification result, send result, and result time.
  • Choose the tab where the owner should see each completed order's review request status and the customers needing follow-up.
  • Set the morning run time and the rule that an unverified number or a failed or missing send result is listed for follow-up; do not treat a send result as proof of delivery.
Launch the Agent

Use safe mode to approve every result before it goes out, or let the Agent run automatically.

FAQs

Frequently asked questions about the List Unsent Review Requests:

What do I need in my spreadsheet?

You choose the completed-order, sent, and unsent tabs, plus where you want the results. Your existing workflow must record verification and send results.

What if an order has no matching result?

Your follow-up list flags the missing result. You can review it without assuming the customer was unreachable.

Does sent mean the WhatsApp message was delivered?

No. Your log shows a send result, which does not confirm delivery.

What if log entries conflict or lack an order ID?

Your spreadsheet flags the affected rows for you. The Agent does not infer that a message was sent.

What happens when the Agent is unsure?

It stops and asks you. The Agent does not guess when it reaches a decision you have not approved.

Can I review its work?

Yes. Every run creates a plain-language log that you can review and export. Logs are kept for twelve months.

What happens if I cancel?

The Agent stops at the end of the billing month and its tool connections are removed. Your run logs remain available for twelve months.

Related Agents

Agents related to List Unsent Review Requests

More ready-to-run Agents for connected work.