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 tutorial on setting up the integration. Discover hidden automation capabilities within your existing tools. This guide shows you how to connect your essential applications and permanently eliminate redundant manual processes.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for WhatsApp Notifications

To get WhatsApp notifications for new MySQL rows added, you need to access Pabbly Connect. Start by typing the URL Pabbly.com/connect in your browser. Once there, you will see options to sign in or sign up for free. If you are new, click on the ‘Sign Up for Free’ button to create an account.

After creating your account, you will receive 100 free tasks each month to explore the platform. As an existing user, click on ‘Sign In’. This will take you to the dashboard of Pabbly Connect, where you can create and manage your workflows seamlessly.

2. Creating a Workflow in Pabbly Connect

Now that you are on the dashboard of Pabbly Connect, you need to create a new workflow. Click on the ‘Create Workflow’ option. A dialog box will appear asking you to name your workflow. Enter a suitable name, such as ‘Get WhatsApp Notification for New Row in MySQL’, and select the folder where you want to save it.

• Name your workflow appropriately.
• Select the correct folder for organization.

After naming your workflow, click on ‘Create’. You will now see two windows: one for the trigger and one for the action. Select MySQL as your trigger application, which will activate the workflow whenever a new row is added to your database.

3. Setting Up the MySQL Trigger in Pabbly Connect

In this step, you will set up MySQL as the trigger application in Pabbly Connect. Select the trigger event as ‘New Row in Table’. This means that the workflow will be triggered whenever a new row is added to your specified MySQL table.

To establish the connection, choose either to add a new connection or select an existing one. If you choose to add a new connection, you will need to enter your database details, including:

• Database Username
• Database Password
• Host Name
• Database Name
• Port

Once connected, select the table from which you want to capture new rows, and specify the unique column that identifies each row, such as ID. Click ‘Save’ and then ‘Send Test Request’ to verify the connection.

4. Setting Up WhatsApp Action in Pabbly Connect

Next, you will configure the action application in Pabbly Connect to send WhatsApp notifications. Choose ‘WhatsApp Cloud API’ as your action application and select the action event ‘Send Template Message’. Click on ‘Connect’.

To establish a new connection with WhatsApp Cloud API, you will need to provide the following details:

Access Token Phone Number ID WhatsApp Business Account ID

After entering these details, click ‘Save’. Next, select the template you created for sending messages, ensuring it contains placeholders for dynamic content like name, email, and phone number.

5. Testing the Integration in Pabbly Connect

Finally, it’s time to test your integration in Pabbly Connect. After setting up your WhatsApp action, enter the recipient’s mobile number where you want to receive notifications. Map the variables from the MySQL response to the WhatsApp template placeholders.

Click on ‘Save and Send Test Request’ to send a test message. You should receive a WhatsApp notification confirming the successful integration. Check your WhatsApp to see if the message has been delivered. If everything is set up correctly, you will receive notifications for every new row added in your MySQL database.

This automation allows you to efficiently monitor your MySQL database and receive timely updates through WhatsApp, enhancing your workflow and communication.

Conclusion

Using Pabbly Connect, you can easily automate WhatsApp notifications for new rows added in MySQL. This integration streamlines your workflow, ensuring you stay updated with real-time data.