How to Get WhatsApp Notification for New MySQL Row Added Using Pabbly Connect

Learn how to automate WhatsApp notifications for new MySQL rows using Pabbly Connect. Step-by-step guide for seamless integration. Discover how to seamlessly connect your essential tools through accessible instructions that make powerful automation available to professionals at every skill level.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Automation

To automate WhatsApp notifications for new MySQL rows, first access Pabbly Connect by typing the URL in your browser. This platform allows you to connect different applications without coding.

Once on the homepage, you will see options to sign in or sign up. If you are a new user, click on the ‘Sign up for free’ button to create your account. Existing users can directly sign in. After signing up, you receive 100 free tasks monthly to explore Pabbly Connect.

2. Creating a Workflow in Pabbly Connect

After signing into Pabbly Connect, navigate to the dashboard where you can create a new workflow. Click on the ‘Create Workflow’ button and provide a name for your workflow, such as ‘Get WhatsApp Notification for New Row in MySQL’.

• Select the folder to save your workflow.
• Click on ‘Create’ to initiate the workflow setup.

Once the workflow is created, you will see two windows: one for the trigger and one for the action. The trigger will be MySQL, and the action will be the WhatsApp Cloud API.

3. Setting Up MySQL Trigger in Pabbly Connect

In this step, select MySQL as the trigger application in Pabbly Connect. The trigger event should be set to ‘New Row in Table’. This means that whenever a new row is added to your MySQL database, it will trigger the workflow.

Next, connect your MySQL account by selecting either ‘Add New Connection’ or ‘Select Existing Connection’. If you choose to add a new connection, you will need to provide your database details such as username, password, and host name. Once connected, select the specific table you want to monitor.

• Choose the unique column, typically the ID, for the new row.
• Click ‘Save & Send Test Request’ to confirm the connection.

After testing, you will receive a response with the last data added to your MySQL database, confirming the successful setup of the trigger.

4. Configuring WhatsApp Action in Pabbly Connect

Now, select WhatsApp Cloud API as the action application in Pabbly Connect. The action event should be set to ‘Send Template Message’. This allows you to receive WhatsApp notifications based on the data captured from the MySQL trigger.

To connect your WhatsApp Cloud API account, click on ‘Add New Connection’ and enter the required details such as token, phone number ID, and WhatsApp business account ID. These can be found in your WhatsApp Cloud API setup under the API setup section.

Select the template you created for WhatsApp notifications. Map the dynamic fields from the MySQL response to the WhatsApp template.

After entering the details and mapping the fields, click on ‘Save & Send Test Request’. You should receive a WhatsApp notification confirming the successful setup.

5. Testing the Integration and Confirmation

Once you have configured both the MySQL trigger and the WhatsApp action, it’s time to test the entire workflow in Pabbly Connect. Add a new row to your MySQL database to trigger the workflow. After adding the row, click on ‘Save & Send Test Request’ in the WhatsApp action.

If everything is set up correctly, you will receive a WhatsApp notification with the details of the new row added to your MySQL database. This confirms that your automation is working as intended.

In summary, you have successfully integrated MySQL with WhatsApp using Pabbly Connect, allowing you to receive real-time notifications for new entries in your database. This automation can be beneficial for various applications, including customer queries or form responses.

Conclusion

In this tutorial, we demonstrated how to automate WhatsApp notifications for new MySQL rows using Pabbly Connect. This integration helps streamline notifications and improves efficiency in managing data updates.