Integrating Elementor Forms with Multiple Google Sheets Using Pabbly Connect

Learn how to effectively connect Elementor Forms data with multiple Google Sheets using Pabbly Connect in this detailed step-by-step tutorial. Implement the precise methodologies leading organizations use to automate repetitive tasks, illustrated with practical examples designed for immediate application.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect to Start Your Integration

To begin connecting Elementor Forms data with multiple Google Sheets, first, access Pabbly Connect. Log in to your Pabbly Connect account. If you don’t have an account, create one by following the link provided in the description to set up a free trial.

Once logged in, you will be directed to the dashboard where you can create a new workflow. Click on the ‘Create Workflow’ button and give your workflow a name, such as ‘Send Elementor Form Responses to Multiple Google Sheets’. This naming helps you identify the workflow later.

2. Setting Up the Trigger in Pabbly Connect

In your newly created workflow, you will need to set up a trigger. The trigger will initiate the workflow whenever a new form submission is received from Elementor. For this, select Elementor as your trigger application. using Pabbly Connect

• Choose Elementor as the app in the ‘Choose App’ section.
• Select the trigger event as ‘New Form Submission’.
• Copy the provided webhook URL for integration.

This webhook URL is essential as it allows Pabbly Connect to fetch data from your Elementor form submissions. Make sure to keep this URL handy as you will need it to connect with your Elementor form.

3. Connecting Your Elementor Form to Pabbly Connect

Next, navigate to your WordPress dashboard and edit the Elementor form you wish to connect. In the form’s settings, locate the ‘Actions After Submit’ tab and add a new action for Webhooks. using Pabbly Connect

• Paste the copied webhook URL into the Webhook URL field.
• Click the ‘Update’ button to save your form settings.

After updating, your Elementor form will be set up to send data to Pabbly Connect every time a user submits the form. You can now conduct a test submission to verify that the data is being captured correctly in Pabbly Connect.

4. Using the Router Feature in Pabbly Connect

To manage how data is sent to different Google Sheets based on user selections, utilize the Router feature in Pabbly Connect. This feature allows you to create separate routes for different choices made in the Elementor form.

Set up two routes: one for students who want to join the trip and another for those who do not. For each route, configure a filter that checks the user’s response. If the response is ‘Want to Join’, direct the data to the ‘Students Going’ sheet; if ‘Not Interested’, send it to the ‘Students Not Going’ sheet.

Create a new route for students who want to join. Set the filter to check if the response equals ‘Want to Join’. Repeat the process for the ‘Not Interested’ route with the appropriate filter.

This setup ensures that data is automatically sorted and sent to the correct Google Sheets based on user input, streamlining your data management process.

5. Finalizing Your Integration and Testing

After configuring the routes and filters, the final step is to connect Pabbly Connect to your Google Sheets. For each route, select Google Sheets as the action app and set the action event to ‘Add New Row’. This will allow you to insert data into the correct sheets based on the routing conditions. using Pabbly Connect

Make sure to map the data fields from the Elementor form submission to the corresponding columns in your Google Sheets. Test the connections by sending test requests and checking if the data appears correctly in the respective sheets.

Once everything is set up correctly, click ‘Save’ to finalize the workflow. Your integration is now complete, and data will flow automatically from Elementor Forms to multiple Google Sheets based on user choices.

Conclusion

In this tutorial, we explored how to connect Elementor Forms data with multiple Google Sheets using Pabbly Connect. By following the steps outlined, you can effectively manage form submissions and ensure data is organized according to user preferences.