Develop an Automated Whatsapp Chatbot with Google Sheets Integration

We are seeking a skilled freelancer to develop and implement an automated reply system for WhatsApp. The primary goal is to create a robust auto-responder or chatbot capable of handling incoming messages efficiently based on predefined triggers and keywords. This system should significantly streamline our customer service and communication processes.

Key functionalities required include:
- Automatic replies to common inquiries and frequently asked questions (FAQs).
- Intelligent routing of conversations to appropriate human agents when the chatbot cannot resolve an issue.
- Seamless integration with Google Sheets for data management, logging interactions, or pulling dynamic content for replies.

We are looking for a solution that is reliable, scalable, and user-friendly. The ideal candidate will have experience in developing WhatsApp automation solutions and integrating with various APIs and data sources. Recommendations on the best tools and platforms to achieve this smoothly, ensuring compliance with WhatsApp's business policies, are highly valued. The project involves setting up the initial infrastructure, developing the chatbot logic, and ensuring the Google Sheets integration functions correctly.