1.  Start with a Bot Builder: Create a new bot with keyword trigger or any other suitable trigger.
2.  Prompt for Complaint Number: Configure the bot to ask users to enter their complaint number.
3.  Select google sheets from add automation app: Securely authenticate with Google Sheets to access the required spreadsheet.
4.  Configure Sheet and Column Selection: Specify the correct sheet and columns to search for the complaint number.
5.  Store Search Results: Save the search outcomes in bot fields for subsequent steps.
6.  Implement a Router: Set up a router with filters to handle the scenarios of no match or successful match in the Google Sheets.
7.  Handle No Match Found: If no matching row is discovered, prompt the user to re-enter a valid complaint number.
8.  Respond with Complaint Status: If a match is found, the bot should inform the user of their complaint status.
9.  Enhance the Bot: Consider adding more bot fields and customizing the response messages for a better user experience.

Watch the video tutorial for a better understanding:

Official WhatsApp Business API, Meta Partner, Bulk WhatsApp Promotion, Marketing, Broadcast, Automation Notifications, Chatbot, CRM, WhatsApp number Banned Solution click chat.