How to Integrate Elementor Form Responses with Google Sheets Using Pabbly Connect

Learn how to seamlessly integrate Elementor form responses into Google Sheets using Pabbly Connect. Follow our step-by-step guide for automation. 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

Setting Up Pabbly Connect for Elementor Form Responses

To begin integrating Elementor form responses into Google Sheets, we will use Pabbly Connect. First, access the Pabbly Connect dashboard by visiting the Pabbly website and signing in to your account. If you don’t have an account, you can quickly sign up for free.

Once logged in, navigate to the Pabbly Connect dashboard. Here, you can create a new workflow specifically for integrating Elementor with Google Sheets. Click the ‘Create Workflow’ button and name your workflow something descriptive like ‘Elementor Form Responses to Google Sheets’. After naming it, click ‘Create’ to proceed.

Configuring the Trigger with Elementor

In this step, we will configure the trigger using Pabbly Connect to capture responses from Elementor forms. Select Elementor as the trigger application and choose ‘New Form Submission’ as the trigger event. This event will activate the workflow each time a new form is submitted.

Copy the webhook URL provided by Pabbly Connect. Next, open your Elementor form settings. For each form you have (e.g., contact form and new form), click on the pencil icon to edit, then navigate to ‘Actions After Submit’. Click the plus icon to add a new action, select ‘Webhook’, and paste the copied URL. Ensure that you click ‘Update’ to save your changes.

Creating the Action Step in Google Sheets

Now that the trigger is set up, we will move on to creating the action step that sends the data to Google Sheets using Pabbly Connect. Start by adding a new action step and selecting Google Sheets as the action application. Choose the action event ‘Add New Row’ which allows us to insert data into our Google Sheets.

Connect your Google Sheets account to Pabbly Connect. Upon successful connection, select the spreadsheet where you want to store the data. In this case, it will be the ‘Elementor Form Submission’ spreadsheet. Choose the appropriate sheet (e.g., ‘Contact Form’) where the data will be added. Now, map the fields from the Elementor form responses to the corresponding columns in Google Sheets.

• First Name
• Last Name
• Email
• Phone Number
• City

After mapping all required fields, click ‘Save and Test Request’ to ensure everything works correctly. You should see the data appear in your Google Sheets under the selected sheet.

Setting Up the Router for Multiple Forms

To handle multiple forms effectively, we will utilize the Router feature in Pabbly Connect. This allows us to differentiate between responses from different forms and direct them to their respective sheets in Google Sheets. Add a Router step after the trigger and set the action event to ‘Conditionally Run’.

For each route, you will need to set up a filter based on the form name. For the first route, rename it to ‘Contact Form’ and set up a filter where the label is the form name, filter type is equal to, and the value is ‘Contact Form’. Repeat the process for the second form, naming the route ‘New Form’ and setting the appropriate filter.

After setting up the filters, add action steps for both routes to send the data to their respective sheets in Google Sheets. For the ‘Contact Form’ route, select Google Sheets and map the fields just like before. Do the same for the ‘New Form’ route, ensuring that the data is directed to the correct sheet.

Testing the Integration

With the setup complete, it’s time to test the integration using Pabbly Connect. Open your Elementor forms and submit test entries for both the contact form and the new form. After submitting, return to Pabbly Connect and check for incoming webhook responses. You should see the responses captured in the dashboard.

Verify that the data for each form appears in the correct Google Sheets. The contact form responses should populate in the ‘Contact Form’ sheet, while the new form responses should go to the ‘New Form’ sheet. This confirms that your integration is functioning correctly and data is being routed appropriately based on the form source.

By using Pabbly Connect, you have successfully automated the process of sending Elementor form responses to Google Sheets, saving time and ensuring accurate data management.

Conclusion

Integrating Elementor form responses into Google Sheets using Pabbly Connect streamlines data management. This tutorial provides clear steps to automate your workflow efficiently, ensuring accurate form response tracking.