Integrating MySQL with Elementor Forms Using Pabbly Connect: A Step-by-Step Guide

Learn how to automate MySQL database updates with Elementor form submissions using Pabbly Connect. Follow this detailed tutorial for seamless integration. Explore efficient methods for automating routine tasks with clear, concise instructions suited for both newcomers and experienced professionals.

Watch Step By Step Video Tutorial Below

1. Setting Up Pabbly Connect for MySQL Integration

To begin using Pabbly Connect for MySQL integration, first log into your account. If you don’t have one, you can create a free account in just two minutes. Once logged in, navigate to the dashboard to initiate your integration process.

Click on the blue button labeled ‘Create Workflow’ to start. You will be prompted to name your workflow; for instance, you can use ‘When Form is Submitted, Add Data to MySQL’. After naming, click the ‘Create’ button to proceed.

2. Setting the Trigger Event with Elementor Forms

In this section, we will set Elementor Forms as the trigger application in Pabbly Connect. Select ‘Elementor’ from the application list and choose the trigger event as ‘New Form Submission’. This event will initiate the workflow every time a new form is submitted.

• Select the Elementor application.
• Choose ‘New Form Submission’ as the trigger event.
• Copy the provided webhook URL for the next step.

After copying the webhook URL, go to your Elementor form settings. Under the ‘Actions After Submit’ section, select ‘Webhook’ and paste the copied URL. Don’t forget to update the form to save these changes.

3. Testing the Connection Between Elementor and Pabbly Connect

Now that the webhook URL is set, it’s time to test the integration. Go back to Pabbly Connect and click on ‘Test Trigger’. This will wait for a form submission to capture the data.

Open the Elementor form on your site and submit a test entry. Fill in the fields with dummy data and click ‘Submit’. Once the form is submitted, return to Pabbly Connect to see if the data has been captured successfully.

• Fill in the form with sample data.
• Click ‘Submit’ to send the data to Pabbly Connect.
• Check if the response is received in Pabbly Connect.

If successful, you will see the data from your form submission reflected in Pabbly Connect. This confirms that the connection is working as intended.

4. Connecting MySQL to Pabbly Connect

With the Elementor form successfully connected, the next step is to integrate MySQL as the action application in Pabbly Connect. Select ‘MySQL’ from the application list and choose the action event ‘Insert Row’. This action will add new entries to your MySQL database.

To establish the connection, click on ‘Add New Connection’. You will need to provide your MySQL database credentials, including username, password, host, and port. After entering these details, click on ‘Save’ to connect.

Enter your MySQL database username and password. Specify the host and port for your database. Click ‘Save’ to establish the connection.

Once connected, you will see all the tables from your MySQL database. Select the relevant table where you want to insert the data, ensuring that it matches the fields from your Elementor form.

5. Mapping Data to MySQL Fields

The final step is to map the data fields from your Elementor form to the corresponding fields in your MySQL database. In Pabbly Connect, select the table you want to update and refresh the fields to ensure they match.

Next, for each field in the MySQL table, click on the dropdown and select the corresponding data from the Elementor form. This mapping ensures that the correct data is inserted into the right columns in your database.

Once mapping is complete, click on ‘Save and Send Test Request’ to test the integration. If successful, the data will be inserted into your MySQL table, confirming the automation is working correctly.

Conclusion

This tutorial demonstrates how to integrate MySQL with Elementor forms using Pabbly Connect. By following these steps, you can automate the process of adding form submissions to your MySQL database, saving time and reducing manual effort.