Integrating Elementor Form Responses to Google Sheets with Pabbly Connect

Learn how to integrate Elementor form responses to Google Sheets using Pabbly Connect with this detailed step-by-step tutorial. Build sophisticated automated workflows in less time than you think. This guide translates complex integrations into straightforward steps for immediate implementation.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Automation

To begin integrating Elementor form responses with Google Sheets, first, access Pabbly Connect. Open your browser and search for Pabbly Connect to reach its landing page. Here, you will see options to either sign in or sign up for free, which is a quick process that provides you with 100 tasks monthly.

Once signed in, click on the ‘XEL Now’ button under Pabbly Connect. This action takes you to the dashboard where you can create a new workflow. This is the essential first step for setting up the integration that will automate the process of transferring form responses into Google Sheets.

2. Creating a New Workflow in Pabbly Connect

After accessing your Pabbly Connect dashboard, the next step is to create a new workflow. Click on the ‘Create Workflow’ button, which will open a prompt for naming your workflow. Name it something descriptive, like ‘Add Elementor Form Response to Google Sheets’ to reflect your objective. using Pabbly Connect

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

In the new window, you will see two boxes labeled ‘Trigger’ and ‘Action’. The trigger is the initial event that starts the workflow, while the action is what happens as a result. In this case, the trigger will be the new form submission from Elementor.

3. Setting Up the Trigger with Elementor

To set up the trigger, you need to select Elementor as your trigger application. Search for Elementor in the trigger application box and select it. After this, choose the trigger event, which in this case is ‘New Form Submission’.

Next, you will need to connect Elementor with Pabbly Connect using the webhook URL provided. Copy this URL as it will serve as the bridge between Elementor and Pabbly Connect. Now, navigate to your WordPress account where the Elementor form is created.

• Edit the Elementor form and go to ‘Action After Submit’.
• Select ‘Webhook’ and paste the copied URL.

After updating your form, you will return to Pabbly Connect, where it will be waiting for the webhook response from Elementor. This setup is crucial for establishing the connection between the two applications.

4. Adding Data to Google Sheets

Once the trigger is set, the next step is to configure the action that will add the form submission data into Google Sheets. In Pabbly Connect, select Google Sheets as your action application. Then, choose the action event, which should be ‘Add New Row’. using Pabbly Connect

Click on the ‘Connect’ button and select ‘Add New Connection’. You will be prompted to sign in to your Google account and grant permission for Pabbly Connect to access your Google Sheets. Make sure to allow the necessary permissions for seamless integration.

Choose the specific Google Sheets spreadsheet where you want the data to be added. Map the form fields to the corresponding columns in your Google Sheets.

This mapping ensures that every new form submission from Elementor is accurately recorded in your Google Sheets, keeping all your data organized in real-time.

5. Testing the Integration

With the workflow set up, it’s time to test the integration. Go back to your Elementor form and submit a new entry. For instance, fill in the first name as ‘Michael’, last name as ‘Caris’, and other required fields before submitting the form. using Pabbly Connect

After submitting the form, return to Pabbly Connect to check if the data has been received. You should see all the details populated as per your submission. This confirms that the integration is working correctly.

To verify, check your Google Sheets for the new row added with the submitted data. Repeat the process with different entries to ensure consistency.

This successful integration allows you to automate the recording of leads from your Elementor form directly into Google Sheets, streamlining your data management process.

Conclusion

By following this tutorial, you have learned how to integrate Elementor form responses into Google Sheets using Pabbly Connect. This automation simplifies data entry and ensures your leads are organized in real-time, enhancing your workflow efficiency.