How to Add Elementor Form Response in Google Sheets Using Pabbly Connect

Learn how to integrate Elementor form responses into Google Sheets using Pabbly Connect for seamless data management. 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 Automation

To start integrating Elementor form responses into Google Sheets, you first need to access Pabbly Connect. Begin by visiting the Pabbly Connect website and signing in to your account. If you are a new user, you can sign up for free and get free tasks every month.

Once logged in, you will see the Pabbly applications window. Click on Pabbly Connect to access the dashboard where you can create workflows. This platform allows you to automate processes between different applications seamlessly.

2. Creating a New Workflow in Pabbly Connect

After accessing Pabbly Connect, click on the button in the top right corner that says ‘Create Workflow’. A dialog box will appear prompting you to name your workflow. Name it ‘Add Elementor Form Response in Google Sheets’.

• Select a folder to save your workflow.
• Choose an existing folder or create a new one.
• Click on ‘Create’ to finalize your workflow setup.

Your workflow is now created with trigger and action windows visible. This setup is essential as it defines how the automation will function using Pabbly Connect.

3. Setting Up the Trigger with Elementor

To set up the trigger, select Pabbly Connect as your application, and choose ‘Elementor’ as the trigger application. For the trigger event, select ‘New Form Submission’. This means that whenever a new form is submitted in Elementor, it will trigger the workflow.

Pabbly Connect will provide you with a unique webhook URL. Copy this URL as it will be used to connect Elementor to Pabbly Connect. Navigate to the Elementor form you created and paste this webhook URL in the designated area under the webhook settings.

4. Testing the Trigger with a Form Submission

After updating the Elementor form with the webhook URL, it’s time to test the integration. Fill out the form with dummy data, such as a first name, last name, email, and phone number. Once completed, click on ‘Send’ to submit the form.

Return to your Pabbly Connect workflow dashboard to check if the response has been captured. You should see the details populated in the trigger section, confirming that Elementor successfully communicated with Pabbly Connect.

5. Setting Up the Action to Google Sheets

Now that the trigger is set up, you need to configure the action application. Select Pabbly Connect and choose ‘Google Sheets’ as your action application. For the action event, select ‘Add New Row’. This action will add the form submission details into Google Sheets.

Connect your Google Sheets account by clicking on ‘Connect’ and then ‘Add New Connection’. After signing in and allowing permissions, select the spreadsheet you created for storing form submissions. Map the fields from Elementor to the corresponding columns in Google Sheets, such as first name, last name, email, and phone number.

After completing the mapping, click on ‘Save and Send Test Request’ to check if the data is added to your Google Sheets. Once verified, you have successfully set up the integration using Pabbly Connect.

Conclusion

Integrating Elementor form responses into Google Sheets using Pabbly Connect is a straightforward process. By following the steps outlined above, you can automate data collection efficiently. This integration saves time and enhances data management for your business.