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

Learn how to integrate Elementor form responses into Google Sheets using Pabbly Connect. This tutorial covers step-by-step automation setup with accurate details. Master proven automation processes with practical implementation examples and strategic recommendations you can apply immediately in your workflow.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Elementor and Google Sheets Integration

To integrate Elementor form responses into Google Sheets, we will use Pabbly Connect. First, visit the Pabbly Connect website and sign in to your account. If you’re new, you can sign up for free and get 100 tasks each month.

Once logged in, you will see the dashboard. Click on the ‘Access Now’ button for Pabbly Connect, which will take you to the main interface. Here, we will create a workflow to automate the process of capturing form submissions and sending them to Google Sheets.

2. Creating a Workflow in Pabbly Connect

After accessing Pabbly Connect, you need to create a new workflow. Click on the ‘Create Workflow’ button located in the top right corner of the dashboard. A dialog box will appear, prompting you to name your workflow. Enter a name like ‘Add Elementor Form Response in Google Sheets with Date’.

• Name your workflow appropriately.
• Select a folder to save your workflow.
• Click on ‘Create’ to finalize the setup.

Now, your workflow is created, and you will see two sections: Trigger and Action. The Trigger section is where you will define what event will start the automation, and in the Action section, you will specify what happens next.

3. Setting Up the Trigger for Elementor Form Submission

In this step, we will set up the trigger for our workflow using Pabbly Connect. Click on the arrow in the Trigger section and select ‘Elementor’ as the trigger application. Choose ‘New Form Submission’ as the trigger event. This means that every time a new form is submitted via Elementor, it will trigger this workflow.

Pabbly Connect provides a unique webhook URL to connect Elementor to it. Copy this URL and open the Elementor form you created. In the Elementor editor, scroll down to the ‘Actions After Submit’ section and click the plus button to add a new action. Search for ‘Webhooks’ and select it. Paste the copied webhook URL into the provided field and click on ‘Update’ to save your changes.

4. Testing the Integration and Configuring Action Steps

Now that we have set up the trigger, it’s time to test the integration. Go back to your workflow in Pabbly Connect and click on the ‘Test Submission’ button in Elementor. Fill out the form with test data and submit it. Check back in Pabbly Connect to see if the response has been captured successfully.

Once the test submission is successful, we need to add an action step to format the date of the submission. Click the plus button in the Action section, select ‘Date/Time Formatter by Pabbly’, and choose ‘Current Date’ as the action event. This will help us record the submission date in Google Sheets.

• Select the basic date format (dd-mm-yyyy).
• Click on ‘Save & Send Test Request’ to confirm the date formatting.

After confirming the date format, we can proceed to the next action step, which is to send the data to Google Sheets.

5. Sending Elementor Form Data to Google Sheets

In this final step, we will send the captured form data to Google Sheets using Pabbly Connect. Click on the plus button for another action step and select ‘Google Sheets’ as the action application. Choose ‘Add New Row’ as the action event. This will allow us to add a new row in Google Sheets for each form submission.

Connect your Google Sheets account by clicking on ‘Connect’. Authorize the connection and select the spreadsheet and specific sheet where you want to store the form responses. Map the fields from Elementor to the corresponding columns in Google Sheets, ensuring that the date, first name, last name, email, and phone number are correctly aligned.

Map the date field to the current date from the previous step. Map the first name, last name, email, and phone number fields accordingly. Click on ‘Save & Send Test Request’ to finalize the setup.

Once the test request is successful, check your Google Sheets to verify that the data has been added correctly. This confirms that the integration between Elementor and Google Sheets through Pabbly Connect is working flawlessly.

Conclusion

In this tutorial, we learned how to use Pabbly Connect to automate the process of adding Elementor form responses to Google Sheets. This integration not only saves time but also ensures accurate record-keeping of form submissions with their respective dates. By following these steps, you can easily set up this automation for your own business needs.