Connect Elementor Form to Google Sheets with Pabbly Connect

Learn how to connect Elementor Form to Google Sheets using Pabbly Connect, ensuring automatic data transfer with record numbers for better tracking. 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 connect Elementor Form to Google Sheets, the first step is to access Pabbly Connect. You can do this by typing ‘Pabbly.com/connect’ in your browser’s address bar. Once on the Pabbly Connect website, you will need to sign in to your account.

If you are a new user, click on ‘Sign up for free’ to create an account and receive 100 free tasks monthly. Existing users can simply click ‘Sign in’ at the top right corner. After logging in, you will be directed to your dashboard, where you will find all Pabbly applications.

2. Creating a New Workflow in Pabbly Connect

Once you are on the Pabbly Connect dashboard, the next step is to create a new workflow. Click on ‘Create Workflow’ and name it ‘Connect Elementor Form to Google Sheets with Record Number’. Choose the appropriate folder for saving the workflow, such as ‘Google Sheets Automations’.

• Click on ‘Create’ to initiate the workflow.
• You will see two boxes: Trigger and Action.
• Select Elementor Form as the trigger application and ‘New Form Submission’ as the trigger event.

This step is crucial as it sets up the automation process. The trigger will activate whenever a new form submission is made in Elementor, and this will communicate with Pabbly Connect to proceed with the action.

3. Connecting Elementor Form to Pabbly Connect

To connect the Elementor Form to Pabbly Connect, you will need to generate a webhook URL. This URL acts as a bridge between Elementor and Pabbly Connect. Copy the webhook URL provided in the trigger step.

Next, navigate to your WordPress dashboard and locate the Elementor Form you want to integrate. Click on ‘Edit with Elementor’, then select the form field and go to ‘Actions After Submit’. Here, you will find an option for Webhook. Paste the copied webhook URL into this field and click ‘Update’ to save the changes.

4. Testing the Integration with Pabbly Connect

After setting up the webhook, it’s essential to test the integration. Go back to your Elementor Form and submit a test entry with dummy details. Once submitted, return to Pabbly Connect to check if the response has been captured.

• Check the captured response in Pabbly Connect to ensure it matches the submitted data.
• Make sure the City and other details are correctly recorded.

This step confirms that Elementor is successfully connected to Pabbly Connect and is ready to send data to Google Sheets.

5. Adding Data to Google Sheets with Pabbly Connect

The final step is to set up the action to add the captured data into Google Sheets. In Pabbly Connect, select Google Sheets as the action application and choose ‘Add New Row’ as the action event. Connect your Google Sheets account if you haven’t already done so.

Map the fields from the Elementor Form submission to the corresponding columns in Google Sheets. For instance, map the First Name, Last Name, City, and other relevant fields. Ensure to also include a Record Number that increments with each submission using the Number Formatter feature provided by Pabbly Connect.

After mapping the fields, click on ‘Save’ and then ‘Send Test Request’ to verify that the data is being added correctly to your Google Sheets. Check your Google Sheets to confirm the new entry has been recorded with the correct details and record number.

Conclusion

In this tutorial, we learned how to connect Elementor Form to Google Sheets using Pabbly Connect. This integration allows for automatic data transfer with record numbers, making it easy to track submissions efficiently. By following these steps, you can streamline your data collection process effectively.