Send Elementor Pro Form Submissions to Google Sheets

Want to automatically capture form submissions from your Elementor Pro forms and send them straight to Google Sheets? This guide walks you through setting up a simple workflow that does exactly that, no coding required.

Every time someone fills out your form, their information is automatically entered into your spreadsheet, keeping your data organized and accessible in real-time.

What You’ll Need

Before you start, make sure:

• Elementor Pro is installed and activated on your WordPress site
• The OttoKit plugin is installed and activated on the same site (Download from WordPress.org)
• An OttoKit account (sign up for free if you don’t have one yet)
• A Google Sheets account

Step 1: Connect OttoKit to Your WordPress Site

First, you need to establish a connection between OttoKit and your WordPress site.

1. In your WordPress dashboard, go to OttoKit in the sidebar.
2. Click Sign In and log in with your OttoKit account credentials.
3. This creates a connection between OttoKit and your site.

You can refer to this document for more information: Connect WordPress to OttoKit

Good to know: WordPress plugins like Elementor Pro don’t need a separate connection in OttoKit. Once Elementor Pro is installed and activated, you can immediately start building workflows with it.

Step 2: Create Your Form in Elementor

If you haven’t already created your form, here’s how:

1. Go to Pages in WordPress and open the page where you want your form (or create a new page).
2. Click Edit with Elementor.
3. In the Elementor sidebar, search for “Form” in the widgets search bar.
4. Drag and drop your preferred form widget onto the page.
5. Customize the form fields as needed (e.g., name, email, message).
6. Click Publish to save your page.

Make sure your form is live and accessible on the front end—you’ll need to submit a test entry later.

Step 3: Create Your Workflow in OttoKit

Now let’s set up the automation that connects your form to Google Sheets.

Create a New Workflow

1. In your WordPress dashboard, go to OttoKit → Workflows.

2. Click Create Workflow, from the dropdown, select Create from Scratch.
3. Enter a name for your workflow, like “Elementor to Google Sheets” or “Form Submissions Tracker”.
4. Click Create.

Add the Elementor Pro Trigger

A trigger is what kicks off your workflow. In this case, it’s whenever someone submits your form.

1. Click the plus (+) button to add a trigger step.
2. In the app’s search field, type Elementor Pro and select it.

3. Choose the Form Submitted trigger event.
4. Click Select Connection, then choose your WordPress site from the list. (Your site should appear automatically since you signed in earlier.)

5. Click Continue to open the Configure tab.
6. From the dropdown, select the specific form you want to track.
7. Click Continue to move to the Test Step.

Test Your Trigger

OttoKit needs to capture a real form submission to map the data correctly.

1. You’ll see a message: “We are waiting for the Form Submitted event…” with a 5-minute countdown timer.

2. Open a new browser tab and visit your form page on the front end (where visitors would see it).
3. Fill out the form with test data and click Submit.
4. Switch back to OttoKit. The form data should appear automatically.

5. Click Save to confirm and save the trigger data.

Great! Your trigger is now set up and knows what data to expect from your form.

Step 4: Add the Google Sheets Action

Now let’s tell OttoKit what to do with that form data, send it to Google Sheets.

1. Click the plus (+) icon below your trigger step to add an action.
2. In the apps search field, type Google Sheets and select it.
3. Choose the Add Row to Sheet action (or your preferred action).
4. Click Select Connection:
   • If this is your first time connecting to Google Sheets, click Create New Connection and follow the prompts to authorize OttoKit to access your Google account.
   • If you’ve already connected to Google Sheets, select your existing connection.

5. Click Continue to open the Configure tab.

Configure Google Sheets

1. Select Spreadsheet – Choose the Google Sheets file where you want the data to go (or create a new one in Google Sheets first).
2. Select Worksheet – Choose the specific sheet/tab within that spreadsheet.
3. Map Your Fields – Match your form fields to the spreadsheet columns:
   • For example, if your form has “Name”, “Email”, and “Message” fields, map them to the corresponding columns in your sheet.
   • Click in each field and select the matching data from your Elementor Pro trigger (they’ll appear with a purple tag icon).

4. Click Continue to move to the Test Step.

Test Your Action

1. Click Test to send your test data to Google Sheets.
2. OttoKit will attempt to add the row to your spreadsheet.
3. If successful, you’ll see a confirmation message.

4. Open your Google Sheet in a new tab to verify that the data appears correctly.

5. If everything appears to be in order, click Save.

Step 5: Activate Your Workflow

Your workflow is built, but it’s not running yet. Let’s turn it on.

1. At the top right corner of the workflow builder, click on the Publish button
2. You’ll see the status change to Update, showing it’s now active.

That’s it! Your workflow is now live and running in the background.

How It Works

From now on, every time someone submits your Elementor Pro form:

1. OttoKit instantly captures the submission
2. The data is automatically sent to your Google Sheets spreadsheet
3. A new row is added with all the form details

You don’t have to do anything manually. Your data flows automatically from form to sheet, keeping everything organized and up-to-date.

Tips for Success

• Test thoroughly – Submit a few test entries to make sure everything maps correctly
• Check your sheet structure – Make sure your Google Sheets columns match the data you’re sending
• Monitor your workflow – Check the workflow history in OttoKit occasionally to ensure everything is running smoothly
• Update field mappings – If you add or change form fields in Elementor, update your workflow by doing a new fetch data and updating the Google sheet action to reflect those changes

What’s Next?

Now that you’ve automated your form-to-sheets process, you can build on this workflow:

• Add email notifications when forms are submitted
• Send data to multiple sheets
• Filter submissions based on specific criteria
• Create conditional logic to handle different form responses

The possibilities are endless. You’ve just taken your first step into workflow automation with OttoKit, and there’s so much more you can do from here.

Ready to automate something else? Head back to OttoKit → Workflows and start building your next automation.