Integrate Elementor Forms with Google Sheets Using Pabbly Connect

Learn how to integrate Elementor forms with Google Sheets using Pabbly Connect. This step-by-step tutorial guides you through the process with detailed instructions. Transform complex automation concepts into accessible, actionable steps that eliminate unnecessary manual work while maximizing existing application capabilities.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To begin integrating Elementor forms with Google Sheets, first access Pabbly Connect by typing ‘Pabbly.com’ in your browser. This platform allows seamless automation between applications.

Once on the Pabbly Connect website, navigate to the ‘Products’ section and select ‘Connect’. You can sign in or create a new account if you don’t have one. Pabbly Connect offers a free trial, allowing you to test the integration process.

2. Creating a Workflow in Pabbly Connect

After logging into Pabbly Connect, click on the ‘Create Workflow’ button. A dialog box will prompt you to name your workflow, such as ‘Elementor to Google Sheets’.

• Click on ‘Create’ to initiate the workflow setup.
• In the trigger window, select ‘Elementor’ as the app.
• Choose ‘New Form Submission’ as the trigger event.

This setup allows Pabbly Connect to respond to new form submissions made via Elementor forms, establishing the first part of the integration.

3. Setting Up Elementor Form for Pabbly Connect

Next, you need to edit your Elementor form. Click on the form you created and select ‘Edit with Elementor’. In the form settings, find the ‘Actions After Submit’ section.

Change the action to ‘Webhook’ and paste the webhook URL provided by Pabbly Connect. This URL is crucial as it directs the form data to Pabbly Connect for processing.

• After pasting the webhook URL, click ‘Update’ to save your changes.
• Test your form by submitting an entry.

By completing this step, you ensure that every new submission in Elementor is sent to Pabbly Connect, ready for the next action.

4. Capturing Data and Sending to Google Sheets

After submitting the form, return to Pabbly Connect and click on ‘Capture Webhook Response’. This action allows Pabbly Connect to record the data from your Elementor form submission.

Once the data is captured, you can proceed to set up the action in Pabbly Connect. Click on the ‘+’ button to add a new action.

Select ‘Google Sheets’ as the app for the action. Choose ‘Add New Row’ as the action event.

This configuration will append new entries to your specified Google Sheet, ensuring all form responses are recorded accurately.

5. Finalizing the Integration with Google Sheets

To finalize the integration, connect Pabbly Connect with your Google Sheets account. Select the appropriate Google account and grant the necessary permissions.

After connecting, choose the Google Sheet you want to use and map the fields from your Elementor form to the corresponding columns in Google Sheets. This ensures data is organized correctly.

Map the first name, last name, email, company, and mobile fields accordingly. Click ‘Save and Send Test Request’ to verify the integration.

Upon successful testing, your integration will be complete, allowing automatic data transfer from Elementor forms to Google Sheets every time a new submission occurs.

Conclusion

In this tutorial, we demonstrated how to use Pabbly Connect to automate the integration of Elementor forms with Google Sheets. This process simplifies data management and ensures that every form submission is accurately recorded.